Search Courses
Class Details         [printable version]
Access 2007: Basic Register     
Course Number: AP0013
Category: Business & Office Applications
Location: ExecuTrain of Wichita
Duration: 1.00 day
Price: $225
Date: 04/14/2010
Description

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, 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.

Outlines
  • Unit 1: Getting started
    • Topic A: Database concepts
    • Topic B: Exploring the Access environment
    • Topic C: Getting help 

 

  • Unit 2: Databases and tables
    • Topic A: Planning and designing databases
    • Topic B: Exploring tables
    • Topic C: Creating tables 

 

  • Unit 3: Fields and records
    • Topic A: Changing the design of a table
    • Topic B: Finding and editing records
    • Topic C: Organizing records

 

  • Unit 4: Data entry rules
    • Topic A: Setting field properties
    • Topic B: Working with input masks
    • Topic C: Setting validation rules 

 

  • Unit 5: Basic queries
    • Topic A: Creating and using queries
    • Topic B: Modifying query results and queries
    • Topic C: Performing operations in queries 

 

  • Unit 6: Using forms
    • Topic A: Creating forms
    • Topic B: Using Design view
    • Topic C: Sorting and filtering records 

 

  • Unit 7: Working with reports
    • Topic A: Reports
    • Topic B: Modifying and printing reports