Lab #10 Databases

More Tables / Data Types

1. Create two more tables, tableVenues and tableEvents as shown below.

tableVenues will look this:

and tableEvents will look like this (we will add data to this table later):

Every field has a data type.

The ID field has the data type AutoNumber. It's called AutoNumber because it is automatically filled with a number whenever you create a new record.

Other fields that you create are given the data type Text, but you can change that, and we will:

2. Make sure that the events table is selected, then select the Home tab (see the image below) and click on the View drop-down. You'll probably see 4 view options. We have been viewing our tables in Datasheet View, but now we want to look at them in Design View so click on the Design View icon. (PivotTable View and PivotChart View allow you to build special table and chart views, but we won't learn about those in this class).

In this view (shown in the image below), you can't see the data you entered, but you can see information about each field. Notice the little key symbol next to the ID field. This indicates that this field is the Primary Key.

Notice that the data type for the ID field is AutoNumber as described above.

The data type for PerformerID and VenueID is Text.

3. Change the data type for these two fields to Number:

4. Save the table as tableEvents

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