Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.
2. Searching for something specific? See our text overview of all tests. Includes 'real teacher' use videos.

Designing Queries

Queries are incredibly useful and they are essentially used for searching for and compiling data from one or more tables. Using or "running" a query is a bit like asking a detailed and very specific question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want.

How are queries used?

Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables.

Suggested Video

This video includes information on: • How queries are used • Creating a simple one-table query