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-->aia101

Related Courses

Group Training

Individual Training

Scheduled Classes

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Request Information or Quote

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

AIA101: Accelerated Introduction to Access

Book List | Course Links

Tuition: $245.00 per student

Length: 1 and 1/2 days

Synopsis: Accelerated Introduction to Microsoft Access, the powerful but user-friendly desktop database. For experienced Microsoft Office users. Corresponds roughly to material required for MOS certification. Covers tables, external data, queries, forms, reports, action queries, macros and navigation. Students will create a working database application during this intensive, hands-on course. This database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access assumed although students should be proficent with standard Microsoft Office.

Formats: Corporate groups (min. 2 students) at your facility or online.

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 and Queries4.0 Hours
 
  • Creating an MS Access database
  • Designing tables
  • Exporting tables to Excel and text files
  • Importing files
  • Creating Permanent Links between Tables
  • Creating simple and multi-table queries
  • Calculated fields and concatenation
  • Summary and parameter queries
  • Using the expression builder
 
Session 2Reports and Forms2.0 Hours
 
  • Creating reports
  • Formatting your report.
  • Adding graphics.
  • Subreports and one-to-many reports
  • Creating forms
  • Formatting your form
  • Adding subforms to a main form
  • Subtotals
  • Using the builders and wizards.
 
Session 3Automating Tasks3.0 Hours
 
  • Action queries.
  • Macros
  • Using control wizards.
  • Switchboards & Navigation Forms
 

Materials: Students will receive a notebook with a printout of all slides used in their class 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.


Copyright(2001-2016) D.H.D'Urso & Associates

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