Access Queries

This course is an excellent introduction for anyone who needs to extract data from a Microsoft Access database. Learn how to use a wide variety of different queries to sort, filter, update, delete, and calculate data. If you’d like to learn how to create a simple one-table database, check out our Beginning Access course which covers tables, forms, and reports in addition to queries.

Topics Covered:

• Quick Sort by text, dates, or values
• Filter by Selection (filter by contents of a specific field)
• Create, rename, and delete queries
• Multiple Criteria narrow a search
• Wildcards to expand a search
• Calculated Fields
• Parameter Queries (request user input to filter search results)
• Unmatched Records Queries locate records not found in related table
• Duplicate Records Queries find duplicate records
• Append Queries add records
• Delete Queries remove records
• Update Queries update records
• Make Table Queries create new tables based on existing tables
• Summary Queries summarize large amounts of data in rows
• Cross Tab Queries summarize data in columns and rows

NOTE: Queries listed above are also covered in the Access Beginner class.