Microsoft Access 2013 Tutorial Level 1 Part 09 of 12 - Customer Queries

Computer Learning Zone
0
352039

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: http://goo.gl/aK4Ra4 Learn more about Microsoft Access at http://599CD.com/XAC13B2YT

Published by: Computer Learning Zone Published at: 10 years ago Category:
access 2013 tutorial microsoft access ms access microsoft access 2013 ms access 2013 access 2013 access tutorial access training query queries query design show table show table window add table to query run query design view query sort move query column save object as save query ctrl-s dideo دیدئو query queries sort design save youll add multiple field