Access 2007 Certification Prep Course
21 hours, 3 or 5 sessions | Atlanta, GA and Online

Download and print the Access 2007 class (Atlanta) fact sheet (PDF file) by clicking here.

This course covers objectives included in the Access 2007 Certification Class - Microsoft Certified Application Specialist (MCAS) Exam 77-605.

• Are you responsible for creating or maintaining your organization's Microsoft Access 2007 databases?
  
  
• Are you interested in distinguishing yourself in an extremely tight and competitive job market?
  
  
• Would you like to upgrade your Access skills?
  
  
• Are you a virtual assistant or business owner,  interested in offering Access 2007 database creation as a service?
  

Why attend this Access training course?

• The curriculum used in this course covers objectives included in the Microsoft Certified Application Specialist (MCAS) Exam 77-605.
  
  
• Access database skills are in high demand, and employers are willing to pay higher salaries for employees with advanced Access skills.
  
  
• Representatives from the non-profit, legal, education, management consulting, health care, and real estate industries have attended our Access training courses.
  
  
• After completing this course, you will be able to save time and extend the capabilities of your Access databases.
  
  
• Your instructor has over 15 years of Access database development experience, and can provide real-world training.
  
  
• No boring theory. Instead, we'll use case studies and hands on exercises.
  
  
• This course is limited to 10 students, providing you the opportunity to get 1-on-1 assistance.

Feedback:

The class was very well taught and held my attention to the very end.

The instructor, Jackie, was organized, efficient, and willing to extend her instructional services even after the class was over. She did an excellent job showing her mastery of the ins and outs of Microsoft Access.  But most of all her cooperative attitude and her enthusiasm while instructing us must be commended.

Even after the class was over, Jackie has been an invaluable resource by showing her continuous quest to ensure that Microsoft Access is demystified. And last but not least, Jackie's level of professionalism when dealing with questions on Microsoft Access and her efforts to go beyond the call of duty to ensure that class participants thoroughly understand Microsoft Access has left me with a great admiration of her technical skills.

Caroline E., Environmental Engineer

Expect to Learn

You may choose to take one, some, or all of these sessions.

• Getting Started in the Access 2007 environment
• Creating databases and tables 
• Changing table designs
• Fields and records
  
• Data entry rules (input masks, field properties, etc.)

Session 2 (4 Hours) - Access 2007 Queries

• Basic queries
• Complex queries (calculated fields, summarizing and grouping values)
• Writing SQL queries
• Crosstab, parameter and action queries
  

Session 3 (4 Hours) - Access Relational Database Design Concepts | Importing & Exporting

• Relational databases
• Database normalization
• Relating tables & referential integrity
• Creating and modifying lookup fields
• Importing, exporting and linking objects
  

Session 4 (4 Hours) - Access 2007 Forms & Reports

• Creating and modifying forms
• Creating and modifying Access 2007 reports
• Creating, running and modifying macros
• Advanced form design (unbound controls, graphics, calculated values & combo boxes)
• Printing reports
• Customized headers and footers in reports
• Adding calculated values to reports
• Creating labels
• Using charts in forms and reports
  

Session 5 (4 Hours) - Advanced Access 2007 Topics 

• Pivot tables and charts
• Access 2007 Macros
• Database management (optimizing and protecting Access databases)
• Internet and Outlook 2007 integration

Your tuition includes:

• Hands-on computer based training
• Training manuals
• Practice exercises on CD
  
• Real world exercises.

Pre-requisites: 

This Access 2007 Certification Prep course, requires Windows VISTA or XP experience and familiarity with the keyboard.

Tuition: 

$559 for the entire course ($499 Early registration),
or $249 per 7 hour session ($199 Early Registration)

Upcoming Sessions of  Access 2007 Certification Prep Class - Atlanta, GA and Online

Please bring your laptop to these training sessions.

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, May 14 2012 - May 16 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Jun 11 2012 - Jun 13 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Jul 16 2012 - Jul 18 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Aug 20 2012 - Aug 22 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Sep 24 2012 - Sep 26 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Oct 29 2012 - Oct 31 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Access 2007 Comprehensive Course - MCAS Certification Prep
http://www.probiztechnology.com/c_access-2007-certification-prep.htm
Date(s): Monday - Wednesday, Dec 03 2012 - Dec 05 2012
Time:  9:00 am - 5:00 pm  (3 Session(s))
Fee: $499 - $599 Entire Course,  $199 - $249 per day

Enter your fee to pay via PayPal's secure server using your credit card.

1. Check or Money Order:
Complete the form, fax it to us, and mail it in with your check or money order.
All mailed payments must be received 3 business days before class.
Registration form - MS Word format - Click here.
Registration form - Adobe pdf format - Click here.



2. Credit card - online:
Enter your fee to pay via PayPal's secure server using your credit card.

Access Database Courses: 

Mastering Access Essentials - 2 Day Training Course for Beginners
Access 2007 Comprehensive Course - MCAS Certification Prep
Access 2010 Comprehensive Training - MCAS Certification Prep
Access Relational Database Design Bootcamp
Access 2003 Comprehensive Course
Access Queries from the Ground Up
Access Tables

Once you've mastered the Access 2007 Certification Prep class, you may wish to consider:

• Access Database Design Bootcamp (6 hours)
  Learn how to design databases, create relationships between tables, and more. In the 2nd half of the class, students get hands on experience relational database design experience.

Contact us: 

• Want to know when the next class is scheduled?
• Interested in 1-on-1 training?
• Want us to bring the class to your location?

To contact us please click here, email training AT probiztechnology DOT COM or call 770.498.7333. 

About your instructor: 

Ms. Kiadii helps business professionals use technology to save time, lower costs and increase profits. She provides business technology workshops, customized software training, and Access database solutions. She has taught programs for hundreds of business owners, the Small Business Development Center (GSU), Small Business Administration (Atlanta), Women's Economic Development Agency, Georgia Center for Nonprofits.

Refund / Cancellation Policy: 

If instructor cancels class, students will be issued a full refund. If a student cancels registration, at lease one week prior to class, instructor will issue a refund less $20 or 15% administrative fee, whichever is greater. No refunds will be issued if student cancels within a week of class; student will be issued a credit.

Contact us for more info. >