My Notes on Microsoft Access

How to open Microsoft Access file in design mode?
Double-clicking the .mdb file while holding the shift key

How to show Navigation Pane?
Press F11
or
File -> Options -> Current Database -> Check the check box "Display Navigation Pane"

How to show these tabs: Create, External data, and Database Tools?
File -> Options -> Current Database -> Check the check box 'Allow Full Menus' in 'Ribbon and Toolbar Options' area

How to show the item menu when right click on it on Navigation Pane?
File -> Option -> Current Database ->  Check both "Allow Default Shortcut Menus" and "Allow Built-in Toolbars"

How to change the View?
On Ribbon select the Home tab and View
or
click View on Quick Access toolbar

How to switch between codes and form?
Press ALT F11

Link table manager:
Use file DSN file
http://office.microsoft.com/en-us/access-help/use-the-upsizing-wizard-HP005273009.aspx

How do I view the SQL for EXISTING queries and edit it in Access?
http://www.gcflearnfree.org/access2013
http://office.microsoft.com/en-us/access-help/introduction-to-queries-HA102749599.aspx
http://office.microsoft.com/en-us/access-help/view-modify-or-copy-a-query-s-sql-statement-mdb-HP005188056.aspx

How to create new file DSN?
Control Panel -> System and Security -> Administrative Tools -> Data Sources (ODBC)
Select "File DSN" and click on "Add" button
Select "SQL Server" on "Create New Data Source" and click "Finish" button
Continue to specify SQL Server and database to connect

Office 2013 developer training (Module 21)
http://dev.office.com/training

Unable to view hidden objects in Microsoft Access 2007
http://answers.microsoft.com/en-us/office/forum/office_2007-access/unable-to-view-hidden-objects-in-microsoft-access/

How to toggle between tabs in Access
http://answers.microsoft.com/en-us/office/forum/office_2007-access/how-to-toggle-between-tabs-in-access/c955f3e0-4ad0-46ca-bbfd-0a0713537c42
Ctrl+F6 will switch between all open tabs (or windows) in the database, regardless of type.

How to view documents in tab
Change Document Windows Option to "Tab Documents" using File -> Privacy Options

Sub-Forms and Sub-Reports
http://www.functionx.com/access/topics/sfsr.htm