Microsoft Office Tutorials and References
In Depth Information
Datasheet for Position table after entering the first field value
Trouble? If you make a mistake when typing a value, use the Backspace key to delete
characters to the left of the insertion point or the Delete key to delete characters to the
right of the insertion point. Then type the correct value. If you want to correct a value by
replacing it entirely, drag to select the value, and then type the correct value.
The pencil symbol in the first row’s record selector indicates that the record is being
edited. The star symbol in the second row’s record selector identifies the second row as
the next one available for a new record. Notice that all the fields are initially empty; this
occurs because you set the Default Value property for the fields (as appropriate) to remove
any values and leave them blank.
4. Type Waiter/Waitress in the PositionTitle field, and then press the Tab key. The insertion
point moves to the EmployerID field.
5. Type 10155 and then press the Tab key. The insertion point moves to the right side of the
Recall that the PositionID, PositionTitle, and EmployerID fields are all text fields and that
the Wage field is a currency field. Field values for text fields are left-aligned in their boxes,
and field values for number, date/time, and currency fields are right-aligned in their boxes.
6. Type 9.5 and then press the Tab key. Access displays the field value with a dollar sign and
two decimal places ($9.50), as specified by the currency format. You do not need to type
the dollar sign, commas, or decimal point (for whole dollar amounts) because Access adds
these symbols automatically for you.
7. In the HoursPerWeek field, type 30 , press the Tab key, type 1 in the Openings field, and
then press the Tab key.
8. Type Sue Brown in the ReferredBy field, and then press the Tab key. Depending on your
monitor’s resolution and size, the display of the datasheet might shift so that the next field,
StartDate, is completely visible.
9. Type 6/30/2006 in the StartDate field, and then press the Tab key. Access displays the
value as 06/30/2006, as specified by the custom date format (mm/dd/yyyy) you set for this
field. The insertion point moves to the final field in the table, EndDate.