• My account
  • Cart
English courses / USD

Microsoft Access 2010

Regular Price: $258

Special Price: $65

  • 2 students have purchased
  • Express
My Training Academy
Potters Bar
Maple House High Street, Potters Bar Hertfordshire United Kingdom, EN6 5BS EN6 5BS See in Google maps
OUR MISSION: Our mission is to help you learn the skills you need to reach your full potential. WHO WE ARE: We are one of the fastest growing online training providers. We offer engaging, effective and flexible online training solutions to both individuals and businesses. We develop courses that help individuals to prepare for and complete their certification exams with ease. Our unique, flexible approach to learning means you don’t have to put your life on hold to get certified. You can study full time and part time, from home and work and on the move; online and on mobile devices. We provide world class education developed by highly skilled and experienced instructors. Our courses are upgraded regularly to ensure our learners are up-to-date with the latest industry requirements and best practices. WHAT WE BELIEVE We believe technology has paved the way for individuals and businesses all over the world to tap into high quality learning at their fingertips.


  • Advanced online learning platform
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.


In order to succeed in today's business world, you must have competent skills in Microsoft Office. Whether you're an administrative assistant, office manager, sales professional or business manager, utilising all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. Almost every job in the business world involves office products. Take your skills to the next level and make your current job easier to manage by completing our Microsoft Access 2010 course.

The Microsoft Access 2010 course has been designed to provide you with the essential skills you will need to be proficient in Access 2010, in a work or home environment, in as short a time as possible. You don't need any prior experience of Microsoft Access, but you will need to be familiar with using a computer and the Windows environment.

The great thing about our Microsoft Access 2010 course is that you are in charge of your start and finish date, with no deadline pressures!

We train our students to the very best standards, offering expert instructor-led training via our state of the art eLearning platform.

By achieving the Microsoft Office Specialist certification, you will create more career opportunities and be better positioned when applying for work.

Enrol today and prepare for a future you deserve.WHY STUDY WITH MY TRAINING ACADEMY?

Flexible training- study anytime, anywhere and from any device.
Expert Instructor-Led Training Ð our courses are delivered by the finest instructors with a minimum of 15 years real-world experience and are subject matter experts in their field, which is why we have a 97.4% pass rate.
Visual Demonstrations & Multimedia PresentationsÐ allows students to develop their skills based on real world scenarios explained by the instructor.
Quizzes & Exam SimulatorsÐ custom practice exams to prepare students for their final exams. We offer practice quizzes after each module to ensure students are...

Course Introduction
Instructor Introduction
Access Overview
Course OutlineSection 1: Access Basics
Section Overview
What Does Access Do?
Access Application Window
Database Objects
Basic Database and Table Management
Customizing Access
Keyboard Shortcuts
Section ReviewSection 2: Designing a Database
Section Overview
Database Design Process
Normalizing Data
Setting Primary and Foreign Keys
Section ReviewSection 3: Building a Database
Section Overview
Creating A New Database
Creating Tables
Inserting Field's in Tables
Setting Up Field Properties
Formatting the Datasheet View
Creating Relationships
Keyboard Shortcuts
Section ReviewSection 4: Managing Table Data
Section Overview
Updating and Deleting Records
Finding and Replacing Values
Adding a Total Row
Using Sub-datasheets
Sorting Data
Filtering Data
Keyboard Shortcuts
Section ReviewSection 5: Creating Selection Queries
Section Overview
Creating Queries Using the Query Wizard
Creating Queries Using the Query Design View
Adding Criteria
Add Calculated Fields to Query
Section ReviewSection 6: Creating and Managing Forms
Section Overview
Form Basics and Creating Forms
Contextual Tabs Design and Layout View
Managing Table Data with Forms
Modifying the Look and Design
Design Tab Controls
Section ReviewSection 7: Creating and Managing Reports
Section Overview
Creating Reports, Report Views, and Managing Report Sections
Adding Calculated Fields and Formatting the Report Controls
Section ReviewSection 8: Controlling Data Entry
Section Overview
Setting Field Properties
Validation Rules
Input Mask
Create Lookup Field
Section ReviewSection 9: Finding and Joining Data
Section Overview
Inner and Outer Joins
Joining Unrelated Tables and Relating Data Within Tables
Section ReviewSection 10: Creating Flexible Queries
Section Overview
Select Query Properties
Parameter Queries
Using Wild Cards
Creating Action Queries
Section ReviewSection 11: Enhancing Forms
Section Overview
Using the Form Layout View and Improving Form Appearance
Restricting Data Entry
Command Buttons and Creating Sub forms
Section ReviewSection 12: Customizing Reports
Section Overview
Organizing Report Information and Setting Report Control Properties
Page Layout and Controlling Pagination
Summarize Info and Sub-reports
Mailing Labels
Section ReviewSection 13: Sharing Access Data
Section Overview
Importing and Exporting Data
Sharing Data and Merging Data with Word
Section ReviewSection 14: Structuring Existing Data
Section Overview
Analyzing Tables and Junction Tables
Improving Table Structure
Section ReviewSection 15: Writing Table Queries
Section Overview
Multi Table Query
Creating Unmatched Queries
Create Duplicate Queries
Create Duplicate Queries and Grouping and Summarizing
Crosstab Query
Creating Pivot tables and Pivot Charts
Section ReviewSection 16: Using Macros
Section Overview
Planning and Creating Macros
Attach Macros to Command Buttons
Restrict Records Displayed Using Where Condition
Require Data Entry with Macros
Automate Data Entry
Section ReviewSection 17: Making Forms More Effective
Section Overview
Form Format Properties
Active X Controls and Tabbed Pages
Display Pivot Chart Table on Forms
Section ReviewSection 18: Improving Reports
Section Overview
Include Chart in Report and Concatenating
Arranging Data in Columns, Grouping, and Parameter Reports
Report Events and Cancelling a Blank Report from Printing
Section ReviewSection 19: Creating a Start-up Interface
Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Start-up Options
Section ReviewSection 20: Database Maintenance
Section Overview
Database Maintenance Tools
Section ReviewSection 21: Distributing and Securing a Database
Section Overview
Splitting a Database
Implementing Security and Trust centre
Setting Passwords
Converting Files and Signing with Digital Signatures
Section ReviewCourse ReviewMULTI-USER TRAINING PACKAGESThis online course can be integrated in your professional training plan. M.T.A. can provide you with a tailored learning solution, that can be customised to meet each team member's requirements. Choosing a multi-user training package, you can get significant discounts for 5+ users and even further discounts for 10+ users Ð and an excellent return on your investment.


Thanks to this offer, valid exclusively for one person, you will obtain a Microsoft Access 2010 Online Course.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to info@mytrainingacademy.org.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to USD.
You can change to other currency by using the option on the header.