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 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