Create the Receipt Table

1. Try it: Create a Receipt Table

Go to Create ->Tables->Table Design.

Add the following Fields and Data Types:

 

ReceiptID AutoNumber
CustomerID Number
DateRented Date/Time

 

Try This, Too: Create the Primary Key

Select ReceiptID.

Go to Table Tools->Design->Tools.

Click on: Primary Key.

 

Each record in the Receipt Table will be unique: no duplicates.

Create ->Tables->Table Design

 

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Define Primary Keys