Welcome to Insight

Delivering private IT training for businesses,
public sector and voluntary organisations

We deliver our training
Onsite & Offsite

We Provide
A Wide Range
of Business Skills courses

We Can Help You
Build Your Own
Tailored Courses

The Training You Want
When & Where
You Want It

Keep an Eye on
Our Special Offers
Updated Regularly

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Access Level 2

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

Access

Course Duration – One day

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.

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

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

Prerequisites

Microsoft Access Level 1

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 08452 306 099 or contact us online here.