Create Access Forms And Reports From. Create a query as the record source of a form or report. The record source must contain all of the rows and columns of data you want display on the report.

Use an existing query as the record source of a form or report. 4 Create A Multiple Items Form. Create a Form.
Click the Microsoft Office button.
If you select a table or query Access will automatically create a form based on the selected. Editing data from a query. 5Create A Navigation Form In Access. Use an existing query as the record source of a form or report.