Mastering MS Access: Intermediate Level

MS Access is a computerised database management system which stores, retrieves, analyses, and prints information. It is a system for managing large amount of data. Companies use database for many purposes: to manage customer files and also to track orders and inventories. Individuals might set up databases to track household expenses or manage lists of family, friends, and business addresses.

Course Contents:

• Working in an Existing Application
• Importing and Exporting Information From/To Other Applications
• Ensuring the Accuracy of a Database through Data Restriction
• Creating a Switchboard, a Splash Screen and Setting Startup Options
• Ensuring the Security of the Information in Your Systems
• Creating Queries that Combines Operators, Functions and Field Names with Literal Values

Date: 20/11/2008 (Thu)
Time: 9:00am-5:00pm
Venue: KTAR Learning Centre (Wisma MCA)
Fee: RM 200
Instructor: Tan Li Peng, Lecture from TARC
Enquiry/Registration: Ms Lin 03-4149 9164

** Fee covers course materials, refreshments and Certificate of Attendance
* Closing date for registration is one week before the respective workshop

Mastering MS Access: Advanced Level

Course Objectives:
This one day workshop designed to equip participants with more complex skills to undertake responsibilities, which might include creating and or enhancing the design of tables, queries, forms and reports.

Course Contents:

• Creating Advanced Queries and PivotTable Queries
• Querying with SQL Statements
• Making Form More User-Friendly with Label, Text Box, Lists and Combo Boxes, Check Boxes, Option Buttons, Scrollbar, Calendar, Tab Control and Command Buttons
• Creating a Subform, Dialog Box, PivotChat Form
• Customizing Your Report by Organizing Report Information and Enhancing Data Layout
• Making Reports More Powerful through Sorting and Grouping, Adding Calculations to a Report, Create a mail Merge Report, Create a PivotChart Report and Launching a Report

Date: 31/7/2008 (Thu)
Time: 9:00am-5:00pm
Venue: KTAR Learning Centre (Wisma MCA)
Fee: RM 200
Instructor: Tan Li Peng, Lecture from KTAR
Enquiry/Registration: 03-4145 0123 (Mr Lee ext 373, Ms Lin ext 515)

** Fee covers course materials, refreshments and Certificate of Attendance
* Closing date for registration is one week before the respective workshop