Removing the Fear of Access Shortcuts – Part 2
This is the second part of a two part series on Access shortcuts. This post is focused on those that create and support databases.
Here are my Top Access Shortcuts for Power Access Users & Access Database Developers:
Open the Navigation Pane: This opens the list of objects (tables, forms, queries) from the left (or, the database window if you are in an Access version up to 2003).
F11
Find an Object: With an object selected in the navigation pane, Ctrl-F add a Search bar at the top of a list. This saves a TON of time when you have hundreds of tables + forms + reports, etc.
Ctrl-F
Open in Design View: With an object selected in the navigation pane, Ctrl-Enter opens it in design view instead of right-mouse clicking and then choosing Design View.
Ctrl-Enter
Switch to Form View: If in design or datasheet view, this switches you to Form View.
F5
View Property Sheet: When in design view of a form, this shows the property sheet on the right.
Alt-Enter
Save As: Allows you to save the current object as a different name.
F12
Zoom Box: When you’re working with a lot of text or a big formula, the Zoom box is great for giving you a bigger text box to view it in.
Shift-F2
Refresh Combo Box: If you’ve added data in a table and need to refresh a combobox to see the new data.
F9
Requery the Data in a Subform: This is similar to F9, but it refreshes the data inside of a subform
Shift-F9
Andy Tabisz, MCAS, MOS is owner and lead innovator of WorkSmart Database Masters, LLC, serving clients nationally and internationally.