A roadmap to Access 2007 training:
1. Get familiar with Access
2. Build your first database
3. Start managing your data, fast
4. Find answers with queries
||What you'll learn
|Queries I: Get started with queries
||An overview of what queries are, what goes into them, 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, and how to create calculated fields that display the results of an expression.
|Queries V: Use "And", "Or", and "In" to set multiple conditions
||How to use AND, OR, and IN logic to find records that meet multiple conditions, 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.
5. Deepen your Access skills
6. Learn general Office skills
Note You can also download shorter PowerPoint versions of some Access 2007 training courses and use them as training for yourself or a group.
And that's not all
You'll find more video demos at the Access Demos catalog page. And online training isn't just for Access 2007. It's also available for the entire 2007 Microsoft Office system. Because the more you know, the better you do.