Microsoft Access 2010 Tutorial Part 09 of 12 - Customer Queries

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?

Category:

Education

Tags:

• microsoft access
• access 2010
• access tutorial
• query design
• show table
• add table
• run query
• design view
• sort
• filter
• criteria
• save object as
• edit data
• asterisk

[caribbeankewl]

you look like u are very good with IT can u help me a pascal program please