Access 2007 Advanced Course - Atlanta or Online
7 hours, 1 session | Atlanta, GA and Online

An advanced MS Access 2007 course, covering Access tables, queries, forms, reports and more. Ideally suited for job seekers.  

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

This course covers some of the 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

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

Can't attend our public classes? Want us to bring Microsoft Access training to your site? Interested in attending this training online? We offer affordable, customized training for groups of as few as 4 people. Contact us or call 770.498.7333 for details.

Since 2001, we've provided training for employers large & small, in the public and private sectors.

Feedback:

The class was very well taught and held my

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

Advanced Access 2007 Topics 

Creating SQL Queries
Union Queries
Crosstab Queries
Parameter Queries
Action Queries

Creating, running, modifying macros
Attaching macros to events
Creating User Interaction Macros
Creating User Input Macros
Creating AutoKeys and AutoExec Macros
Creating Data Transfer Mactors

Importing, Exporting and Linking Macros

Database Management
Optimizing Resources
Protecting Databases
Setting Access Options & Properties

Hyperlinks
Working with Outlook

Your tuition includes:

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

Pre-requisites: 

This Access 2007 Advanced course, requires attending the Access Basic and Intermediate courses or proficiency in comparable skills.

Tuition: 

$269 - $299

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

We offer public (live or online) classes for groups of four or more students. For information on our Access courses, please call 770.498.7333 or click here to send an email.

Access Courses: 

Access 2013 Comprehensive Training - MCAS Certification Prep (4 Days)

Includes: Intro to MS Access 2013 (2 days), Intermediate MS Access 2013 (1 Day), Advanced MS Access 2013 (1 Day)

Access 2010 Comprehensive Training - MCAS Certification Prep (4 Days)

Intro to MS Access 2010 (2 Days)

Intermediate MS Access 2010 (1 Day)

Advanced MS Access 2010 (1 Day)

Access 2007 Comprehensive Course - MCAS Certification Prep (4 Days)

Intro to MS Access 2007 (2 Days)

Intermediate MS Access 2007 (1 Day)

Advanced MS Access 2007 (1 Day)

Mastering Access Essentials - 2 Day Training Course for Beginners

Access Relational Database Design Bootcamp

Access Queries from the Ground Up

Access Tables

Access 2003 Comprehensive Course | Certification Prep

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