Click to Add a Field

A Table in Access looks like a spreadsheet in Microsoft Excel. At the top there is a Header Row with the labels. The first Column in this Table is the ID, an Autonumber, which we will discuss in a minute. You can Click to Add a Field.

 

3. Try it: Click to Add a Field

Go to Click to Add.

Select a Field Type: Text

 

What Do You See? The Field Types are:

Text

Number

Currency

Date & Time

Yes/No

Lookup & Relationship

Rich Text

Memo

Attachment

Hyperlink

Calculated Field

 

At the bottom of the list is Paste as Fields.

Keep going...

Click to Add

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Add a Text Field