Learn MORE Access at
http://599CD.com/X0DIZX. 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.
09. Customer Queries
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?
Microsoft Access 2010 Tutorial Part 09 of 12 - Customer Queries microsoft store | |
| 1,008 Likes | 1,008 Dislikes |
| 331,212 views views | 164K followers |
| Education | Upload TimePublished on 25 Nov 2011 |
Không có nhận xét nào:
Đăng nhận xét