quickbooks classes san diego
 
Access Beginning - $99

This class is intended for:

PC/Windows Users: Access 2007-2010-2013-2016-365
Version Used in Class: Access 2010
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 3.5 hours

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


quickbooks classes san diego

 
Contact Us Map / Directions Schedule Home Page View Non-Mobile Site