The Objects bar and Object list enable you to move quickly from one item to another in Access.
[Ctrl] - [Tab]
[Ctrl] - [Shift] - [Tab]
[ ‘ ]
[ “ ]
The effect of pressing [Enter] depends on the type of object you ve selected. Pressing [Enter] :
Opens a table or query in Datasheet view
Opens a form in Form view
Opens a report in Print Preview
Opens a data access page in Page view
Runs a macro
[Alt] - [O]
This shortcut opens a table or query in Datasheet view, and opens a form in Form view.
[Alt] - [N]
Select the category of object in the Objects bar, and then press [Alt] - [N] to start creating a new object of that type. For example, select Reports in the Objects bar, and press [Alt] - [N] to display the New Report dialog box for creating a new report.
[Ctrl] - [Enter] , [Alt] - [D]
These shortcuts work for tables, forms, queries, reports, data access pages, macros, and modules.