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.