Project Description


CEF Course Code: 25C03920-A
CEF Institution Code: 548
Welkin Course Codes: CIMA, CIMB

Course Features

Microsoft Access offers more sophisticated data management capabilities than a spreadsheet program. This course starts with the basic features of Microsoft Access and proceeds step-by-step to useful advanced concepts and functions of the software including advanced forms, queries and reports. In the course you will create a functional database as a project assignment.

  • Covering tables, relationships, forms, queries and reports
  • Practical, hands-on approach with no programming involved
  • Suitable for learners with little or no experience in Microsoft Access
By the end of the course you should have acquired the necessary skills and techniques to work with Microsoft Access and be able to create and manage an Access database on your own.
  • Qualified and experience instructor
  • Easy to follow, step-by-step instruction
  • Evening or weekend classes with Cantonese and English tuition options

Learn from the Experts

Get Professional Recognition

Students are encouraged to take the certification to learn and establish a professional position in study and employment. This course has been included in the “Learn & Certified” program, students will promote to take a MOS Access (77-730) Exam within one year, free of charge! The plan allows you to have enough time and resources to learn, to combat, to test and to prove your professional qualifications! You can learn what you have learned and got the professional qualifications of MOS Access (77-730) to add to your learning outcomes!

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Access with the course Microsoft Access Programming.

Course Fee


*after maximum 80% fee reimbursement from CEF. Full course fee is $6450.

This course has been included in the list of reimbursable courses under Continuing Education Fund
The Office of the Continuing Education Fund does not have record of registration of this course under the Qualifications Framework

Am I qualified for CEF?

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.

Title of Award & 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.

Schedule & Online Enrolment

You will pay the course fee ($6,450) by default option. If you choose to pay by monthly installment, please use “Pay when visit Welkin” while checkout. CEF reimburse application (if any) will proceed once the course completed.
Sign up for your course by clicking the “Enrol” button, then proceed to checkout to finish course registration.

Database Management with Microsoft Access (Code: 25C03920-A)
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Course Fee 全期學費Enrol 報名

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 an Access database.

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
  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, Units 07-11, 25/F., CDW Building, 388 Castle Peak Road, Tsuen Wan, New Territories. Together with a photocopy of their HKID Card before course commencement. Applicants may also place their applications in the drop-in box on 12/F., Cheung Sha Wan Government Offices.

You may also be interested in