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 1

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

Access

Course Duration – One day

Benefits of Microsoft Access Level 1 Course

This Level 1 course is designed for people who wish to establish a basic understanding of Microsoft Access, including the skills necessary to create a new database, construct data tables, design forms and reports and create queries.

Microsoft Access is a tool to manage information. It can help you to overcome restrictions you may find when you try to manage large amounts of information in Excel or other spreadsheets. Microsoft Access Level 1 training from Insight IT, allows you to take control of your data. Our course will teach you the basic features of Access. By the end of the Level 1 course, you will understand working with table data, queries, generating reports and more besides!

No matter what version of Microsoft Access you use, from Access 2003, MS Access 2007 through to later versions including Access 2010 - we can help you.

Before attending this Microsoft Access Level 1 course, you should be familiar with using personal computers, and should have experience using a keyboard and mouse. You should be comfortable in the Windows environment, and be able to use Windows to manage information on your computer. Specific tasks you should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Course Content

Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

Working with Table Data

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

Querying a Database

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Creating Advanced Queries

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data

Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Customizing the Access Environment

  • The Access Options Dialog Box

Prerequisites

You should be familiar with using personal computers, and should have experience using a keyboard and mouse. You should be comfortable in the Windows environment, and be able to use Windows to manage information on their computers. Specific tasks you should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders. 

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.