MS Access (Beginner)

by Computers Etc Software Training Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Computers Etc Software Training Logo

img Duration

Please Enquire

Course Details

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
  • San Diego Branch

    6920 Miramar Rd - Suite 206, San Diego

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy