Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Building Your Database Tables
The business of creating a database table starts on the Create tab. As I
explain in detail in the next pages, Access offers three ways to create a
✦ Create the database table from scratch: Enter and format the fields one
at a time on your own.
✦ Get the help of a template: Get prefabricated fields assembled in a
table. This is the way to go if you know Access well, and you can modify
database tables and table fields.
✦ Import the database table from another database: This technique can
be an enormous timesaver if you can recycle data that has already been
entered in a database table in another Access database.
Creating a database table from scratch
Creating a table from scratch entails creating the table and then entering the
fields one by one. After you open a database file, follow these steps to create
a database table from scratch:
1. Go to the Create tab.
2. Click the Table Design button.
The Design window appears. From here, you enter fields for your
database table. I hate to be like a City Hall bureaucrat who gives everybody
the runaround, but I can’t help myself. Turn to “Entering and Altering
Table Fields” later in this chapter to find out how to enter fields in a
3. Click the Save button on the Quick Access toolbar.
The Save As dialog box appears.
4. Enter a descriptive name for your table and click OK.
Return to the Navigation pane and you see the name of the table you
created. If you don’t believe me, click the Tables group to see the names
of tables in your database.
Creating a database table from a template
If you know your way around Access and know how to modify database
tables, you can do worse than create a database table with a template.
Access offers four table templates: Contacts (for storing contact addresses
and phone numbers), Issues (for prioritizing issues), Tasks (for tracking
projects, their status, and when they are due), and Users (for storing e-mail
addresses). As well as creating a table, Access creates ready-made queries,