Microsoft Access 2016

Regular price £24.99 GBP
Regular price Sale £162.50 GBP Sale price £24.99 GBP
Course bookings are subject to VAT in the UK and some other countries. If VAT is applicable in your country, it will be added at checkout.
1). Choose course date and other options (if applicable)
2). Add delegate names to the form below
3). Choose number of delegates and 'Add to Cart'
4). At checkout choose to pay by invoice later, debit/credit card or by Clearpay*

Share this course with friends and followers on social media.

Customer Reviews

Be the first to write a review
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

What is Microsoft Access 2016?

This online 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.

Who is the Microsoft Access 2016 Course Suitable For

This online Microsoft Access 2016 course is suitable for anyone looking to develop their Microsoft Access skills. It is also suitable 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.

What's Included in the Microsoft Access 2016 Course?

Awarding Body

MTA

Course Duration

6 Hours

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.

12 Months Unlimited Access

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

Course Content

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
  • Customising Access
  • Keyboard Shortcuts
  • Section Review

Section 2: Designing a Database

  • Section Overview
  • Database Design Process
  • Normalising 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 Data sheet 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-data sheets
  • 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: Customising Reports

  • Section Overview
  • Organising Report Information and Setting Report Control Properties
  • Page Layout and Controlling Pagination
  • Summarise 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
  • Analysing 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 Summarising
  • Cross-tab 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

    Assessment / Exam

    There is no formal assessment on this course.

    Prerequisites

    Microsoft Access 2016 installed on your device.

    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.

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

    Related Content

    For short courses upon successful completion you will be awarded a personalised certificate of completion.

    For accredited courses a certificate will be sent directly to you from the appropriate awarding body.

    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.

    The TOTUM PRO card is aimed at professional learners, giving you access to exclusive discounts.

    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 e-learning 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.

    E-learning is flexible, efficient, and cost-effective, meaning you can progress through the modules at your own pace, at your own time to fit the training in around your work and personal life.

    Short online courses also help employers to demonstrate that they have fulfilled their legal duties to ensure their personnel have been adequately trained.

    Once the courses have been completed, a confirmation of results can be saved or printed as evidence. This can then be kept on record as evidence of suitable training.

    You will instantly receive a confirmation email with your order details and your course login details will follow within one business working day.

    Please note that course bookings can not be processed outside of normal working hours, over weekends or on bank holidays and will be processed the next business working day.

    Step 1

    Click the 'Buy' or 'Add to cart' button and you will be taken to our payment/booking page where you can choose to pay online now using a debit/credit card or you can pay later by invoice.

    Step 2

    Once you have paid for your course(s), you will receive an email from our team advising how to begin your training.

    Step 3

    You will be provided with a username and password which will enable you to access the e-learning portal. Login to start your course, once you have completed and passed the course, you will be able to download and print your certificate straight away.

    Our mission is to help you learn the skills you need to reach your full potential.

    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.

    Envico is working in partnership with My Training Academy offering e-learning and is not accredited by or associated with any examination bodies, awarding bodies, institutions or organisations in any way whatsoever.