MS Access (Beginner)

Our Access Beginning class is aimed at users who only need to enter data and run queries and reports. We cover a wide variety of techniques for filtering data in many different types of queries.

Access Queries:

Create a number of different Queries that will sort and filter data using different criteria such as name, amount, and date. Use multiple criteria (text, numbers, dates) to narrow a search, use wildcards, use parameters, filter data by text, a range of dates or amounts, etc.

• Create queries based on existing queries/tables, rename queries, and delete queries. Add calculated fields that don't exist in table (i.e. a field that will calculate sales tax).
• Select Queries (basic queries)
• Parameter Queries (ask for user input to narrow results)
• Unmatched Records Queries (records not found in related table)
• Duplicate Records Queries (find duplicate records)
• CrossTab Queries (summarize data in columns and rows)
• Append Queries (add data to a table)
• Delete Queries (remove data from a table
• Update Queries (update a large number of records)
• Make Table Queries (new table based on another table)
• Summary Queries