Administrator: Receipts (Start) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Edit the Table

1. Add the DateRetuned Control

Close all of the forms you may have open.

Open tblMovieRented in Design View.

 

Add the Control: DateReturned

Data Type: Date/Time

 

Field Properties

Format: Short Date

Input Mask: Short Date

 

Save your changes and close the table.

Home ->View ->Design View
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.4. Create fields and modify field properties: Date/Time fields