In Access query design is essential for getting the data you want. Use query design in Access to design almost any query you want.
Access 2010 offers many options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find how many of something exists within your database? Or what if you want your query results to automatically be sorted a certain way? If you know how to use its query options, you can design almost any query you want in Access.
In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access.
We will be showing you how to design and run queries with examples from our sample database. If you would like to follow along, download our example and use it to follow the procedures demonstrated in this lesson.