Customer Service

from RM1500

OHSA

from RM1500

Supply Chain Mgmt

from RM1400

Warehouse & Logistics

from RM1500

Fraud & Risk Mgmt

from RM1500

Account Principles & Practices

from RM1500

Microsoft Access 2013 Intermediate

Chat to get a Free Quotation

  • Private Class Price is Per Day not Per Pax
  • Send 1 or 20 pax for the same price
  • HDRF Claimable(SBL)

Private Class from

1350/day

(2 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
  • 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

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

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


Trainers