Tips to increase your proficiency in Microsoft Access
Insert current date -
To insert the current date into a field, use the CTRL-; (Control + semicolon) key.
Insert previous value -
To insert the value from the previous record (same value, same field) use the CTRL-' (Control + single quote) key.
Open to a Specific Form -
To have a specific form show when you open a database, go to File tab, Options, Current Database, and choose the form from the Display Form dropdown list. You can also hide the database objects window by deselecting the Display Navigation Pane. To open your database and see the objects, just hold your shift key when opening the database file.
Finding Criteria using Wildcards
Date and Time Functions
Allan Bach, Consultant - Hellertown, PA - 610-248-0237 - email@example.com