Database Management with Microsoft Access (CEF Approved)

CEF Course Code: 25C03920-A
CEF Institution Code: 548

Course Description
Application Procedure
Schedules/Enrol

Continuing Education Fund
The course has been included in the list of reimbursable CEF courses
CEF Courses Home

Course Objective

Microsoft Access is an ideal and cost-effective database management solution for small-to-medium businesses (SMEs). Building an effective database system is not necessarily the job of professional programmers. Proficient users of Microsoft Access are able to do the job without much difficulty. This course starts with the basic features of Microsoft Access and progresses gradually to useful advanced concepts and functions of the software including advanced forms, queries and reports. Participating in this course requires no prior knowledge of Microsoft Access. On course completion, you will be able to create a functional database from scratch, use a multitude of Microsoft Access features, and efficiently maintain a database.

Course Duration

30 Hours

Course Prerequisites

Course applicants should be at least 18 years old, with an education level of Form 5 or above and a working knowledge of Microsoft Windows. Previous knowledge of Microsoft Access is not required.

Course Content

The programme consists of the following 2 modules:

The course consists of the following 2 modules. Microsoft Access 2010 will be used for hands-on practice.

I. Database Management with Microsoft Access

  • Introduction
  • Introducing Microsoft Access
  • Tables
  • Relationships in a Database
  • Queries
  • Forms
  • Form Properties
  • Reports
  • Data Access Page
  • Macros
  • Restricting User Input
  • Advanced Queries
  • Subforms
  • Advanced Reports
  • Macro Groups and Conditional Macros
  • Database Security

II. Inventory Management with Microsoft Access

  • Creating Tables
  • Recording Sources of Goods
  • Recording Purchases
  • Recording Sales
  • Basic Queries
  • Basic Reports
  • Printing Purchase Orders and Sales Orders
  • Printing Customer Monthly Statements
  • Goods Forms
  • Sales Orders Forms
  • Customers Forms
  • Suppliers Forms
  • Action Buttons and Program Codes
  • Final Enhancements

Title of Award and Assessment Methods

Students are required to submit at the end of the course a database system created with Microsoft Access. The project will be assessed according to database design and functionality. Upon successful completion of the course, students will receive the course certificate.

Course Fee

$5,850 ($1,170 for eligible applicants after maximum 80% course fee reimbursement from CEF upon successful completion of the course)

Course Delivery Language

Cantonese-taught and English-taught courses are available. Course material in Chinese or English is provided accordingly.

Schedules/Enrol

Evening or Saturday full-day classes, 6 hours per week, course fee in 2 instalments
Course Title Duration Fee Outline/Schedules/Enrol
Database Management with Microsoft Access (CEF Approved) 30 hours $2925 Outline Schedules/Enrol
$2925 x 2 monthly instalments (total $5850, $1170 after 80% CEF reimbursement), 30 hours in 10 sessions, 2 sessions per week)

Application Procedure

  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.

  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.

  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

© Welkin Systems Limited. All rights reserved.