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

Check out more MS Access courses in USA

Business Computer Skills Logo

Excel Programming with VBA

The Excel 2016 Programming with VBA course will expand upon skills taught in the Advanced Excel 2016 course, including expanded use of PivotTables and VBA.

by Business Computer Skills [Claim Listing ]
Training Folks Logo

Microsoft Office 365

Microsoft Office 365 workshop is offered by Training Folks. Our workshops are designed to build a higher-performing workforce with content that resonates with all levels of experience on your team. 

by Training Folks [Claim Listing ]
Ledet Logo

Microsoft Visio 101

In this Microsoft Visio training class, you will master the concepts of this one-stop diagramming solution to simplify and communicate complex information. Turn complex information into a visual masterpiece with data-linked diagrams that you can create in just a few clicks.

by Ledet [Claim Listing ]
Vijay Computer Academy Logo

Excel & Advanced Excel

Our Excel & Advanced Excel course is focused in efficiency. The Advanced Microsoft Excel is designed for the student who wants to move to the next level and focus on core competencies in Excel.

by Vijay Computer Academy [Claim Listing ]
Softek Services Logo

Introduction to Microsoft Excel

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to enter and edit information, write formulas, format cells, and print in Microsoft Excel.

by Softek Services [Claim Listing ]

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