How to Retrieve Data From an Access Database

Retrieve data from an Access database by using queries and reports.

Use Access databases to work with large volumes of data. Data is added to your database using tables and forms. Retrieve data out of the database using reports and queries. When retrieving data out of the database, select the fields and criteria needed to display the information in the format needed for your output. The fields selected can come from tables and existing queries in the database. Use criteria to refine the output being pulled out of the database.

Instructions

1. Open Access 2007 and select a database. Click the "Office" button and select "Open". Browse your computer for the database. Click the database and select "Open". The database opens.

2. Click the "Create" tab and select "Query Design". Add tables to the query by clicking "Add" in the Show Table dialog box. Click "Close" to close the Show Table dialog box.

3. Add fields to the query by clicking the fields in the table and dragging them to the query columns. Add a criteria to the "Criteria" field. For example, if you want to see all invoices over $100, enter the criteria ">100". The greater than symbol pulls all invoices over the $100 amount.

4. Save the query by clicking the "Save" icon on the Quick Access Toolbar. Type a name for the query in the "Query Name" field. Review the results of the query output.

5. Create a report on this query output by clicking the "Create" tab and clicking "Report" button. Access generates an autoreport on the query results.

References

• Microsoft: Create a simple report
• Microsoft: Select data by using a query