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 Level 1 Overview

Getting Started With Access

  • Understand relational databases
  • Learn database terminology
  • Start Access and open a database
  • Work with the database window
  • Navigate records
  • Enter records
  • Edit records
  • Preview a datasheet
  • Get Help and exit Access 

Using Tables and Queries

  • Organize fields
  • Plan related tables
  • Create a table
  • Modify a table
  • Format a datasheet
  • Understand sorting, filtering, and finding
  • Sort records and find data
  • Filter records
  • Create a query
  • Modify a query

Using Forms

  • Plan a form
  • Create a form
  • Move and resize controls
  • Modify labels
  • Use text boxes for calculations
  • Modify tab order
  • Enter, edit and print records
  • Insert an image

Using Reports

  • Plan a report
  • Create a report
  • Use group sections
  • Change sort order
  • Add a calculation
  • Align controls
  • Format controls
  • Change page layout

Modifying the Database Structure

  • Examine relational databases
  • Create related tables
  • Create one-to-many relationships
  • Create Lookup fields
  • Modify Text fields
  • Modify Number and Currency fields
  • Modify Date/Time fields
  • Modify field validation properties

 
 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 9/29/2008
 $199
Enroll

To Inquire About Future Classes

Request a class date
if one is not scheduled.


Comments on the Course

PROMOTIONS!

PLEASE CLICK ON THE LINK BELOW FOR A LIST OF CURRENT SPECIALS  

Knowledge Transfer Promotions