Microsoft Access 2013 Intermediate

Quorse - Your Training Wholesaler

  • Enjoy discounts up to 60% off!
  • Chat with us Live to get a Quotation to see it for yourself!
  • All courses are HDRF Claimable

Private Class from


(2 Days)


Upon completion of this program, participants should be able to:

  • Mark Fields as Required in a Table
  • Use Input Masks to control Table data entry
  • Create and Use Subforms
  • Add Tabs to a Navigation Form
  • Set a Tab Hierarchy
  • Create Parameter Queries
  • Create Action Queries
  • Make Table, Append, Delete & Update Queries
  • Understand Basic SQL Statements and Keywords
  • Create a Report with the Wizard
  • Create a Report from Scratch
  • Group and Sort Form Data
  • Insert Images, Logos, Headers and Footers


This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know, understand and want to further enhance their knowledge and practical uses of Microsoft Access



Basic knowledge of Microsoft Access is essential with the following pre-requisites:

  • Have attended Microsoft Access – Foundation Level; OR
  • Able to switch between task applications
  • Understand basic Access terminology
  • Able to create a database
  • Able to create a Table
  • Add and Edit Records
  • Able to create a Form with the Wizard


This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Advanced Table Tasks
  • Inserting Application Parts
  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages

Managing Data Entry In Tables
  • Marking Fields as Required
  • Marking a Field for Indexing
  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks

Creating Subforms
  • Creating Subforms
  • Using Subforms
  • Linking Subforms with Parent Forms
  • Formatting a Subform within a Main Form

Creating Navigation Forms
  • Creating a Navigation Form
  • Adding Tabs to a Navigation Form
  • Creating a Tab Hierarchy
  • Displaying the Navigation Form when the Database Opens

Creating Advanced Queries
  • Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  • Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

Advanced Query Tasks
  • Understanding SQL Statements
  • Basic SQL Keywords
  • Creating SQL Queries
  • Using the Expression Builder

Creating Reports
  • Creating a Report from an Object
  • Creating a Report with the Wizard
  • Creating a Report from Scratch
  • Understanding Report Views
  • Printing Reports

Formatting Reports
  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers