Orange Coast Database Associates Course Listing Page

Microsoft Access Training

What's new at Orange Coast Database Associates

 Home-->Courses-->aia101

Map of the Laguna Niguel and San Juan Capistrano area.

Click links below for related database courses offered by Orange Coast Database  Associates

Other MS Access Courses

SQL Training

Relational Database Training

FAQ's

Links

Site Map

Free Catalogs

Home

About Us

Course Catalog

Glossary

Books

Contact Us

AIA101: Accelerated Introduction to Access

Course Links | Practice Test

Tuition: $295.00 per student

Length: 1 and 1/2 days

Synopsis: Accelerated Introduction to Microsoft Access course for experienced Microsoft Office users. Corresponds roughly to material required for MOUS proficient level plus some additional material. Covers tables, external data, queries, forms, reports and macros. 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: Affordable 1-on-1 private training and custom groups (min. 2 students) at your facility or ours in Orange County, California.

Scheduling: Group and private training conveniently scheduled by arrangement.

Group Discounts: Substantial - see FAQ's.

Format this document for printing

Session 1 Tables and Queries 4.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 2 Reports and Forms 3.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 3 Automating Tasks 2.0 Hours
 
  • Action queries.
  • Macros
  • Using control wizards.
  • Switchboards
 

References: Please see the book list for references you may want to have available. We are an Amazon.com affiliate and you may purchase your Microsoft Access books through this site.

Materials: Students will receive a notebook with a printout of all slides used in their class and a training certificate.

Location: Classes are normally held on-site at your facilities or at our location in San Juan Capistrano, Orange County. We do, however, offer other alternatives. Please see FAQ's if interested. We also travel beyond Southern California.

 

Related Services

Before and after your class we can also provide Microsoft Access programming and consulting services covering the above material. Inquire here to learn more.


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

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