Microsoft Office Tutorials and References
In Depth Information
9. Press the Tab key, type 1 in the Openings field, and then press the Tab key. Access saves
the record in the Position table and moves the insertion point to the beginning of the fourth
row. See Figure 2-28.
Position table datasheet with third record added
As you add records, Access places them at the end of the datasheet. If you switch to Design
view and then return to the datasheet, or if you close the table and then open the
datasheet, Access will display the records in primary key sequence.
For many of the fields, the columns are wider than necessary for the field values. You
can resize the datasheet columns so that they are only as wide as needed to display the
longest value in the column, including the field name or caption (if set). Resizing
datasheet columns to their best fit improves the display of the datasheet and allows you to
view more fields at the same time.
To resize the Position datasheet columns to their best fit:
1. Place the pointer on the line between the PositionID and PositionTitle field names until the
pointer changes to a
2. Double-click the pointer. The PositionID column is resized so that it is only as wide as the
longest value in the column (the caption for the field name, in this case).
3. Double-click the pointer on the line to the right of each remaining field name to resize
all the columns in the datasheet to their best fit. See Figure 2-29.
Datasheet after resizing all columns to their best fit
Notice that all nine fields in the Position table are now visible in the datasheet if they were
not visible before.
You have modified the Position table structure and added one record. Next, you need to
obtain the rest of the records for this table from another database, and then import the two
tables from the Seasonal database (Employer and NAICS) into your Northeast database.