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

1350/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

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


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


Trainers