Published on 21 Aug 2013 | over 3 years ago

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

Loading related videos...