Creating tables

  • Thread starter Thread starter Link
  • Start date Start date
L

Link

I am trying to learn Access on my own. I need help with creating a table
from a database file. How do I get started.
 
Do the following:

1. Start MS Access.
2. Click "Blank Database" in the "New Task" pane at left window.
3. Enter your desired File Name. For example, "myDatabase" and click Create.
4. Your database window will appear with respective Objects group title.
5. Click "Tables" under the Objects group.
6. Click "New" button above Objects group and below Database title.
7. Select "Table Wizard" and click OK.
8. Follow the instruction.

You're on way to create your first table.

Good Luck.
 
1. Open your database.
2. Click "Tables" under the Objects group.
3. Click "New" button above Objects group and below Database title.
4. Select "Table Wizard" and click OK.
5. Follow the instruction.
 
I am trying to learn Access on my own. I need help with creating a table
from a database file. How do I get started.

That's a bit like saying that you want to create a memo from a filing cabinet.

Here are some useful resources; you might want to start with Crystal's video
or text tutorial.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
In addition to the other help you are already receiving, be aware that an
Access table is NOT a spreadsheet, even though it looks like one. If you
aren't familiar with "relational database design" or "normalization", plan
to spend some time learning about these before setting up your first
table...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top