Microsoft Certified Application Specialist (MCAS) - Access 2007
Course Schedule & Online Registration
If you are an individual, please click here.
If you are representing a company, please click here
Target Audience
Individuals who are interested to handle database by using the features in MCAS - Access 2007
Course Duration
21 hours / 3 days exclude examination hours
Assessment
Participants are required to sit for 1 Microsoft Certified Application Specialist (MCAS) examination.
*Any amendments (subject to availability) to a confirmed exam booking, an administrative charge of $21.40 will be imposed.
Course Outline
· Introducing Access
o Looking at the Screen
o Planning a Database
o Creating A Database Using a Template
o Moving Around a Database
o Creating a Blank Database
o Organizing Files
· Creating and Modifying Tables
o Creating Tables using Datasheet View
o Moving Around a Table
o Inserting, Deleting and Modifying Data in a Table
o Creating Tables using Table Templates
o Creating Tables Based on Existing Tables
o Creating a Table in Design View
o Modifying a Data Types
o Modifying Field Properties
o Adding and Removing Primary Keys
o Adding and Removing Multiple Keys
· Manipulating a Table
o Restructuring Tables
o Formatting Tables
o Modifying Tables
o Printing and Distributing Tables
· Data Manipulations
o Inserting and Deleting Records
o Importing and Exporting Data
o Finding and Replacing Data
· Sorting and Filtering
o Sorting Records
o Filtering Records
· Select Queries
o What is a Query?
o Creating a Query using the Wizard
o Creating a Query in Design View
o Saving, Closing and Running Queries
o Adjusting Queries
o Sorting Fields
o Showing and Hiding Fields
o Applying Criteria
o Using Wildcard Characters
o Functions and Calculated Fields
o Changing Field Properties
o Working with Aliases
o Filtering Query Data
· Relating Multiple Tables
o Establishing Table Relationships
o Enforced Referential Integrity
o Print Relations
o Using the Table Analyser
· Maintaining Databases
o Database Maintenace
o Opening Databases
o Modifying Database Options
o Modifying Database Properties
o Using the Database Documenter
o Saving a Database to a Previous Version
o Saving a Database with a Password
o Splitting Databases
· Working with Forms
o What is a Form?
o Creating a Form
o Using Forms
o Creating and Modifying a Form in Layout View
o Creating and Modifying a Form in Design View
o Creating Datasheet Forms
o Creating Multiple Items Forms
o Creating
o Creating PivotTable Forms
· Working with Reports
o What is a Report?
o Creating a Report using the Report Tool
o Creating a Report using the Report Wizard
o Creating and Modifying Reports in Layout View
o Creating and Modifying Reports in Design View
o Print Preview and Print Reports
o Exporting as PDF or XPS Format
o Creating Mailing Labels
· Advanced Table Design
o Advanced Field Properties
o Using Lookup Fields
o Linking Tables
· Advanced Queries
o Select Queries from Multiple Tables
o Adding and Removing Tables from Queries
o Inner and Outer Joins
o Specialized Select Queries
o Summary Queries
o Action Queries
o Create Subqueries
o Queries from Filters
· Advanced Forms and Reports
o Features of Forms and Reports
· Customizing Forms and Reports
o Working with Properties
o Using Unbound and Bound Controls
o Applying Images
o Using List Boxes and Combo Boxes
o Using Check Boxes
o Using Option Boxes
· Using SubForms and SubReport
o Creating Subforms and SubReport
o Exporting to HTML
Course Location
NTUC Trade Union House
73 Bras Basah Road
#02-01
Singapore 189556
Methodology
Instructor-led Class
Certification
- Certificate of Completion from NTUC LearningHub
- Microsoft Certified Application Specialist: Access 2007 (upon passing the Microsoft Exam)
Price
Non Union Members:
Course Fee: $500.00
Exam Fee: $140.00
Union Members:
Course Fee: $493.00 (exam fees inclusive)
*All fees stated excludes GST
Funding Info
UTAP Training Awards (for eligible union members only)
50% of the nett unfunded portion, capped at $250 per member per (calendar) year after fulfillment of funding criteria of 75% attendance & sat for prescribed exams.
Our Partners
