|
In this
business model, the Receipts are written live, while the customer is
standing at the front counter. So, the DateRented can have the
current date and time as the Default Value for quicker data
entry.
2.
Try it: Edit the Field Properties Select a
Field: DateRented. Format:
Short Date Try
This, Too: Add an Input Mask Select a
Field Property: Input Mask. Click on
the three-dot builder and walk through the Wizard. You may be asked
to Save the Table before the Wizard begins. And
This: Enter a Default Value Select a
Field Property: Default Value Type:
=Date()
Finally, Do This: Save the Table Go to
File->Save. Enter a
name: tblReceipt. That's one
Table. Close tblReceipt.
Table Tools->Design
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.2. Create and Modify Fields: Modify
Field Properties
|
|
| |
