Get answers from your data

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.

Topic 1 of 9


(Back to Start)

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.