Microsoft Office Tutorials and References
In Depth Information
Session 2.1 Quick Check
Next you need to set the CustomerID Field Size property to 5 because each
CustomerID number at Belmont Landscapes consists of five digits. You also need
to set this field’s Caption property.
7. Click the CustomerID Field Name box to make this the active field, press the
key, type , press the Tab key three times, and then type Customer ID in the 5
Next you’ll set the Caption property for the ContractAmt and SigningDate fields.
8. Click the ContractAmt Field Name box, click the Caption box, type Contract
Amt ; then click the SigningDate Field Name box, click the Caption box, and then
type Signing Date .
Finally, for the ContractType field, you will set the Field Size property to 75. This
size can accommodate the longer values in the ContractType field. You’ll also set
this field’s Caption property.
9. Click the ContractType Field Name box, press the key, type , press the 75
Tab key three times, and then type Contract Type . Now you can save the
10. Click the Save button on the Quick Access Toolbar. A dialog box opens
informing you that some data may be lost because you decreased the field sizes.
Because you know that all of the values in the ContractNum, CustomerID, and
ContractType fields include fewer characters than the new Field Size properties
that you set for each field, you can ignore this message.
11. Click the Yes button, and then close the Contract table.
12. If you are not continuing to Session 2.2, click the File tab, and then click Close
Database in the navigation bar to close the Belmont database.
You have created the Invoice table and made modiﬁ cations to its design. In the next
session, you’ll add records to the Invoice table and create the Customer table in the
Session 2.1 Quick Check
1. What guidelines should you follow when designing a database?
2. What is the purpose of the Data Type property for a ﬁ eld?
3. The property speciﬁ es how a ﬁ eld’s name is displayed in
database objects, including table and query datasheets, forms, and reports.
4. For which three types of ﬁ elds can you assign a ﬁ eld size?
5. The default Field Size property setting for a Text ﬁ eld is .
6. In Design view, which key do you press to move from the Table Design grid to
the Field Properties pane?
7. A(n) value, which results when you do not enter a value for a
ﬁ eld, is not permitted for a primary key.