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

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->ain100a

Group Training

Individual Training

Scheduled Classes

Programming and Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

AIN100A: Microsoft Access Level 1

Book List | Course Links

Tuition: $195.00 per student

Length: 1 day

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

Formats: Custom scheduled 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

 

Format this document for printing

Session 1Tables, Relationships, 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
 

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.


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