Lab #10 Databases

Tables and Keys

Now that you have a database, you need to create tables which will store the data.

Your first table will look like this when it is completed

1. You should have a table waiting to have information added. If not, click on the Create tab, then click on the Table icon:

In Access, the columns of a table are called fields. As you can see below, the first field has been automatically created and named ID (the ID will be the primary key).

2. To create your second field, double-click on Add New Field and type Performer. It should look like this:

3. Hit the Enter key to accept the name

4. Make two more fields: TypeOfMusic and Description.

Now you'll start entering data in the table.

5. Put your cursor in the cell under Performer and type Aventura (which is the name of a band). Notice the ID filled in automatically (in yours it may be a number 1 rather than a 3 as you see here).

6. Type in more data until you have this (don't worry if the ID numbers are different, and feel free to enter whatever information you want in the Description field):

7. To save your table, do one of the usual things (i.e., click on the Save icon in the upper left-hand corner or click on the Office button and choose Save or right-click on the tab labeled Table1). Give it the name tablePerformers

Once it's saved, the name will appear in the list on the left side of the screen:

Next, you will create two more tables

Introduction | Create Database | Tables & Keys | Data Types | Link Tables | Basic Query | More Queries