You can design queries to present your data in whatever filtered or sorted manner you want, and then save those queries for later use. You'll learn how to create a query from scratch using the query designer. You'll see how to add fields to your query, perform a sort, and add criteria to your query. We'll discuss multi-column sorts (left-to-right). You'll learn how to save multiple queries that each perform slightly different functions.
Lesson 9 covers: Create, Query Design, Show Table Window, Adding a table to your query, Drag fields to the query columns, Run the query, Design View, Add field with a double-click, Sort a field, Multiple field sort, Sort by Last Name then First Name, Sort order left to right, Moving a query column, Saving a query (CTRL-S), Adding a Criteria, Show only customers from NY, File, Save Object As, Opening multiple queries, Switching between tabs, Change "NY" to "PA", Can I edit data in a query?, Must I make a query for each state?, What is the "*" asterisk for?
Watch all 13 videos in this series on YouTube via this Playlist: goo.gl/aK4Ra4
Learn more about Microsoft Access at 599CD.com/XAC13B2YT