::Computeach:: Technology training for the real world
navbar
This text is replaced by the Flash movie.




Course: Access XP 2003/2007 I/II

Overview
Individuals with limited or no experience with Access will learn the skills necessary to create powerful solutions using one of the most popular database technologies available today. Creating and updating tables, and data, along with building forms and queries are covered in depth. The training will prepare an individual for the Microsoft Office Specialist (Office Specialist or MOS) certification, which is the globally recognized standard for validating expertise with the Microsoft Office suite of business productivity programs.

Topics Included in Training

Course I
Database Concepts
• Terminology
• Access Environment
• Planning and Design
Access Basics
• Tables and Forms
• Queries and Reports
Creating a Database
• Table Wizard
• Design View
Fields and Records
• Add/Delete Records
• Find/Edit Records
• Sort/Filter Records
Data Entry
• Field Properties
• Input Masks
• Validation Rules
Querying Tables
• Create and Use Queries
• Modify Queries
Create and Use Forms
• Form Wizard
• Design View
Reports
• Create/Modify Reports
• Printing

Course II
Relational Database Design
• Concepts
• Data Integrity
Related Tables
• Lookup Fields
• Subdatasheets
Complex Queries
• Joining
• Calculations
• Action
Advanced Forms
• Unbound Controls
• Graphics
• Calculations
• Combo Boxes
Advanced Reports
• Headers and Footers
• Calculated Values
• Subreports
Charts
• Forms and Reports
PivotTables/PivotCharts

Prerequisite: Access XP I or equivalent knowledge (for Course II only)
Certification Tests: Offered in our Certiport Testing Center
Access 2003 Core (MOS)
Format: 8 Hours Instructor Led Training (Each Course)
Daytime and Evening/Saturday Classes Available

Course ContentCourse ContentCourse Content Subject to Change without Notice
Version 031/032-403
::Computeach:: Technology training for the real world