Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com

Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
AIN100BMicrosoft Access Level 2195.00Student6.0 hrs
 1 day introductory course covering database normalization, subdatasheets, import/export, advanced queries, reports and forms. Using our courseware students may update several small database applications, including any created in AIN100A. This course is the same as AIN100 Introduction to Microsoft Access day 2. Microsoft Access knowledge equivalent to AIN100A is assumed. The next class in sequence is AIN103 Microsoft Access level 3.Following the class students will have ongoing access to online support materials such as videos and assesments.

 
Session 1Tables and Queries 
 
  • Controlling Data Entry
    • Constrain Data Entry Using Field Properties
    • Establish Data Entry Formats for Entering Field Values
    • Create a List of Values for a Field
  • Joining Tables
    • Create Query Joins
    • Join Tables That Have No Common Fields
    • Relate Data Within a Table
  • Creating Flexible Queries
    • Set the Select Query Properties
    • Retrieve Records Based on Input Criteria
    • Create Action Queries

 
Session 2Forms, Reports and Sharing Data 
 
  • Improving forms
    • Restrict Data Entry in Forms
    • Organize Information with Tab Pages
    • Add a Command Button to a Form
    • Create a Sub form
    • Display a Summary of Data in a Form
    • Change the Display of Data Conditionally
  • Customizing reports
    • Organize Report Information
    • Format Reports
    • Control Report Pagination
    • Add a Calculated Field to a Report
    • Add a Sub report to an Existing Report
    • Create a Mailing Label Report
  • Sharing data across applications
    • Import Data into Access
    • Export Data to Text File Formats
    • Export Access Data to Excel
    • Create a Mail Merge