Add Data to the Table

Before You Begin: Change the View

Go to Table Tools->Design->Views->View.

Select a View: Datasheet 
 

2. Try it: Add Data to the Table

Enter the following in the Ratings column:

G

PG

PG13

PG14

PG15

R

X

NR

 

What Do You See? Access added an AutoNumber to each new record.

 

Close tblRating. Keep going...

 

Memo to Self: The information in the Rating Table is considered static data: it does not change very often. Does the Rating table need a Form for data entry? Probably not.

Table Tools ->Design->Views->View

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View