You are here: Home instructional_framework official_framework Business and Information Technology Education Microsoft Office Specialist Access Study Prep
Log in

Need a new SSL certificate?

View Career Major Course

Course Information
Business and Information Technology Education
Microsoft Office Specialist Access Study Prep
This course builds on the Administrative Technologies II skills and will provide students with the ability to practice and prepare for Exam 77-605: MCAS: Using Microsoft Office Access 2007.
Blake McCrabb
(405) 743-5419
Structuring a Database
• Define data needs and types.
• Define Normal Forms
• Define Data Types
• Define and use Table Analyzer

• Define and print table relationships.
• Work with Relationships
• Define and use Referential Integrity
• Join tables
• Create a Relationship Report

• Add, set, change, or remove primary keys.
• Split databases.

Creating and Formatting Database Elements
• Create databases.

• Create tables.

• Modify tables.

• Create fields and modify field properties.
• Create a New Field
• Set Properties in Design View
• Set Input Masks
• Set a Validation Rule for Selected Field
• Lookup Lists and Multivalued Fields

• Create forms.
• Use Form Tools
• Create Form Wizard
• Manually create Forms
• Create PivotCharts and PivotTables

• Create reports.
• Use Report Tool
• Create Report Wizard
• Manually create Reports
• Print Reports
• Create labels using the Label Wizard

• Modify the design of reports and forms.
• Set the Controls of a Report or a Form
• Modify the Layout of a report or a Form
• Format Reports and Forms
• Use AutoFormats with a report or form

Entering and Modifying Data
• Enter, edit, and delete records.
• Enter and Edit Records
• Delete a Record

• Navigate among records.

• Find and replace data.
• Find Data
• Use Wildcards
• Replace Data
• Attach documents to and detach from records.

• Import data.
• Import Data
• Link Data
• Import data by using Specifications

Creating and Modifying Queries
• Create queries.
• Select Queries
• Set Criteria parameters in a Query
• Create Action Queries
• Create Subqueries

• Modify queries.
• Make Table Changes
• Crate Parameters in a Query
• Joins Queries
• Make Calculations in a Query

Presenting and Sharing Data
• Sort data.
• Sort data by Text vs. Numbers
• Make Tables and Forms
• Sort Queries

• Filter data.
• Use Simple Filters
• Use Common Filters
• Filter by Selections
• Filter by Form

• Create and modify charts.

• Export data.

• Save database objects as other file types.
• Save Earlier Access Formats
• Save in XPS Format
• Save as Database Objects

• Print database objects.

Managing and Maintaining Databases
• Perform routine database operations.
• Exclusive Use
• Perform Back Ups Backing Up
• Problem Prevention
• Link Repair

• Manage databases.
• Create Passwords and Encryption
• Use Database Options
• Access Database Information

• Students will complete simulations tests over the Microsoft Certified Application Specialist in Access
Exam 77-605:
MCAS: Using Microsoft Office Access 2007
Career Majors That Sequence This Course
Career Cluster Pathway Career Major
Business Management & Administration Administrative & Information Support Microsoft Office Specialist