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.

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View

Create ->Tables->Table Design