Skip to content

MS Access Introduction Training | Live Online or Onsite

    MS Access Introduction Training

    Our Introduction to Microsoft Access training course will teach you the fundamentals of this popular database programme. The course focuses on the basic principles of creating and using tables, queries, forms and reports.


    Course Summary

    This course focuses on the following aspects of Microsoft Access:

    • Navigating the Microsoft Access interface
    • Creating and saving an Access database
    • Creating tables and effectively storing data in tables
    • Creating select queries to interrogate your data
    • Creating forms to improve the user interface of an Access database
    • Creating professional looking reports from the data held in your database
    • Exporting and importing data

    Course Prerequisites

    No previous experience of Microsoft Access is required to attend this course.


    What’s Included with the Training?

    • Delegates will receive a comprehensive pdf reference guide that covers the content of the course.
    • Delegates will have created a working database at the end of the course which they can refer to alongside the reference guide.
    • Course certificate, if required

    Course Outline

    Our training courses can be delivered onsite at your offices or remotely online. Please note the outline can be tailored – nothing is set in stone! Please download the course outline in pdf format here.

    Navigation
    • Navigate Using the Navigation Pane
    • Document Window Options
      • Overlapping Windows
      • Tabbed Documents
    Tables
    • Create and Save a New Table
    • Enter Field names
    • Specify Data Types
    • Use the Lookup Wizard
    • Enter Records in a Table
    • Sort Data in a Table
    • Filter Data in a Table
    • Freeze Fields
    • Hide Fields
    Select Queries
    • Create and Save Select Queries
    • Add Fields to a Query
    • Add Criteria to a Query
      • And Criteria
      • Or Criteria
      • Between And Criteria
    Forms
    • Create and Save a Basic Form
    • Add Fields to a Form
    • Create a Split Form
    • Create a Navigation Form
    • Use the Form Wizard
    • Understanding Form Views
    • Apply Formatting to a Form
    Reports
    • Create and Save a Basic Report
    • Use the Report Wizard to Create a Report
      • Apply Grouping
      • Sort Data in a Report
    • Understanding Report Views
    • Adjust Column Widths
    • Rearrange Columns
    • Page Setup Settings – margins, orientation and page size
    • Padding and Margins
    • Add a Logo to Your Report
    • Add Page Numbers to Your Report
    Importing & Exporting
    • Import Text and Excel Files into Your Database
    • Export from Access to Excel and Word.