Chat with us, powered by LiveChat

Access Database

How to Work with Database Objects in Access

Access Database

Use the Navigation Pane

Think of the Navigation Pane as the mission control center for an Access database. You use the Navigation Pane to open and manage the different types of objects in your database.

  1. Click the arrow button at the top of the Navigation Pane to select the type of object(s) you want to display.

    The Navigation Pane can display different types of Access objects. You can change the view settings to view all the database objects in this database.

  2. Select Object Type and make sure there’s a check mark next to All Access Objects.
    Work with database objects

The Navigation Pane contains buttons for each type of database object.

Open a Database Object

  1. Double-click an object in the Navigation Pane.
    Work with database objects

The object appears on the screen as a tabbed item.

As you open additional objects, they stack on top of each other in the same window. To bring a different object to the top, where it’s visible, click its tab.

Switch Object Tabs

If you have multiple objects open, you can use the tabs to switch between objects.

  1. Click the tab for the object you want to display.
    Work with database objects

Modify a Database Object in Design View

  1. Click the View button list arrow.
  2. Select Design View.

    You can also modify a database object in Design view by right-clicking the object’s tab and selecting Design View from the contextual menu.

    Work with database objects

Close a Database Object

  1. Click the object’s Close button in the upper-right corner of the window.
    Work with database objects

The object closes. Remember, closing an object is different than closing the entire database.

Rename a Database Object

  1. In the Navigation Pane, right-click the object that you want to rename.
  2. Select Rename from the contextual menu.
  3. Type a new name and press Enter.
    Work with database objects

The object is renamed.

Delete a Database Object

  1. Select the object you want to delete in the Navigation Pane.
  2. Press the Delete key.
  3. Click Yes to Confirm the deletion.
    Work with database objects

The object is deleted.

FREE Quick Reference

Click to Download