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
AIN100AMicrosoft Access Level 1195.00Student6.0 hrs
 1 day introductory Microsoft Access course covering databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using our courseware students will work on several small database applications during this course. These can be tailored to the needs of a custom group or private training student. No prior knowledge of Access is assumed. The next class in sequence is AIN100B Microsoft Access level 2.Following the class students will have on-going access to online materials such as videos and assesments.

 
Session 1Tables, Relationships, and Data 
 
  • Getting Started with Access Databases
    • Identify the Elements of the Access Interface
    • Identify the Components of a Database
    • Examine the Relational Database Design Process
  • Building the Structure of a Database
    • Create a New Database
    • Create a Table
    • Manage Tables
    • Establish Table Relationships
  • Managing Data in a Table
    • Modify Table Data
    • Sort and Filter Records
    • Work with Subdatasheets

 
Session 2Queries, Forms and Reports 
 
  • Querying a Database
    • Create a Query
    • Add Criteria to a Query
    • Add a Calculated Field to a Query
    • Perform Calculations on a Record Grouping
  • Designing Forms
    • Create a Form
    • Modify the Design of a Form
    • View and Edit Data Using an Access Form
  • Generating Reports
    • Create a Report
    • Add a Control to a Report
    • Format the Controls in a Report
    • Enhance the Appearance of a Report
    • Prepare a Report for Print