The Microsoft Office Access program allows the entry and organization of information in a database form. Each time you enter new information into the database, Access will insert a time and date stamp. Use this information to keep track of how often you update your database entries. Adjusting the settings to create an automatic time and date stamp takes minutes and can easily be reversed if you change your mind.
Instructions
1. Open the database table to which you want to add the time and date stamp.
2. Double click the header with the label "Add New Header" at the top of the first blank column and rename it either "Date Added" or "Time Added" and press enter to rename the column.
3. Click once on the column header to select the entire column and select the "Data Type and Formatting" section at the top of the window. Click on the "Datasheet" tab in that section. Then choose the option for "Table Tools".
4. Look for the "Date/Time" button under the "Data Type" section of the "Table Tools" area and click on it.
5. Press "CTRL" and "S" at the same time to save your settings.
6. Click on the "Microsoft Office" button at the top left corner to open the main menu.
7. Click on "View" then "Design View".
8. Click on "Field Name" then click on the header of your new column to select it.
9. Go to the "General" tab and choose the "Field Properties" option.
In the box next to "Default View" type in "NOW()" to generate a current time and date stamp in that column or "DATE()" for just the date stamp in that column.
10. Choose the box labeled "Show Date Picker" and select the box next to "Never" to check it.
11. Press "CTRL" and "S" to save your document with the time and date stamp automatically inserted in your new column on your report for future entries into the datasheet.
Tags: time date, time date stamp, date stamp, click header, column select, Data Type, date stamp