Main Profile

At A Glance

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 QueriesCreate, Query DesignShow Table WindowAdding a table to your queryDrag fields to the query columnsRun the queryDesign ViewAdd field with a double-clickSort a fieldMultiple field sortSort by Last Name then First NameSort order left to rightMoving a query columnSaving a query (CTRL-S)Adding a CriteriaShow only customers from NYFile, Save Object AsOpening multiple queriesSwitching between tabsChange "NY" to "PA"Can I edit data in a query?Must I make a query for each state?What is the "*" asterisk for?
Length: 15:44

Contact

Questions about Microsoft Access 2010 Tutorial Part 09 of 12 - Customer Queries

Want more info about Microsoft Access 2010 Tutorial Part 09 of 12 - Customer Queries? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question