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 Training Part 2195.00Student6.0 hrs
 1 day introductory course covering database design, subdatasheets, data validation, advanced queries, and advanced reporting techniques. 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 assessments.

 
Session 1Tables and Queries 
 
  • Designing a Relational Database
    • Relational Database Design
    • Create a Table
    • Joining Tables
  • Joining Tables
    • Create Query Joins
    • Relate Data Within a Table
    • Work with Subdatasheets
  • Using Data Validation
    • Use Field Validation
    • Use Form and Record Validation

 
Session 2Advanced Queries and Reporting 
 
  • Creating Advanced Queries
    • Create Parameter Queries
    • Summarize Data
    • Create Subqueries
    • Create Action Queries
    • Create Unmatched and Duplicate Queries
  • Organize a Database for Efficiency
    • Data Normalization
    • Create a Junction Table
    • Improve Table Structure
  • Using Advanced Reporting Techniques
    • Include Control Formatting in a Report
    • Add a Calculated Field to a Report
    • Add a Subreport to an Existing Report