|
In the
beginning of this book we created a Rating Table to add Rating data
to the Movie Table. In this lesson, we will create the Genre Table
and use it to filter data in the Movie Table.
1.
Try it: Create a New Table The
Database is open. Go to
Create ->Tables->Table Design. Enter a Field
Name: GenreID. Data Type:
AutoNumber. GenreID is
still selected. Go to
Table Tools->Design->Tools. Click on
Primary Key. Enter a Field
Name: Genre. Data Type:
Text. Do
This, Now: Save the Table Go to
File->Save.
Enter a Table Name:
tblGenre
Click OK.
So far, so
good. Keep
going...
Create ->Tables->Table Design
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.1.1. Create tables in Design View
|
|
| |
