Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 
 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Microsoft Access 2007 Level 1 Overview

Getting Started with Office 2007 

  • Understanding the Office 2007 Suite
  • Starting and Exiting an Office Program
  • Viewing the Office 2007 User Interface
  • Creating and Saving a File
  • Opening a File and Saving it with a New Name
  • Viewing and Printing Your Work
  • Getting Help and Closing a File 

Getting Started with Access 2007 

  • Understanding Relational Databases
  • Opening a Database
  • Entering Data
  • Editing Data
  • Creating a Database
  • Creating a Table
  • Creating Primary Keys
  • Relating Two Tables
  • Printing a Datasheet

Building and Using Queries 

  • Creating a Query
  • Using Query Design View
  • Modifying Queries
  • Sorting and Finding Data
  • Filtering Data
  • Applying AND Criteria
  • Applying OR Criteria
  • Formatting a Datasheet
  • Concepts Review
  • Skills Review
  • Independent Challenges
  • Visual Workshop 

Using Forms 

  • Creating a Form
  • Using Form Layout View
  • Using Form Design View
  • Adding Fields to a form
  • Modifying Form Controls
  • Creating Calculations
  • Modifying Tab Order
  • Inserting an Image

Using Reports 

  • Previewing a Report
  • Using the Report Wizard
  • Using Report Design View
  • Using Report Sections
  • Adding Subtotals and Counts
  • Resizing and Aligning Controls
  • Formatting a Report
  • Changing Page Layout

Modifying the Database Structure

  • Examing Relational Databases
  • Designing Related Tables
  • Creating One-to-Many Relationships
  • Creating Lookup Fields
  • Modifying Text Fields
  • Modifying Number and Currency Fields
  • Modifying Date/Time Fields
  • Modifying Validation Properties
  • Creating Attachment Fields
 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 12/4/2008
 $199
Enroll
 1/15/2009
 $199
Enroll
 2/26/2009
 $199
Enroll
 3/16/2009
 $199
Enroll

To Inquire About Future Classes

Request a class date
if one is not scheduled.