Add the Text Fields

4. Try it: Edit the New Text Field

Select the Field Name: Field1

Go to Table Tools->Fields->Properties.

Click on Name and Caption.

Edit the Name: FirstName


Try This, Too: Add Another Text Field

There are several ways to add Fields to a Table. The previous page used Click to Add. The next Field will be added with the Table Tools.
 

Go to Table Tools->Fields.

Go to Add & Delete->Text.

Edit the Field Name: LastName

 

Thoughts to Consider: Should the Field names include spaces? It is usually better to skip the spaces in a Field name. When Microsoft Access finds a Field name with spaces, the database will alter the name with an underscore like this: Last_Name.

 

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Modify the Field Description (Name and Caption)

Table Tools->Fields->Add & Delete->Text