Skip to content
Tutorials Center
My learning

Topics

Lesson 2 of 36 ยท Getting Started

The Access Interface and Navigation

Tour the Microsoft Access window: the ribbon tabs, Navigation Pane, tabbed documents, Datasheet, Design and Layout views, Tell Me search and useful keyboard shortcuts.

The first time you open Access, the window can feel crowded. There is a ribbon with many tabs, a pane full of object names and a workspace that changes shape depending on what you open. The layout is consistent, though, and once you know the five main areas you can find any command.

This lesson describes each area, explains the different views an object can be shown in and lists the shortcuts that save the most time. Menu names here match current Microsoft 365 builds of Access. Older versions such as Access 2016 and 2019 look nearly identical, with small differences noted where they matter.

The five main areas

The Access window

Ribbon Tabs of commands along the top
Navigation Pane All objects on the left
Workspace Open objects as tabs
Status bar Record count and view buttons

Everything you do starts in one of these four.

1 / 2

The ribbon

The ribbon is the strip of tabs and buttons at the top. The tabs you will use most are:

  • File opens the Backstage view: New, Open, Save As, Print, Compact and Repair, Options and Account. It is a full-screen menu rather than a normal tab.
  • Home has the basics: switching views, copy and paste, sort and filter, find, text formatting and the record commands (Save, Delete, Totals, Spelling).
  • Create builds new objects: Table, Table Design, Query Wizard, Query Design, Form, Report, Macro, Module and more.
  • External Data imports, exports and links to Excel, text files, XML, other Access databases and ODBC sources.
  • Database Tools holds Relationships, Analyze Table, Analyze Performance, Database Documenter, the Linked Table Manager and Compact and Repair.
  • Help opens documentation and support.

Extra contextual tabs appear only when you open something. Open a table in Design view and a Table Design tab appears with the Primary Key, Indexes and Property Sheet buttons. Open a form in Design view and you get Form Design and Arrange tabs. If a command seems to have vanished, check that the right object is open and in the right view.

Click the Tell me what you want to do search box (it shows a light bulb or the word Search, depending on version) and type a command name such as compact. Access shows the matching command and runs it when you select it.

You can collapse the ribbon to give the workspace more room. Double-click any tab name, or press Ctrl+F1. Click a tab to show the ribbon temporarily.

The Quick Access Toolbar

Above or below the ribbon sits a small toolbar. By default it holds Save, Undo and Redo. Open the dropdown at its right end to add buttons you use constantly, such as Open, Print Preview, or Run. Choosing More Commands opens the customization screen where you can add any command from any tab.

The Navigation Pane

The Navigation Pane runs down the left side and lists the objects in your database. Its header has a dropdown that controls how objects are grouped:

  • Object Type groups into Tables, Queries, Forms, Reports, Macros and Modules. This is the default.
  • Tables and Related Views groups each table with the queries, forms and reports that use it. Useful for understanding a database someone else built.
  • Created Date and Modified Date sort by time.
  • Custom lets you create your own groups and drag objects into them.

A search box under the header filters names as you type. Right-click an object for a shortcut menu with Open, Design View, Rename, Delete, Export and Copy. Click the shutter bar (the double arrow at the top of the pane) or press F11 to collapse or expand the pane.

Access also keeps hidden system tables whose names start with MSys. Do not delete or edit them.

The workspace and document tabs

Every object you open appears in the workspace. By default, objects open as tabbed documents, with one tab per object along the top. Click a tab to switch, or middle-click or press Ctrl+W to close it.

Older databases use overlapping windows instead, where each object floats like a small window. You can switch with File > Options > Current Database > Document Window Options. Tabbed documents suit most people better, but overlapping windows let you view two objects side by side.

The status bar

The status bar at the bottom shows hints, the active view and, for a datasheet, the record navigator: first, previous, current number, next, last, new record, and a filter box. Buttons at the right switch between views quickly.

Views of an object

Almost every object can be shown in more than one view. You pick a view from Home > View or the buttons at the right of the status bar.

View Applies to Purpose
Datasheet Tables, queries, forms Rows and columns, like a spreadsheet. Edit data here.
Design Tables, queries, forms, reports Edit the structure: field names and types in a table, the grid in a query, controls on a form.
Form Forms The finished screen as an end user sees it.
Layout Forms, reports Adjust layout while real data shows, so sizing is easier.
Report Reports A screen preview you can filter and select text in.
Print Preview Reports Page breaks and margins as they will print.
SQL Queries The SQL statement behind the query.
PivotTable / PivotChart Removed in Access 2013 and later Gone from current versions; use Excel or a Crosstab query.

You will switch constantly. Open a table to type data in Datasheet view, jump to Design view to rename a field, then come back.

Changing a table in Design view can delete data. If you shorten a text field, change a type or remove a field, Access warns you first. Read the warning, and keep a backup copy of the file before restructuring a table.

Seeing a query's SQL

Because Access translates every query designer into SQL, you can learn SQL just by switching views. A query that shows tasks not yet done, sorted by due date, looks like this in Access SQL view:

SQL
SELECT Title, DueDate
FROM Tasks
WHERE Done = False
ORDER BY DueDate;

In Access, a Yes/No field stores True as -1 and False as 0. The standard-SQL form below uses 0 and 1 so it runs here.

SQL The same query in standard SQL

Press Run (or Ctrl + Enter) to see the result here.

Keyboard shortcuts worth learning

Keys Action
Ctrl+N / Ctrl+O New database / open database
F11 Show or hide the Navigation Pane
F4 Show or hide the Property Sheet in Design view
Ctrl+S Save the open object
F6 Move between panes (for example the top and bottom of a query design)
F5 Go to a record number in a datasheet or form
Ctrl+F / Ctrl+H Find / Replace
Ctrl+; Insert today's date in a field
Ctrl+' Copy the value from the same field in the previous record
Ctrl+Z Undo the last edit
Esc Cancel the current edit (press twice to cancel the whole record)
Ctrl+G In the VBA editor, open the Immediate window

Options worth checking on day one

Open File > Options. Three places matter early:

  1. Current Database has the application title, the form to display at startup, whether to show the Navigation Pane and the Document Window Options.
  2. Object Designers has default field sizes and types for new fields.
  3. Client Settings controls how Enter behaves, whether confirmations appear and how large the Undo stack is.

You will visit all three again when you shape a finished application.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which key shows or hides the Navigation Pane?

    F11 toggles the Navigation Pane. F4 toggles the Property Sheet, and Ctrl+F1 collapses the ribbon.
  2. 2. You open a table in Design view. Where do you change a field's data type?

    Design view lists each field with its Data Type, and the Field Properties pane below it holds the other settings.
  3. 3. Which Navigation Pane grouping shows each table together with the queries, forms and reports that use it?

    Tables and Related Views groups objects by dependency, which is a quick way to understand someone else's database.
  4. 4. Why do contextual tabs such as Table Design sometimes disappear?

    Contextual tabs are tied to the active object and view. Open the object in Design view and the tab returns.

Summary

  • The window has a ribbon, Navigation Pane, tabbed workspace and status bar; contextual tabs appear for the open object.
  • Objects have several views: Datasheet, Design, Form, Layout, Report, Print Preview and SQL.
  • The Tell me search box finds commands by name, and the Quick Access Toolbar holds your favorites.
  • Switching a query to SQL view is the easiest way to learn Access SQL.
  • Learn F11, F4, Ctrl+S and Esc; check File > Options early.

Next: Creating Your First Database