Microsoft Access 2013 Intermediate
Private Class From
RM1100
/day
(1 Days)
COURSE OBJECTIVES

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
  • Create a Report with the Wizard
  • Create a Report from Scratch
AUDIENCE

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

PREREQUISITES

REQUIRED PREREQUISITES:

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

METHODOLOGY

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

  • Marking Fields as Required
  • Marking a Field for Indexing
  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks


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


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


  • 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


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