graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Fields: Create and Modify Fields

Edit the Date Properties

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

graphic2