Allan Bach


Hellertown, PA


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

Text Functions

Allan Bach, Consultant - Hellertown, PA - 610-248-0237 -