How do I run a query in Microsoft Access 2007?
The Access training databases on this site come with ready-made queries, so all you have to do is use a filter to search the data in the queries. To search your data and filter it, first open the database that you purchased and downloaded from this site. Next find an object labeled “query” on the left and double-click on it to open it. Now follow the instructions in the video to filter the data in the query. • How do I run a report in Access 2007? • • • There are a few ways to run your training reports in Microsoft Access. If using a database that was purchased and downloaded from this site, it is recommended that you use the Report Wizard to run a report and to base your report on one of the ready-made queries provided on the navigation pane. Create a Report Using the Report Tool 1. In the Navigation Pane, click the table or query on which you want to base the report. 2. On the Create tab, in the Reports group, click Report. Access builds the report and displays it in Layout view. 3.
