MS Access 2007 (Basic – Intermediate) (MDA119)

06 March 2017 - 07 March 2017

Module A: Getting Started
• Getting Started in MS Access Environment
• Convert Access File from Older Version
• Access Interfaces
• Data Entries to a Database
• Add Data with Form & Subform
• Filter Records in Datasheet View

Module B: Working with Tables and Relationship
• Working with Tables
• Create and Design a Table
• Link and Import Tables
• Table Relationships
• Create a Relationship between two Tables

Module C: Queries
• Introduction in Queries
• Create a Query In Design View
• Create an Arithmetic Calculation within a Query
• Create a Parameter Query
• Query Review Exercises

Module D: Forms & Reports
• Working with Forms
• Create a Form
• Add Labels and Fields to a Form
• Add a logo Picture to a Form
• Add a Picture from a record to a Form
• Create Main Form / Subform
• Create a Combo List
• Change the Tab Order
• Set Default Value for a Control in a Form
• Set Validation Rule and Validation Text Properties
• Create a Report
• Create a Grouped Report

Module E: Switch Board & Case Studies
• Create Switchboard for User Interface

2 days

Program 100% Claimable Under SBL Scheme
PSDC Members: RM 680/pax
Non-Members: RM 730/pax
All prices listed above are excluding GST.

6 - 7 March 2017
6 - 7 December 2017