Mrs. Alphabet is a website that would help future teachers of younger children come up with lesson plans according to holidays and times of the month. It would also help teachers with ideas on how to teach the alphabet, phonics, and mathematics.
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: Access offers several 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 out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want.
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.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example.
Watch the video below to learn more about modifying queries.
MODIFYING QUERIES
Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results.
TO MODIFY YOUR QUERY:
When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view:
On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears.
Switching to Design View with the View command on the Ribbon - www.office.com/setup
In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right.
Switching to Design View using the View Icon - www.office.com/setup
Once in Desig