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

Jess Kamens Photography Logo

MS Office

MS Office Workshop is offered by Jess Kamens Photography.He make technical terms easy to understand in our fun, mindful learning environment. Learn the basics in addition to several artistic and creative techniques.

by Jess Kamens Photography [Claim Listing ]
Technical Institute of America Logo

Microsoft Excel Essential Training Course

Our one-day Excel Essentials class is the most popular Excel training course in the city. This live instructor-led hands-on course will cover basic to intermediate topics in Excel.

by Technical Institute of America [Claim Listing ]
New Horizons Central Logo

VBA with Microsoft Excel (v1.2)

This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch.

by New Horizons Central [Claim Listing ]
American Graphic Institute Logo

Access Training

Learn Microsoft Access foundations in this introductory Access course. This course teaches the essentials of Access and working with relational databases.

by American Graphic Institute [Claim Listing ]
Community College Of Philadelphia Logo

Microsoft Excel 2019 (Advanced)

Your experience to date with Microsoft® Excel 2019 gives you a solid foundation with this software. This class builds upon the knowledge presented in the Microsoft® Office Excel® 2019 Basic and Intermediate classes to help you get the most of your Excel experience.

by Community College Of Philadelphia [Claim Listing ]

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