When designing an Access query it can be simple or more complex. In Access simple query guidelines let you pull important data.
The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define.
In this lesson, you will learn how to create a simple one-table query. Then you will learn how to plan and run a slightly more complex multi-table query.
As we show you how to create queries, we'll be using our sample database. If you would like to follow along, download our example and use it to follow the procedures demonstrated in this lesson.