Course Info

MA2007-1 - Microsoft Access 2007: Introduction

Categories Database Training, Applications Training, MOUS Certification Training, Microsoft Access Training

Duration 1 day (7 hours)

Pre-requisites Students should have completed the following courses or possess equivalent knowledge before starting this course: Windows 2000 Windows XP

Courseware MA20071-EK (100 pages)

Price $195

Notes

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

Exploring the Microsoft® Office Access™ 2007 Environment
      Examine Database Concepts
      Explore the User Interface
      Use an Existing Access Database
      Customize the Access Environment
      Obtain Help
Designing a Database
      Describe the Relational Database Design Process
      Define Database Purpose
      Review Existing Data
      Determine Fields
      Group Fields into Tables
      Normalize Data
      Designate Primary and Foreign Keys
      Determine Table Relationships
Building a Database
      Create a New Database
      Create a Table
      Manage Tables
      Create a Table Relationship
      Save a Database as a Previous Version
Managing Data in a Table
      Modify Table Data
      Sort Records
      Work with Subdatasheets
Querying a Database
      Filter Records
      Create a Query
      Add Criteria to a Query
      Add a Calculated Field to a Query
      Perform Calculations on a Record Grouping
Designing Forms
      View Data Using an Access Form
      Create a Form
      Modify the Design of a Form
Generating Reports
      View an Access Report
      Create a Report
      Add a Custom Calculated Field to a Report
      Format the Controls in a Report
      Apply an AutoFormat Style to a Report
      Prepare a Report for Print