Course 50040A: Preparing for the Microsoft Certified Application Specialist Exam in Microsoft Office Access 2007

Type: Course
Audience(s):information workers
Technology:Microsoft Office system
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:1 day

First published:

10 September 2007
About this course
Elements of this syllabus are subject to change.

Please note: Effective June 1, 2010 Microsoft Certified Application Specialist (MCAS) is now known as Microsoft Office Specialist (MOS). Click here for more information about this recent change.

This one-day instructor-led course provides students with an overview of the Microsoft Office Access 2007 features and functions that pertain to the objectives of the corresponding Microsoft Business Certification credential. This course is intended to allow the student to prepare for certification as a Microsoft Certified Application Specialist in Access 2007.
Audience profile
This course is intended for knowledge workers who have hands-on experience with Access 2007.
At course completion
After completing this course, students will be able to:
  • Structure a database.
  • Create and format database elements.
  • Enter and modify data.
  • Create and modify queries.
  • Present and share data.
  • Manage and maintain databases.
Course details
Course OutlineModule 1: Structuring a Database
This module explains how to define the appropriate tables, fields, and data types for a database; how to create, modify, and print table relationships; how to set, change, and remove primary keys; and how to split a database.
  • Define Data Needs and Types
  • Define and Print Table Relationships
  • Add, Set, Change, or Remove Primary Keys
  • Split Databases
Lab : Structuring a Database
After completing this module, students will be able to:
  • Define data needs and types.
  • Define and print table relationships.
  • Add, set, change, or remove primary keys.
  • Split databases.
Module 2: Creating and Formatting Database Elements
This module explains how to create a database from scratch and from a template; how to create, modify, rename, summarize, and delete tables; how to create and modify fields and field properties; and how to create and modify various types of forms and reports.
  • Create Databases
  • Create Tables
  • Modify Tables
  • Create Fields and Modify Field Properties
  • Create Forms
  • Create Reports
  • Modify the Design of Reports and Forms
Lab : Creating and Formatting Database Elements
After completing this module, students will be able to:
  • Create databases.
  • Create tables.
  • Modify tables.
  • Create fields and modify field properties.
  • Create forms.
  • Create reports.
  • Modify the design of reports and forms.
Module 3: Entering and Modifying Data
This module explains how to enter, edit, delete, and move among records; how to find and replace data; how to attach documents to records; and how to import data or link to external data.
  • Enter, Edit, and Delete Records
  • Navigate Among Records
  • Find and Replace Data
  • Attach Documents to and Detach from Records
  • Import Data
Lab : Entering and Modifying Data
After completing this module, students will be able to:
  • Enter, edit, and delete records.
  • Navigate among records.
  • Find and replace data.
  • Attach documents to and detach documents from records.
  • Import data.
Module 4: Creating and Modifying Queries
This module explains how to create various types of queries based on one table or multiple tables; how to add tables to and remove tables from queries; how to add criteria, joins, calculated fields, and aliases; and how to create SUM, AVERAGE, MIN, MAX, and COUNT queries.
  • Create Queries.
  • Modify Queries
Lab : Creating and Modifying Queries
After completing this module, students will be able to:
  • Create queries.
  • Modify queries.
Module 5: Presenting and Sharing Data
This module explains how to sort and filter data in tables, queries, reports, and forms; how to create and modify charts; how to export data from tables and queries; how to save database objects as other file types; and how to print database objects.
  • Sort Data
  • Filter Data
  • Create and Modify Charts
  • Export Data
  • Save Database Objects as Other File Types
  • Print Database Objects
Lab : Presenting and Sharing Data
After completing this module, students will be able to:
  • Sort data.
  • Filter data.
  • Create and modify charts.
  • Export data.
  • Save database objects as other file types.
Module 6: Managing and Maintaining Databases
This module explains how to back up, compact, and repair a database; how to encrypt a database by using a password; how to set database options and properties; how to identify object dependencies; how to print database information; and how to reset or refresh table links.
  • Perform Routine Database Operations
  • Manage Databases
Lab : Managing and Maintaining Databases
After completing this module, students will be able to:
  • Perform routine database operations.
  • Manage databases.
Before attending this course, students must have:
  • Six or more months of hands-on experience creating and managing databases by using Access 2007.
No prior certification is required.

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you