Microsoft Access 2010 – Beginner to Advance Level

  • Understand the concepts and features of Microsoft Access 2010!.
  • Start learning as a beginner and grow to be an advance user!
  • Learn from leading industry expert, gain professional training plus certificate to show!

E-Learning Course:

Study at your own pace! 12 Month Access to learn at the comfort of your home – Anytime!! Anywhere!!!

Microsoft Access 2010 Training

Gain professional understanding and advance skills in managing Microsoft Access 2010 application. This course is developed by industry experts and the training are split in three parts – Beginners, Intermediate and advance levels.

The courses are professional developed to enable the learners gain extensive understanding of Microsoft Access 2010, starting as a beginner up to the advance level.

Learner will gain professional understanding of Microsoft Access 2010, understand the fundamental features of Access 2010, how to create databases, managing data entries, running commands, queries, normalising data, modifying charts, how to use PivotTables and PivotChart, creating tables and lookups, managing databases, managing advance forms, SQL querying, interact with XML documents, macros, working with xml and lots more .

At the end of this course, learner should be professionally qualified and well skilled at Microsoft Access, learner will also gain relevance certificate of excellence to show.

Studying this course from LPT via elearning route means you get quality, up to date training and contents, study materials, instructor led training, quizzes, test, plus the ability to study anywhere anytime, with 247 access to the learning portal for 12 months.

What's Included

During the course of your study, you will be tested via quizzes and mock exams where required. The course is delivered via interactive learning videos and study materials with 12 months access to study 247 anywhere anytime.

This course is a training video developed by industry experts with up to date information and the best learning outcome. It include module exercises, interactive courses plus:

Certificate of Achievement
247 course Access
365 Days Access
Reviews, Quiz & Mock Exam
24/7 Support
Interactive & Scenario based video learning
Compatibility on mobile, tablet, laptop and desktop

Microsoft Office Access 2010 Course Outline:


  • Course Introduction
  • Getting Started with Database Concepts
  • Exploring the Access Environment
  • Planning and Designing Databases
  • Fields and Records
  • Data Entry Rules and Basic Queries
  • Creating Forms
  • Applying Conditional Formatting
  • Sorting and Filtering Records
  • Working with Reports


  • Relational Databases
  • Establishing Relationships
  • Creating Lookup Fields
  • Joining Tables in Queries
  • Advanced Form Design
  • Adding Calculated Values
  • Reports and Printing
  • Creating a Chart in a Form
  • Using PivotTables and PivotCharts


  • SQL and Access
  • Attaching SQL Queries to Controls
  • Creating Crosstab Queries
  • Creating, Running, and Modifying Macros
  • Creating Macros to Provide User Interaction
  • Importing, Exporting, and Linking
  • Linking Access Objects and Using Hyperlink Field

Upon completing this training, learner will be assessed by taking an online multiple choice questions with automatic grading. You can take the assessment test as many times as you want.

Anyone Can Take This Course.


Will i get a certificate after completing this course?

Upon completing this course, candidate will be awarded the relevant certificate for excellence. The certificate will be delivered as a digital copy, you may however contact us to purchase the printed version.

What other methods of learning do you offer?

We offer this course as a Self-paced Elearning Course, Virtual Online Class, Blended Learning, Group Booking or In-house training. Contact us or search our website for other delivery type for this course title.

Rate & Review this course

We love feed backs! Kindly rate and review this course via the button below.

Submit your review



Create your own review
Microsoft Access 2010

Average rating:  

 0 reviews



  • Professional Support & Friendly Customer Service!
  • Interactive Learning Videos & Study Materials!
  • COMPATIBILITY: Windows, Mac, iPhone, iPad, Laptop, PC, Mobile


Related Courses

Select your currency
USD United States (US) dollar