Home
Courses & Certificates
About ECE
FAQ
Directions
Contact Us

Home » Course Catalog: MS Access

« Back

Course Catalog

MS Access Classes


Microsoft Access training courses, for improving the management, presentation, and distribution of your databases.


HR - Excel and Access
This course is designed for the Human Resources Generalist, Specialist, or Manager to analyze and track HR data and information using databases including Excel and Access. This unique two day course combines Excel and Access databases for the HR person to manipulate data and to analyze data using Excel’s PivotTables and Access’ Queries and objects. Here are some of the items we will learn:
  • Know differences between Access and Excel Human Resources databases and information systems,
  • Analyze Human Resources data using Excel’s PivotTables and Access Queries and Reports,
  • Customize Excel information after downloading from HR applications, such as PeopleSoft, ADP, and Ceridian,
  • Manipulate data through Sorting and Filtering in Excel and Access
  • Create and edit Access queries and set criteria for data
  • Develop custom Total Compensation workbooks and worksheets using industry constructs
    • Section Start Date End Date Campus Tuition Instructor Action
    HR - EXCEL/ACCESS (07AUG13)
    Learn More...    		 Aug 7, 2013 Aug 14, 2013 Briarcliff Campus $415.00 Greg Creech
    		 Register

    Access 2010 Level 1: Introduction
    You have worked with Microsoft Access 2007(or earlier) and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course you will be introduced to the new features available in Microsoft Office Access 2010. Using the new and enhanced features in Access, you will be able to create a highly functional database. Knowing the tools that allow you to accomplish these operations will greatly expand your Access capabilities. The textbook for this class is provided.
    Inquire

    Access 2010 Level 2: Accessing the Possibilities
    THIS CLASS WILL COVER BOTH ACCESS 2007 AND 2010.

    Learn the fundamentals of Access as you work with tables, queries, reports, forms and macros. Build your own personal contact management system in class, beginning with table creation, look up wizards and data value intelligence, and then to create command buttons and menus. Fieldwork is assigned to ensure you master the material. Learn to build relational databases and avoid potential pitfalls to using Access.
    Inquire
    Top