Access 2007 Comprehensive Course

A comprehensive MS Access 2007 course, covering Access tables, queries, forms, reports and more. Ideally suited for job seekers.  This course covers objectives included in the Microsoft Certified Application Specialist (MCAS) Exam 77-605.

• Are you responsible for creating or maintaining your organization's Microsoft Access 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 databases 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

Dates / Times (5 Sessions, 17.5 hours total)

What you will learn:
This 17.5 hour class, taught in 5 sessions, covers these topics:

Session 1  -  Introduction to Access 2003 | Access Tables
Monday, December 14, 2009 | 2:00 pm - 5:30 pm

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

Session 2 - Access Tables & Queries
Tuesday, December 15, 2009 | 2:00 pm - 5:30 pm

• Basic queries
• Introduction to forms
• Introduction to reports
• Complex Queries

Session 3 - Access Queries
Wednesday, December 16, 2009 | 2:00 pm - 5:30 pm

• Advanced form design
• Reports and Printing
• Charts in forms and reports

Session 4 - Access Forms
Thursday, December 17, 2009 | 2:00 pm - 5:30 pm

• Querying with SQL
• Advanced Queries
• Creating, running and modifying macros

Session 5 - Access Reports
Friday, December 18, 2009 | 2:00 pm - 5:30 pm

• Importing, exporting and linking
• Optimizing and protecting databases
• Internet and Outlook 2007 integration

Your registration fee includes:

• Hands-on computer based training
• 3 Training manuals
• Practice exercises on CD
• Certification practice exams (on CD)
  
• Real world exercises.

Pre-requisites: Windows experience and familiarity with the keyboard.

Other Courses:

Once you've mastered this 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 creating a relational database design.

Contact us:

To contact us about scheduling a presentation at your location, or to answer any questions please click here 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 $50 administrative fee. No refunds will be issued if student cancels within a week of class; student will be issued a credit.