In This Chapter:

Table Basics

Now that Michael has generated a blank database, it is time to create tables in it. He goes over the table basics, the table contents, and its properties.

Fields and Records

Michael decides to talk to George about the various field properties. George explains each field property in detail.

Creating a Table using the Table Wizard

You can create a table using the table wizard. The wizard has both personal and business sample databases.

Creating a Table in the Datasheet View

Here we go over creating a new table directly from the datasheet view.

Defining Tables

Michael has a complete list of fields and attributes to be stored in the tables. He has also defined the structure of the database and the various reports to be generated. He decides to create his tables in design view.

Creating Tables in Design View

Finally Michael begins to build the tables in MS Access.

Relationships

Now we setup the relationships between your tables.