800 Chapter 26 Create Databases and Simple Tables
- Click the cell under Click to Add, and type the following information into the next
seven cells, pressing Tab after each entry:
Gode
612 E. 2nd
Pocatello
ID
73204
USA
208 555-0161
As the cursor moves to the next cell, the name of the field in which you just entered
data changes to Field followed by a sequential number.
The first complete record.Tip Don’t be concerned if your screen does not look exactly like ours. In this graphic,
we’ve scrolled the page and adjusted the widths of the columns so that you can see all
the fields. For information about adjusting columns, see “Manipulating Table Columns
and Rows” later in this chapter.- Double-click the ID field name (not the ID value in Field5), and then type
CustomerID to rename it.
Tip Field names can include spaces, but the spaces can affect how queries have to be
constructed, so it is best not to include them. For readability, capitalize each word and
then remove the spaces, or use underscores instead of spaces. - Repeat step 7 for the other fields, changing the field names to the following:
Field1 FirstName Field4 City Field7 Country
Field2 LastName Field5 State Field8 Phone
Field3 Street Field6 ZIP
The table now has intuitive field names.