BobbyMaynard

New Member
Joined
Jan 4, 2019
Messages
10
Ok, im very new to Microsoft Access. My database knowledge comes from trail and error on SQL databases for Forums Like "PHP FUSION" I can pretty much do what ever i want using the sql command box. SO for my very first newbie question out of many to come im sure!

Can you use sql santax in Access to create databases, add fields ect?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hi,
In Access you wirte SQL Statements with queries.. So if you look at the ribbons you find Queries once you have selected those queries you can find a button SQL
Basically you can write SQL Statemenst rather then queries.
Or you can use in Access VBA also SQL Statements to perform what ever you need to do.

HTH
 
Upvote 0
I dont see an attach Snippet for this forum or i would upload a picture of the database i been building with excel. It looks nice, but Im not happy with it, in order to improve it i need to know more about MS Access
 
Upvote 0
I dont see an attach Snippet for this forum or i would upload a picture of the database i been building with excel. It looks nice, but Im not happy with it, in order to improve it i need to know more about MS Access
Building with ACCESS not excel. Got to many things going on at once i guess.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top