Top bar

Orange Coast Database Associates Database Training, Design and Programming Course Listing Page Computer training

Course Description

News and special offers from Orange Coast Database Associates

Separator bar



Programming &

What's New!


Site Map

Separator bar

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855


About Us

Contact Us

AIN100: Introduction to Microsoft Access

Book List | Course Links

Tuition: $295.00 per student

Length: 2 days

Synopsis: 2 day introductory course to Microsoft Access, the leading desktop database. Covers databases, tables, the datasheet, sorting and manipulating tables, import/export, queries, forms and reports. Using our supplied courseware, students will work on several small database application during this course. These database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access is assumed. As part of our courseware platform students have online access to course materials such as checklists, videos and assessments.

Formats: This course is a discounted package combining the following two courses: AIN100A and AIN100B. Please see those courses for available formats.

Scheduling: Flexible to suit your requirements. Both onsite and online classes are custom scheduled.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote


Format this document for printing

Session 1Tables and Data3.0 Hours
  • 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 Reports3.0 Hours
  • 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
Session 3Tables and Queries in Depth3.0 Hours
  • 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 4More on Forms and Reports; Sharing Data3.0 Hours
  • 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

Materials: Students will receive two comprehensive manuals and a training certificate.


Location: Classes are normally taught on-site at your facilities or via online Remote Learning. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.

Related Services

Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.

Copyright 2022 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-408-1350
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties and beyond.

Privacy Statement | Contact Information | FAQ's | Site Map | Back | Home | Top