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 2 Overview

Creating Multiple Tab Queries 

  • Building Select Queries
  • Using Multiple Sort Orders
  • Developing ADN Criteria
  • Developing OR Criteria
  • Creating Calculated Fields
  • Building Summary Queries
  • Building Crosstab Queries
  • Building PivotTables and PivotCharts

Enhancing Forms 

  • Creating Subforms
  • Modifying Subforms
  • Creating Split Forms
  • Adding Tab Controls
  • Adding a Combo Box for Data Entry
  • Adding a Combo Box to Find Re ords
  • Adding Option Groups
  • Adding Command Buttons

Analyzing Data with Reports 

  • Creating Summary Reports
  • Creating Parameter Reports
  • Applying Conditional Formatting
  • Adding Lines
  • Adding Subreports
  • Modifying Section Properties
  • Using Domain Functions

Importing and Exporting Data 

  • Using Database Templates
  • Using Table Templates
  • Importing Data from Excel
  • Linking Data
  • Exporting Data to Excel
  • Analyzing Data with Excel
  • Publishing Data with Word
  • Merging Data with Word

Analyzing Data Design Using Northwind 

  • Normalizing Data
  • Analyzing Relationships
  • Evaluating Tables
  • Improving Fields
  • Using Subqueries
  • Analyzing Queries
  • Analyzing Forms
  • Analyzing Reports 

Creating Advanced Queries 

  • Querying for Top Value
  • Creating a Parameter Query
  • Modifying Query Properties
  • Creating a Make Table Query
  • Creating an Append Query
  • Creating a Delete Query
  • Creating an Updat Query
  • Specifying Join Properties
  • Finding Unmatched Records 
 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 12/5/2008
 $199
Enroll
 1/16/2009
 $199
Enroll
 2/27/2009
 $199
Enroll
 3/17/2009
 $199
Enroll

To Inquire About Future Classes

Request a class date
if one is not scheduled.