Objective 1.3 Navigate through a database

  • 1.3.1 Navigate specific records
  • 1.3.2 Create and modify navigation forms
  • 1.3.3 Set a form as the startup option
  • 1.3.4 Display objects in the Navigation Pane
  • 1.3.5 Change object views

OBJECTIVE 1.3: Contents

1.3.5 Change object views

You work with database objects in a variety of views. Each type of object (tables, queries, forms, and reports) can be opened in Design view. In Design view, you can add and define fields and field properties for a table; add fields to a query; add command buttons, list boxes, and other controls to a form; and apply formatting, group records, add calculated fields, and complete other tasks when you work with reports.

Forms and reports can also be opened in Layout view. In Layout view, you can design and modify a form or report while viewing the actual data. In Design view, data is not displayed. When you work with a form (for data entry or when searching for a specific record), the form is displayed in Form view. When you view a completed report, the report is displayed in Report view.

When you open a table for data entry or view the results that a query returns, you work with the table or query in Datasheet view.

To change object views

Image In the Navigation Pane, right-click the object and then choose the view you want to use. (Not every object view is available on the menu.)

Image With the database object open, right-click the object’s tab in the Access design window, and then select the view you want to use.

Image With the database object open, click View on the object’s Design tool tab, and then select the view you want to use. (For tables, the View command appears on the Fields tool tab.)