graphic2
graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.1 Create a Table: Create Tables in Third Normal Form (3NF)

Create the MovieRented Table

The MovieRented Table stores all of the numbers (Keys and Dates) that were selected in the Form and Subform.

 

3. Try it: Create the MovieRented Table

Go to Create ->Tables->Table Design.

Add the following Fields and Data Types:

 

MovieRentedID

AutoNumber

ReceiptID

Number

CustomerID

Number

MovieID

Number

DateRented

Date/Time

 

Try This, Too: Create the Primary Key

Select MovieRentedID.

Go to Table Tools->Design->Tools.

Click on: Primary Key.

 

Please, Do This: Save the Table

Go to File->Save.

Enter a name: tblMovieRented.

 

That's two Tables. Close tblMovieRented.

Create ->Tables->Table Design