Training in Access from Activia

Microsoft Access Introduction

A 1-Day Training Course

Course Content

Course Aims

This intensive one-day training course is designed to enable users to get to grips with the main features of Access, including a thorough treatment of the new 'Ribbon' interface. It is entirely 'hands on', so delegates will get practice in using the software in a realistic and practical way.

Who Should Attend

The course is intended for new users of MS Access 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Windows operating system, but no prior experience with Access is required.

Course Outline
This course is a 1-day training course structured into 4 modules.
Module 1
Getting Started with Access
Learning outcomes
Understand how to start Microsoft Access and some of its basic navigation and help controls.
Topics covered
  • Starting Out
  • Interface Basics
  • Database Security
  • Getting Help
  • Module 2
    The New Ribbon Interface
    Learning outcomes
    Exploring the Ribbon's different tabs and options.
    Topics covered
  • The Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab
  • Module 3
    Creating a Simple Database
    Learning outcomes
    Creating basic tables and a look at the different types of fields available.
    Topics covered
  • First Steps in Database Creation
  • Database Records
  • Creating a Table
  • Formatting Text
  • Module 4
    Forms; Queries; Reports and Filters
    Learning outcomes
    Creating basic forms, queries, reports and filters; essential to the successful creation and administration of an Access Database.
    Topics covered
  • Creating and Using Forms
  • Creating and Using Queries
  • Creating and Using Reports
  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object

  • Activia Training :   Training courses for business at twelve locations UK wide