Microsoft Access 2010 Training - Advanced

Upgrading your Microsoft Access skills is a smart move for any professional.

  Get Started Now

Ideal for those seeking to advance their careers by developing top-notch database skills, the Microsoft Access 2010 Advanced course by Simon Sez IT provides 8 full hours of expert quality training videos. Your trainer takes the seemingly overwhelming concept of advanced database management and breaks it into several easy to understand, detailed chapters. A general understanding of previous versions of Microsoft Access will make this advanced course comfortable and will be a great base from which to build.

Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases.

This course includes:

  1. An online quiz (40 questions) - to test what you've learned.
  2. A certificate of completion to tell everyone you've aced the course.
  3. Downloadable & printable transcripts – to give you another learning option, if you prefer reading but don’t have time to take notes.

Where else can you find so many extra tools to help you master Access 2010?!?!

All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.

What our customers are saying:

"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"

- Lisa R., France.


Your Instructor


Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Course Curriculum


  Chapter 1 - Introduction
Available in days
days after you enroll
  Chapter 2 - Macros
Available in days
days after you enroll
  Chapter 3 - Database Options before Distribution
Available in days
days after you enroll
  Chapter 4 - Naming
Available in days
days after you enroll
  Chapter 5 - Tables
Available in days
days after you enroll
  Chapter 6 - Keys and Indexes
Available in days
days after you enroll
  Chapter 7 - Normalization
Available in days
days after you enroll
  Chapter 8 - Relationships
Available in days
days after you enroll
  Chapter 9 - Queries
Available in days
days after you enroll
  Chapter 10 - Datasheet View
Available in days
days after you enroll
  Chapter 11 - Forms
Available in days
days after you enroll
  Chapter 12 - Visual Basic for Applications
Available in days
days after you enroll
  Chapter 13 - Polishing Up
Available in days
days after you enroll
  Chapter 14 - Security
Available in days
days after you enroll
  Chapter 15 - Import/Export
Available in days
days after you enroll
  Chapter 16 - Linking to Data
Available in days
days after you enroll
  Chapter 17 - Splitting Database
Available in days
days after you enroll
  Chapter 18 - Multi-User
Available in days
days after you enroll
  Chapter 19 - Reports
Available in days
days after you enroll
  Chapter 20 - Package & Distribute
Available in days
days after you enroll

Frequently Asked Questions


Do you offer discounts for non-profits or educational institutions?
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Do you provide any group discounts?
Yes, we offer group discounts or multiple users. Contact [email protected] for more information.
How long have you been in business?
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 60 courses, with tens of thousands of satisfied customers in over 100 countries.
Where is Simon Sez IT located?
Simon Sez IT is located in sunny Los Angeles, California.
Do you offer Certificates of Completion?
We offer Certificates of Completion for courses that offer an online quiz (currently over 50% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Do you offer any online quizzes or testing tools?
We offer online testing for over 50% of our courses. Testing is also available with our newly published courses. The course tests can be simply used as testing tools or to earn a Certificate of Completion for a given course. The Certificate of Completion can be earned with a passing grade of 70%.
Will your videos work with iPhone, iPads, and Android devices?
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
Will your videos work with Mac computers?
All of our courses are compatible with both Windows (PC) and Mac computers.
Can I interact with others who are taking the same course?
Yes, you can interact with others by using the discussion section offered for each course.
What if I have questions or problems while I am watching my tutorial?
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
Can I try a course I am interested in before I purchase a course?
Absolutely. The first set of videos for each course is free. Our thinking is that this allows you to hear the teacher's voice and see the visuals. To watch a free video, just click onto the course of interest. Then click the video lesson that has the \“Preview\” button.
Do you offer a subscription option?
Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership.
Can I get my money back if I am not satisfied?
We offer an unconditional 14-day full money back guarantee – with no questions asked. As a result, you can rest assured that you can make your purchase in complete confidence. Our motto is \“If you don't learn, you don't pay.\” Thanks to our 14 days risk-free offer, you can test-drive a course and make sure it's what you had in mind. We are committed to your total satisfaction!
How long do I have access to the class that I purchased?
After purchase, you will have unlimited access to this course for as long as you like - across any and all devices you own.
When does the class start and finish?
The class starts now and never ends! It is a completely self-paced online class - you decide when you start and when you finish.

Get started now!