Access 2007 Comprehensive Course

***At least $200 less than comparable classes***

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

Can't attend? Want us to bring this course to your site? We offer affordable, customized training for groups of as few as 4 people. Contact us or call 770.498.7333 for details.

Register to attend 1, 2, or all 3 sessions.

***Please bring your laptop.*** If you need us to provide the laptop, let us know when you register.

• 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?

 To pay by check, please click here. (Downloadable registration form in pdf format).

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.

 To pay by check, please click here. (Downloadable registration form in pdf format).

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

What you will learn:
This 21 hour class, taught in 3 sessions, covers these topics:

***Please bring your laptop.***

Introduction to Access 2007 | Access Tables

• 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.)

Access 2007 Queries

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

Access 2007 Relational Database Design

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

Access 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
  

Advanced Access 2007 Concepts

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

Your registration fee includes:

• Hands-on computer based training
• Training manual(s)
• Practice exercises on CD
• Real world exercises.

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

Other Access Courses:

Access Relational Database Design Bootcamp
Access 2003 Comprehensive Course
Access 2003 Queries from the Ground Up
Access 2003 Tables
Access 2007 Comprehensive Course - MCAS Certification Prep
Access 2010 Comprehensive Training - MCAS Certification Prep

For a list of our Atlanta-area and online Software and Internet Marketing, click here. For a list of our Atlanta Quickbooks Training Classes, visit http://www.Quickbooks-Training-Atlanta.com. 

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 $75 administrative fee. No refunds will be issued if student cancels within a week of class; student will be issued a credit.Credits are good for 90 days.