Synopsis:
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.

Formats:
Corporate groups (min. 2 students) at your facility or our studio in San Juan Capistrano, Orange County, California. Single individuals may take a scheduled class or arrange a private class.

Scheduling:
Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.

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

Session 1

Tables and Queries

3.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

&nbsp

Session 2

Forms, Reports and Sharing Data

3.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

&nbsp

Materials:
Students will receive a comprehensive manual and a training certificate.

Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. 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.