Since 1992 we have provided affordable, hands-on computer training classes to over 25,000 San Diego residents and businesses. Our classes are small, reasonably-priced, and to the point - a winning combination that has proved popular with our students. Instructor is a Certified Microsoft Office Specialist (Master level) and QuickBooks ProAdvisor with over 25 years full-time teaching experience.
This class is intended for:
- PC/Windows Users: Access 2010-2013-2016-2019-365
- Version Used in Class: Access 365
- Course Materials: FREE
- Certificate of Completion (optional): $5
- Course Length: 1 Day
- This class focuses on Data Entry (using forms) and Data Filtering (using queries and reports).
ACCESS BASICS:
Learn how to create, edit, and save a wide variety of queries and reports. This course is an excellent introduction or refresher for anyone who will be entering data and/or extracting data.
DATA ENTRY:
Enter, edit, and delete data in forms and tables.
SORT AND FILTER DATA:
Use Find & Replace to edit data in table, use Quick Sort to sort data, use Filter by Selection to locate specific data in tables and forms.
CREATE 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).
QUERY TYPES:
- 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