HOME
 

Microsoft Access Level 2 - Online

Insight IT Training
Course summary
6 hours
English
Flexible
Professional Training
Next available date: Choose a date and time to suit your staff. - Online courses
Course Dates
London
Choose a date and time to suit your staff.  (English)
United Kingdom
Choose a date and time to suit your staff.  (English)
Online courses
Choose a date and time to suit your staff.  (English)

Course description

*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer will be able to see you and your screen. All secure and private. No videos, animations or modules to complete online. This is proper hands-on instructor led training for your staff. Just like in a classroom, plus, all the benefits of private training.  A Remote solution for effective Virtual training, delivered using either Microsoft Teams or Zoom, which are both free to download. Online IT training can be 1-to-1 or for a group of up to 6 people, plus a Per Hour option.

Benefits of Microsoft Access Level 2 Course

This Access Level 2 course is designed for those who wish to gain intermediate-level skills, or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Microsoft Access with other programs.

During this one day course, participants will learn how to design a relational database, explore table relationships and organising a database. It also covers sharing data and advanced reporting. Our Microsoft Access Level 2 course takes you from beginner level to more advanced topics and therefore prepares you for our Access Level 3 course. Our trainers are highly skilled with many years’ experience with the Microsoft suite of products.

So if you’re in the business of managing data, then our Microsoft Access Level 2 course will give you the power to handle the creation, manipulation and analysis of your organisation’s data. Please take a look through our course details for more information.

Suitability - Who should attend?

To ensure your success on this Level 2 course you would have completed the Microsoft Access Level 1.

Outcome / Qualification etc.

Each trainee will receive a Certificate of Attendance, signed by the trainer. You will also receive copies of the Evaluation Forms completed by the trainee(s) for your records.

Training Course Content

Course Content

Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Advanced Reporting

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Why choose Insight IT Training

Founded in 1998 and trained staff at more than 2,840 companies throughout the UK.

Rated excellent by more than 90% of customers and more than 60% repeat purchases.

17 specialist trainers for IT and Business Skills training, each with more than seven years of corporate training experience.

Expenses

All the prices quoted are a total fixed cost and are the same for any location in the UK. Each person will receive a Certificate of Attendance, free ongoing post training support (if needed), and a comprehensive and user-friendly reference manual in pdf format.

Continuing Studies

Insight IT Training delivers standard Access courses at Introductory, Intermediate, Advanced and VBA levels, either Online, in-house or on-site at your office.

These courses can also be tailored - in content, format and duration - to meet your exact needs.

Get Inspired! Watch the Video

About provider

Insight IT Training Logo

Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company

*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Access Level 2 - Online.

  Contact the provider

  Get more information

  Register your interest

Contact info

Insight IT Training

Insight IT Training Limited
Hamilton House, Mabledon Place
WWC1H 9BB London London

 Show phone number
www.insighta.co.uk

Request information

Find out more about this Microsoft Access Level 2 - Online course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here