3. Click and drag the row selector for the Last Name field up one row, so the black line appears between the First Name and ID fields. When the black line is between the First Name and ID fields, release the mouse button. The Last Name field now appears between the ID and First Name fields. 4. In the design grid, double-click the word Appointment in the Appointment Date field. 5. Type Appt and then press the down key. The field name changes to The Job Appt Date. Number field is selected. 6. With the Job Number field selected, click the Insert Rows button in the Tools group on the Design tab. A new row is inserted above the Job Number field. 7. Type Confirmed and then press Tab. 8. Click the Data Type arrow for the Confirmed field. Figure 2–9 shows the list of data types. FIGURE 2–9 Data Type list for the Confirmed field 9. In the list, click Yes/No. 10. On the Quick Access Toolbar, click the Save button . Leave the table open for the next Step-by-Step. Description The in the design grid is an optional field property that you can use to Description property describe what to enter in the field. When you give your fields descriptive names, it helps you remember the field values to enter in the fields. For example, the Last Name field name easily communicates what field values to enter in the field. When you are entering data in the field, the Description property can remind you what field value to enter, because it appears on the status bar in Datasheet view. For example, Figure 2–10 shows that the Description property for the Confirmed field in the Applicant table was set to In this case, the Description Has the interview been confirmed? property makes it easier to enter the field value. Because this field uses the Yes/No data type, the field value is (the check box contains a check mark) if you confirmed the interview; Yes otherwise, the field value is (the check box is empty). No
3. Click and drag the row selector for the Last Name field up one row, so the black line appears between the First Name and ID fields. When the black line is between the First Name and ID fields, release the mouse button. The Last Name field now appears between the ID and First Name fields. 4. In the design grid, double-click the word Appointment in the Appointment Date field. 5. Type Appt and then press the down key. The field name changes to Appt Date. The Job Number field is selected. 6. With the Job Number field selected, click the Insert Rows button in the Tools group on the Design tab. A new row is inserted above the Job Number field. 7. Type Confirmed and then press Tab. 8. Click the Data Type arrow for the Confirmed field. Figure 2–9 shows the list of data types. FIGURE 2–9 Data Type list for the Confirmed field 9. In the list, click Yes/No. 10. On the Quick Access Toolbar, click the Save button . Leave the table open for the next Step-by-Step. Description The Description property in the design grid is an optional field property that you can use to describe what to enter in the field. When you give your fields descriptive names, it helps you remember the field values to enter in the fields. For example, the Last Name field name easily communicates what field values to enter in the field. When you are entering data in the field, the Description property can remind you what field value to enter, because it appears on the status bar in Datasheet view. For example, Figure 2–10 shows that the Description property for the Confirmed field in the Applicant table was set to Has the interview been confirmed? In this case, the Description property makes it easier to enter the field value. Because this field uses the Yes/No data type, the field value is Yes (the check box contains a check mark) if you confirmed the interview; otherwise, the field value is No (the check box is empty).
Access%20Lesson%202%20Walkthrough.docx