MICROSOFT OFFICE SPECIALIST IN ACCESS
Microsoft  Office Specialist Cert Prep Courses
(Select 6 Levels)
    
PREPARATION FOR THE ACCESS MS OFFICE SPECIALIST CERTIFICATION EXAM (77-424)
Course OverviewThese courses provides trainees with the basic through advance skills to create, manage, edit and maintain databases using MS Access. These courses will also prepare trainees for the Access Microsoft Office Specialist certification exam. 
Access Basic Level
  • Create a desktop database
  • Create a table
  • Import data and link to data
  • Create a database template
  • Create relationships in a database
  • Create and modify fields
  • Control how data may be entered into a database
  • Add and modify records
  • Sort and filter records
  • Format a table
Access Intermediate Level
  • Create a form based on existing data
  • Design a form from scratch
  • Create forms with application parts
  • Format a form
  • Create a report based on existing data
  • Create a report from scratch
  • Sort and group data in reports
  • Format a report
  • Prepare to print a report 
Access Advanced Level
  • Outline the steps for creating a query
  • Filter data with queries
  • Modify data with queries
  • Apply various formatting options to a query
  • Explain how queries can be updated and/or deleted
  • Sequence the steps to add, hide and remove a field from a query
  • Modify a query by grouping and summarizing data
  • Create user-defined input queries
  • Edit and save queries
  • Hide and delete query fields
  • Add calculated fields and grouping



Y
Y
Y

REGULAR PRICE FOR ALL COURSES PURCHASED SEPARATLY $1,200.00 
PACKAGE DISCOUNT RATE $999.00