If you have never used Microsoft Access date functions, take a look at this quick Beginner's Guide to Microsoft Access Built-in Date Functions that I recently created and shared on our Office You Tube channel.
If you find yourself constantly entering whatever today's date is in your Access forms or tables, you are wasting valuable time.
When the record is accessed again, the Date Modified field will contain the date and time of the last modification.
You can query that field to determine which records have not been updated within the last six months.
Do you need to query your data by the last date modified?
For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. Follow these steps: Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated.
See the image below to view the query design grid screen.
You will save yourself time, and eliminate the possibility of manual errors.
Note: Due to the permanent effects of working with an update action query, you should always make a backup copy of your tables, or your database before attempting this option.
Click on the Run button to run the Query, now David’s salary is updated to 11000.
If you remove the WHERE statement, all records will be updated.
This Microsoft Access tutorial explains how to update table records from another table or query.