Access 2003 Comprehensive Course

A comprehensive MS Access course, covering Access tables, queries, forms, reports and more. Ideally suited for job seekers.

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

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

1. Monday, December 7, 2009 | 6:00 pm - 9:45 pm
2. Tuesday, December 8, 2009 | 6:00 pm - 9:45 pm
3. Wednesday, December 9, 2009 | 6:00 pm - 9:45 pm
4. Thursday, December 10, 2009 | 6:00 pm - 9:45 pm
5. Friday, December 11, 2009 | 6:00 pm - 9:45 pm

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 7, 2009 | 6:00 pm - 9:45 pm

• Identifying and exploring database components
• Creating databases
• Creating tables
• Working with Table Data
• Adding, editing and deleting records

Session 2 - Access Tables & Queries
Tuesday, December 8, 2009 | 6:00 pm - 9:45 pm

• Modifying table properties
• Finding records
• Using filters
• Creating simple queries
• Using select queries to extract data from one or more tables.

Session 3 - Access Queries
Wednesday, December 9, 2009 | 6:00 pm - 9:45 pm

• Translating business questions (ex., how many of our regular donors didn't pledge last year) into powerful queries.
• Using Access 2003 select, update, delete, make table, and and append queries.
• Using Access queries to find unmatched or duplicate records.
• Using parameter queries to supply criteria on the fly.
• Using queries to convert Excel spreadsheets to Access tables.

Session 4 - Access Forms
Thursday, December 10, 2009 | 6:00 pm - 9:45 pm

• Creating and using forms
• Using sub forms
• Advanced form features

Session 5 - Access Reports
Friday, December 11, 2009 | 6:00 pm - 9:45 pm

• Creating and using reports
• Modifying report properties
• Editing reports
• Advanced report features

Your registration fee includes:

• Hands-on computer based training
• 2 Training manuals
• Practice exercises 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.