Create a query, form, or report in Access

In the Simple Query Wizard dialog box, select the fields you want to use.

A split form gives you two views of the data at the same time — a Datasheet view and a Form view. For example, use the Datasheet view to find a record and the Form view to edit it.

  1. In the Navigation Pane, select a table or query that contains the data.
  2. Select Create >More Forms >Split Form.

A split form

Create a report

  1. Select Create >Report Wizard.
  2. Select a table or query, double-click each field in Available Fields you want to add it to the report, and select Next.
  3. Double-click the field you want to group by, and select Next.
  4. Complete the rest of the wizard screens, and select Finish.