Look For Clues in the Design

2. Try it: Return to the Design View

Go to Home ->Views->View.

Select a View: Design View.

 

Try This, Too: Find the Primary Key

Select a Field: ID

 

What Do You See? The ID Field is different from the Text Fields we have been editing.

 

This is the Primary Key. The Primary Key uniquely identifies each record. It is an Integer, a Whole Number.

 

A Primary Key cannot be empty, or null. The value entered for the Primary Key cannot be duplicated.

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View

Home ->Views->View->Design View