Custom programming solutions, applications and training!

Access Training

Contract CADD Group - Phone: (604) 591-1140 Email: frank.zander@contractcaddgroup.com

Looking for CADD expertise?  Think Contract CADD Group!
Looking for Web Solutions?    Think CORBIMITE!

Phone: (604) 591-1140
Toll Free: 1 866 433-2233

Access 2002/XP Training

Access Course Outline

This three day course is fully customizable to meet the learner requirements!  This course (usually) focuses on building and maintaining Access tables, forms, queries and reports.  All work in Access will be done on the student's "real" project.  Course materials will be generated to accommodate the individual learned outcomes of each days training.  i.e. screen captures and notes will be taken throughout the course as the student works to generate a "reference hand book" of the project.

Course objectives

By the end of the course the student will have mastered the skills required to create and manage reports from SQL queries on Access tables.   The student will also be able to design forms keeping human interface and data structure in mind.  Also, the student will be able to connect Access to a SQL data source and create reports based on queries.  The student will generate a "reference hand book" of the project.

Course Content

At the beginning of the first session, the instructor and the student will clarify what aspects of the "real" project are problematic, and where the best use of training/documentation should be focused.  I have found that this training approach is  very project-results-based and tends to deeply-engage the learner -- they see their own project coming to fruition -- very exciting!

  • Building Tables and Relationships - "How is the data related?"
  • Building Queries (incl. SQL filters) - "What are we searching for?"
  • Basic reporting  - "How do you want to display your results?"
  • Creating New Reports, modifying and editing reports - "Maintaining a consistent 'report-look'
  • Non destructive Reports - "Modifying a report, NOT the database for a consistent look"
  • Exporting Data (Results of queries) - "Reusing data in other programs"
  • Compacting the database - "Database management"
  • Repairing the database - "More database management"
  • Creating and modifying Access forms - "Talking to the user, getting input!"
  • Intro / Overview of SQL
  • How to connect to the SQL data source
  • Backing up and restoring the database

CORBIMITE Web Solutions
Website created By Frank Zander
Phone: (604) 591-1140
Copyright 2006 
Contract CADD Group
All rights reserved.


Contract CADD Group is an Autodesk Developer Network member.

Please give us Feedback!
Send your comments and  suggestions to:
Frank Zander
Revised: September 07, 2008.

Visit our favorite websites

CORBIMITE Website hosting
Registration | Hosting | Design
Vizdeopt Visualization resource
Nvidia Nvidia forums
Tenlinks Top 10 AutoCAD VBA
cadalyst Cadalyst CAD eZine
Back Back Top of Page
Search

ENGLISH > SPANISH ENGLISH > BRAZILIAN ENGLISH > CHINESE ENGLISH > FRENCH - FRANCAIS ENGLISH > GERMAN - DEUTSCH ENGLISH > ITALIAN ENGLISH > JAPANESE ENGLISH > KOREAN ENGLISH > PORTUGUESE Contract CADD Group