Access 2007 Level 3: Query Design

Suggest this class to a friend or colleague

IT@Emory computer education - Microsoft Office Training

Once data is in a database, you must retrieve and work with it. This class helps you create queries to extract and manipulate database information. Learn to filter, sort, and group data. Use action queries to manipulate data by adding, deleting, and updating records. Finally, learn to use crosstab queries to perform powerful data analyses within Access. Save time and money by learning to manage your data like a pro.

Prerequisite: Accessing the Possibilities or equivalent experience with Access

Cancelled

Instructor: Paul Dunlop, Certified Technical Trainer
1 session(s): Fri: Dec 11 / 9:00 am-4:00 pm
Registration fee: $225 CEUs: 0.65

After this class, you will be able to

Create select and action queries manually and using the Access Query Wizard
Sort, summarize, and filter query results using criteria
Format query results as text, numbers, dates, times, and more
Use query joins to pull data from multiple related tables
Perform calculations within queries with Access's built-in formulas and functions
Create parameter queries that prompt the user for filter criteria
Update, Append, and Delete data safely using action queries
Apply advanced query techniques to create Crosstab and Union queries