Important COVID-19 Notice
We have postponed all classroom
training until further notice.
Instead we are offering online IT Training.
CLICK TO FIND OUT MORE

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: +44 (0) 8452 306 099. Alternatively contact us online here.