Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
AIN103Microsoft Access Training Part 3165.00Student6.0 hrs
 This course covers advanced form techniques, sharing data, working with macros and VBA, performing database maintenance and switchboards. Classroom activities can be tailored for private classes. Microsoft Access knowledge equivalent to AIN100 is assumed.

 
Session 1Application Enhancements 
 
  • Advanced Form Techniques
    • Add Controls to Forms
    • Enhance Navigation and Organization of Forms
    • Apply Conditional Formatting
  • Sharing Data
    • Import Data into Access
    • Export Access Data
    • Link Tables to External Data Sources
    • Create a Mail Merge
  • Macros
    • Create a Macro
    • Restrict Records Using a Condition
    • Validate Data Using a Macro
    • Automate Data Entry Using a Macro
  • Using VBA
    • Getting Started with VBA
    • Enhance Access by Using VBA

 
Session 2Deployment Considerations 
 
  • Advanced Database Management
    • Manage a Database
    • Determine Object Dependency
    • Document a Database
  • Distributing and securing a database
    • Split a database for multiple user access
    • Implement security
    • Convert a database to an ACCDE
    • Package a database with a digital signature
  • Switchboards
    • Create a switchboard
    • Modify a switchboard
    • Set startup options