Access Training writer Colin Wilcox has just finished up a series of query courses, available for free on the Access 2007 training courses page on Office Online. Here’s the whole set: Find answers with queries Course What you'll learn Queries I: Get started with queries An overview of what queries are, what goes into them,
Office Professional Plus 2010, and how to use them. Queries II: Create basic select queries How to create basic select queries by using a wizard or a designer. Queries III: Use expressions and other criteria How to use selection criteria and expressions — formulas that do more than math — in your queries. Queries IV: Use functions and calculated fields in your queries How to use functions to sum, average, or count data,
Microsoft Office 2007 Professional Plus, and how to create calculated fields that display the results of an expression. Queries V: Use "And",
Office 2010 Pro Key, "Or",
Microsoft Office 2010 Professional Plus, and "In" to set multiple conditions How to use AND, OR, and IN logic to find records that meet multiple conditions,
Office 2007 Standard Key, such as customers who also own their businesses. Queries VI: Use wildcards in queries and parameters How to use wildcard characters to find data and match patterns of characters. Queries VII: Query multiple sources for data How to query more than one table (or query) for data. Queries VIII: Dealing with ambiguous joins How to work around ambiguous outer joins, a problem that sometimes arises when you query multiple tables. Have an Access Power Tip that you want to share? Send it to Mike and Chris at accpower@microsoft.com. <div
Office Professional Plus 2010 New Access training
Linear Mode
