A comprehensive MS Access 2010 course, covering Access tables, queries, forms, reports, macros and more. Ideally suited for job seekers.  Curriculum approved as MCAS certification prep.

• Are you responsible for creating or maintaining your organization's Microsoft Access 2010 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 2010 database creation as a service?

Please bring your laptop to this class (or let us know if we need to provide one).

For Access 2013 comprehensive training, click here.

Why attend this Access training course?

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

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.

The employers we've provided training for include ...

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 (Access 2007 class feedback).

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

The course is organized into 4 sessions, for a total of 4 days of training:

Access 2010 Fundamentals Training (2 days)

Access 2010 Intermediate Training (1 day)

Access 2010 Advanced Training (1 day)

Intro to Access 2010 (2 Days)

• Introduction to MS Access
• Getting Started with MS Access
• Planning and Designing Databases
• Exploring and Creating Tables
• Changing the Design of a Table
• Finding and Editing Records
• Creating Data Entry Rules
• Creating Queries
• Modifying Queries
• Using Calculations in Queries
• Creating and Modifying Forms
• Creating and Modifying Reports
• Importing Excel Workbooks into Access - Dos & Don't's

Intermediate Access 2010 (1 Day)

Relational databases
Database normalization
Relating tables
Implementing referential integrity
Related tables
Lookup fields
Modifying lookup fields
Subdatasheets
Complex queries
Joining tables in queries
Calculated fields
Summarizing and grouping values
Advanced form design
Adding unbound controls
Adding Graphics
Adding calculated values
Adding combo boxes
Advanced form types
Reports and printing
Customized headers and footers
Adding calculated values
Printing
Labels
Charts in forms
Charts in reports
PivotTables
Modifying PivotTables
PivotCharts
PivotTable forms

Advanced Access 2010 (1 Day):

Action Queries
Advanced Macros
Advanced Queries
Attaching macros to events
Attaching SQL queries to controls
Creating AutoKeys and AutoExec Macros
Creating macros for data transfer
Creating macros that require user input
Creating macros to provide user interaction
Creating, running, modifying macros
Crosstab Queries
Database Management
Hyperlink fields
Importing, Exporting, Linking
Optimizing Resources
Parameter Queries
Protecting databases
Querying with SQL
Setting options & properties
Writing SQL Statements

Your tuition includes:

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

Pre-requisites: 

This Access 2010 course, requires Windows 7, VISTA or XP experience and familiarity with the keyboard.

Upcoming Sessions of  Access 2010 Comprehensive 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 least one week prior to class, instructor will issue a refund less $85 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. Credits are good for 90 days.