Upgrade your skills with an extra 25% off selected courses with codeMTA25
MOS00333

Microsoft Access 2016 Course

29.9900 2023-12-30 MOS00333 29.9900
104 104 104 0 The Microsoft Access 2016 course has been designed to provide you with the essential skills you will need to be proficient in Access 2016, in a work or home environment, in as short a time as possible https://mytrainingacademy.org.uk/pub/media/catalog/product/1/_/1_1_6.jpg
  • Price

    £29.99 including VAT (was £195.00)

    Offer ends 31 March 2024

    Save £165.01
  • Course Type Online Course
  • Course Duration 6 Hours
  • Course Access 12 Months
  • Awarded By MTA
  • Student Discount Card All students enrolled on this course are eligible to apply for a TOTUM Pro card
Share
MOS00333
The Microsoft Access 2016 course has been designed to provide you with the essential skills you will need to be proficient in Access 2016, in a work or home environment, in as short a time as possible
-
+
Course Description

This Microsoft Access 2016 course has been designed to provide you or your team with the essential skills required to use Microsoft Access effectively.

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.

Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment sectors.

Depending upon the version of Access you need, we have the perfect course for you; including the most up to date version, Microsoft Access 2019 as well as 2016, 2013 and 2010.

What's included in this Microsoft access 2016 course?

  • 12 months unlimited access.
  • Online video tutorials created by expert instructors.
  • Project files to help you consolidate your learning.
  • MTA course completion certificate.

Course Duration

The online Microsoft Access 2016 course requires 6 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.

Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.

Course Format

  • This is a video-led course. 
  • This course includes project files so you can practice while you learn.
  • There is no formal assessment on this course.

Entry Requirements

This course is designed to provide you with the essential skills you will need to be proficient in Access, in a work or home environment, in as short a time as possible. You don't need any prior experience of using Microsoft Access, our Microsoft Access 2016 training covers beginners and advanced level training to help you develop the skills you need to progress in your career.

For anyone who manages their Microsoft Access training, this MS training can be used for on-boarding new staff, or as part of a team training plan.

Bulk discounts

Bulk discounts are available on purchases of 10 or more courses.

If you wish to discuss a large individual order for this course, and/or would like to be invoiced in advance, please call our sales team on 0808 175 1269 to make an enquiry.

More Microsoft Access training:

Microsoft Access 2010Microsoft Access 2013Microsoft Office Training Bundle

Who is this course for?

Anyone looking to develop their Microsoft Access skills.

By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Course Assessment Process

There is no formal assessment on this course.

Project files are included in each course to help you consolidate your learning. At the end of each course, please get in contact with Student Support to request a copy of your certificate of completion.

Got a question about exams? Contact our course advisors by email or by phone on 0808 175 1269. We're happy to help!

Requirements

Microsoft Access 2016 installed on your device. 

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Course Media
Career Path

We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):

  • Office Administrator
  • Business Administrator
  • Personal Assistant, Clerical Assistant
  • Receptionist
  • Secretary
  • Customer Service Representative
  • Project Officer, Project Manager
  • Business Manager
  • Sales Executive, Sales Manager, Sales Director
  • Human Resource Officer
  • Finance Assistant. Book-keeper, Accountant
  • Healthcare Assistant, Nurse
  • Database Administrator

Career Advice

Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including:

  • How to put together a killer CV, Covering Letters and Thank You emails.
  • How to gain relevant work experience.
  • Howto prepare for interviews.
  • How to understand Job adverts.
  • How to choose the right recruitment agency.
  • How to look for work on LinkedIn.
  • Information on dealing with redundancy.

Our careers advice section is available for you to see now.For more information about our career advice services, contact us on 0808 175 1269 to speak with one of our friendly course advisors today.

Course Outline

Course Syllabus

Course Introduction
  • Instructor Introduction
  • Access Overview
  • Course Outline
Section 1: Access Basics
  • Section Overview
  • What Does Access Do?
  • Access Application Window
  • Database Objects
  • Basic Database and Table Management
  • Customizing Access
  • Keyboard Shortcuts
  • Section Review
Section 2: Designing a Database
  • Section Overview
  • Database Design Process
  • Normalizing Data
  • Setting Primary and Foreign Keys
  • Section Review
Section 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 Review
Section 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 Review
Section 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 Review
Section 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 Review
Section 7: Creating and Managing Reports
  • Section Overview
  • Creating Reports, Report Views, and Managing Report Sections
  • Adding Calculated Fields and Formatting The Report Controls
  • Section Review
Section 8: Controlling Data Entry
  • Section Overview
  • Setting Field Properties
  • Validation Rules
  • Input Mask
  • Create Lookup Field
  • Section Review
Section 9: Finding and Joining Data
  • Section Overview
  • Inner and Outer Joins
  • Joining Unrelated Tables and Relating Data Within Tables
  • Section Review
Section 10: Creating Flexible Queries
  • Section Overview
  • Select Query Properties
  • Parameter Queries
  • Using Wild Cards
  • Creating Action Queries
  • Section Review
Section 11: Enhancing Forms
  • Section Overview
  • Using the Form Layout View and Improving Form Appearance
  • Restricting Data Entry
  • Command Buttons and Creating Sub forms
  • Section Review
Section 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 Review
Section 13: Sharing Access Data
  • Section Overview
  • Importing and Exporting Data
  • Sharing Data and Merging Data with Word
  • Section Review
Section 14: Structuring Existing Data
  • Section Overview
  • Analyzing Tables and Junction Tables
  • Improving Table Structure
  • Section Review
Section 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 Review
Section 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 Review
Section 17: Making Forms More Effective
  • Section Overview
  • Form Format Properties
  • Active X Controls and Tabbed Pages
  • Display Pivot Chart Table on Forms
  • Section Review
Section 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 Review
Section 19: Creating a Start-up Interface
  • Section Overview
  • Creating and Modifying a DB Switchboard
  • Setting and Modifying Start-up Options
  • Section Review
Section 20: Database Maintenance
  • Section Overview
  • Database Maintenance Tools
  • Section Review
Section 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 Review
Course Review
Training Features
  • feature
    EXPERT INSTRUCTOR-LED TRAINING

    We only use the industry’s finest instructors to develop our courses. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

     
     
  • feature
    NAVIGATION & CONTROLS

    Our self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.

     
     
     
  • feature
    12 MONTHS UNLIMITED ACCESS

    Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7.

     
Payment Options

For purchases of 1 to 9 user enrolments select the number of users you require and add the course to your shopping basket by selecting Add to Basket. You will then be able to make payment using most credit and debit cards or a PayPal account. Once payment is confirmed, we’ll process your order and email your course login instructions.

For a licence for 10 or more user enrolments, discounts, or if you would like to pay by BACs transfer or by invoice, please contact us on 0808 175 1269 or email sales@mytrainingacademy.org.uk.

Purchase Order Payments: To pay and enrol for courses using a purchase order (PO), please email your PO details to sales@mytrainingacademy.org.uk.

TOTUM PRO Card

All students enrolled on this course are eligible to apply for a TOTUM PRO Card, which offers discounts in a wide range of shops and websites, helping you get money off food, holidays and flights, clothes, make-up gym memberships and much more.

TOTUM PRO card is aimed at professional learners, giving you access to exclusive discounts. Explore the full list of offers.

Student Reviews

We make it our absolute mission to give you the training you need and the service you deserve. Hear what our students say about us...

£195.00 £29.99

Save £165.01

Was £195.00 (Offer ends 31/03/2024)
Microsoft Access 2016 Course
-
+
 
Enquire now

Speak to an advisor

+44 (0)808 175 1269

This is a local rate number

klarna

Spread the cost

Interest-free instalments

Read more...

14-Day money-back guarantee

Buying for your team?


Enquire now

Privacy
Protected

Secure
Checkout

We're trusted by
Individuals, small businesses and large corporations who continuously put their trust in My Training Academy.
We are privileged to have trained individuals who work for some of the world’s largest companies, including: