Page 2 of 11PREVNEXT

Create queries for a new database

The building blocks of a select query


Your new asset-tracking database is coming along. You have tables, relationships, and data, so the next step is to build some queries. They'll help you answer important questions, and they'll make it easier to create forms and reports.

Specifically, you'll create select queries. They're components that retrieve and process your data and display the results in a datasheet. For example, if you want to know who to call when a computer needs repair, you create a query that extracts the relevant names and phone numbers.

That's what the picture shows. The query takes asset data from the first table, the names of technicians from the second table, and displays the result in a way that you can consume. Let's start by looking at the parts of a query.

Page 2 of 11PREVNEXT