Courses for Access from Activia

Microsoft Access Intermediate

A 1-Day Training Course

Course Content

Course Aims

This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts for Access in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of MS Access 2007, 2010, 2013 or 2016 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Course Outline
This course is a 1-day training course structured into 5 modules.
Module 1
Advanced File Tasks
Learning outcomes
A look at some important administrative features necessary for managing an Access Database file.
Topics covered
  • Using Windows Explorer within Access
  • Database Management
  • Saving Your Files
  • Exporting Files
  • Linking Files
  • Module 2
    Working with Tables
    Learning outcomes
    Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.
    Topics covered
  • Customising Tables
  • Table Properties: Formatting
  • More Table Properties
  • Data Validation and Lookup Wizard
  • Module 3
    Working with Forms
    Learning outcomes
    Building professional forms to enhance the user experience and improve effective use.
    Topics covered
  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
  • Formatting Controls
  • Using Themes
  • Module 4
    Working with Reports
    Learning outcomes
    Organise and format your reports professionally and common report tasks you may need to perform.
    Topics covered
  • Organizing Report Data
  • Formatting Reports
  • Common Report Tasks
  • Module 5
    Working with Queries
    Learning outcomes
    Creating a range of different queries from very basic queries through to management queries with advanced functionality.
    Topics covered
  • Basic Queries
  • Doing More with Queries
  • Creating Advanced Queries
  • Creating Management (Action) Queries

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