Project Description
CEF 課程編號: 25C03920-A
CEF 院校編號: 548
天行課程編號: CIMA, CIMB
課程特點
使用 Microsoft Access 建立資料庫系統在中小型企業中極為普遍。庫存系統是在資料庫中加入存銷貨管理的功能，而使用 Microsoft Access 作為工具是符合中小企業以成本效益為目標的理想方案。建立一個有效的庫存系統再不限於是專業程式員的工作，只要將 Microsoft Access 的功能運用得宜，自行建立一個實用的系統並不困難。本課程會由教授 Microsoft Access 基本功能開始，然後循序漸進指導學員如何建立一個實用的庫存系統。
學習專家的做法
考取專業認證
認證你的 Microsoft Access 技能，考取 Microsoft Office Specialist (MOS) 官方認證。留意此認證並不是完成此課程的必需要求，但我們高度建議學員在完成本課程後，考取此專業認證，為你的技能作出專業的肯定。
(註) 考試費用並不包括在課程費用之內
相關延伸課程
完成此課程的學員可以考慮學習更多相關技能培訓課程如 Microsoft Access Programming。
學費
$1290*
*全期學費為 $6450，並按照持續進修基金規定按月收費，合資格人士畢業後可獲持續進修基金發還最高八成學費，實際學費支出最低為 $1290
課程時間
30 小時
入學要求
申請者須年滿 18 歲，中五以上程度，熟識 Microsoft Windows 操作。申請者無須懂得 Microsoft Access 。
獲頒證書及提交習作
學員須完成一個有關庫存管理之作業，由導師評分。完成課程後，成績合格的學員將獲頒畢業證書。
歡迎你在本網站報名留位。系統上展視和收取的學費可能因完成課程的時段長短而有所不同。根據學生資助辦事處指引我們會按月收取學費。只需按”Enrol”及後到”Checkout”頁面即可辦理留位及付款程序。
| Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Course Fee 全期學費 | Enrol 報名 | |
|---|---|---|---|---|---|---|---|---|---|
| CIMB-6D4K | Cantonese / PC / MongKok | 04-May | 01-Jun | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190504 | $6,450 | $3,225Enrol |
| CIMB-25C7K | Cantonese / PC / MongKok | 07-May | 11-Jun | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190507 | $6,450 | $3,225Enrol |
| CIMB-35C22E | English / PC / Central | 22/05 | 26/06 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190522 | $6,450 | $3,225Enrol |
| CIMB-35C12C | Cantonese / PC / Central | 12/06 | 12/07 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190612 | $6,450 | $3,225Enrol |
| CIMB-6D15E | English / PC / Central | 15/06 | 13/07 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190615 | $6,450 | $3,225Enrol |
| CIMB-6D32C | Cantonese / PC / Central | 06/07 | 03/08 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190706 | $6,450 | $3,225Enrol |
| CIMB-14C8K | Cantonese / PC / MongKok | 08/07 | 08/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190708 | $6,450 | $3,225Enrol |
| CIMB-14C22E | English / PC / Central | 22/07 | 22/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190722 | $6,450 | $3,225Enrol |
| CIMB-24C13C | Cantonese / PC / Central | 13/08 | 12/09 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190813 | $6,450 | $3,225Enrol |
| CIMB-6D17E | English / PC / Central | 17/08 | 21/09 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190817 | $6,450 | $3,225Enrol |
| CIMB-6D37K | Cantonese / PC / MongKok | 07/09 | 12/10 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190907 | $6,450 | $3,225Enrol |
| CIMB-25C10K | Cantonese / PC / MongKok | 10/09 | 18/10 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190910 | $6,450 | $3,225Enrol |
| CIMB-24C32E | English / PC / Central | 24/09 | 29/10 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190924 | $6,450 | $3,225Enrol |
| CIMB-35C27C | Cantonese / PC / Central | 16/10 | 15/11 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20191016 | $6,450 | $3,225Enrol |
| CIMB-6D33C | Cantonese / PC / Central | 19/10 | 16/11 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20191019 | $6,450 | $3,225Enrol |
| CIMB-6D13E | English / PC / Central | 27/04 | 25/05 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190427 | $6,450 | $3,225Enrol |
| CIMB-6D4K | Cantonese / PC / MongKok | 04/05 | 01/06 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190504 | $6,450 | $3,225Enrol |
| CIMB-25C7K | Cantonese / PC / MongKok | 07/05 | 11/06 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190507 | $6,450 | $3,225Enrol |
| CIMB-35C22E | English / PC / Central | 22/05 | 26/06 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190522 | $6,450 | $3,225Enrol |
| CIMB-35C12C | Cantonese / PC / Central | 12/06 | 12/07 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190612 | $6,450 | $3,225Enrol |
| CIMB-6D15E | English / PC / Central | 15/06 | 13/07 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190615 | $6,450 | $3,225Enrol |
| CIMB-6D32C | Cantonese / PC / Central | 06/07 | 03/08 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190706 | $6,450 | $3,225Enrol |
| CIMB-14C8K | Cantonese / PC / MongKok | 08/07 | 08/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190708 | $6,450 | $3,225Enrol |
| CIMB-14C22E | English / PC / Central | 22/07 | 22/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190722 | $6,450 | $3,225Enrol |
| CIMB-24C13C | Cantonese / PC / Central | 13/08 | 12/09 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190813 | $6,450 | $3,225Enrol |
| CIMB-6D17E | English / PC / Central | 17/08 | 21/09 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190817 | $6,450 | $3,225Enrol |
| CIMB-6D37K | Cantonese / PC / MongKok | 07/09 | 12/10 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190907 | $6,450 | $3,225Enrol |
| CIMB-25C10K | Cantonese / PC / MongKok | 10/09 | 18/10 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190910 | $6,450 | $3,225Enrol |
| CIMB-24C32E | English / PC / Central | 24/09 | 29/10 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190924 | $6,450 | $3,225Enrol |
| CIMB-35C27C | Cantonese / PC / Central | 16/10 | 15/11 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20191016 | $6,450 | $3,225Enrol |
| CIMB-6D33C | Cantonese / PC / Central | 19/10 | 16/11 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20191019 | $6,450 | $3,225Enrol |
| CIMB-6D13E | English / PC / Central | 27/04 | 25/05 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190427 | $6,450 | $3,225Enrol |
| CIMB-6D4K | Cantonese / PC / MongKok | 04/05 | 01/06 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190504 | $6,450 | $3,225Enrol |
| CIMB-25C7K | Cantonese / PC / MongKok | 07/05 | 11/06 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190507 | $6,450 | $3,225Enrol |
| CIMB-35C22E | English / PC / Central | 22/05 | 26/06 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190522 | $6,450 | $3,225Enrol |
| CIMB-35C12C | Cantonese / PC / Central | 12/06 | 12/07 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190612 | $6,450 | $3,225Enrol |
| CIMB-6D15E | English / PC / Central | 15/06 | 13/07 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190615 | $6,450 | $3,225Enrol |
| CIMB-6D32C | Cantonese / PC / Central | 06/07 | 03/08 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190706 | $6,450 | $3,225Enrol |
| CIMB-14C8K | Cantonese / PC / MongKok | 08/07 | 08/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190708 | $6,450 | $3,225Enrol |
| CIMB-14C22E | English / PC / Central | 22/07 | 22/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190722 | $6,450 | $3,225Enrol |
| CIMB-24C13C | Cantonese / PC / Central | 13/08 | 12/09 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190813 | $6,450 | $3,225Enrol |
| CIMB-6D17E | English / PC / Central | 17/08 | 21/09 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190817 | $6,450 | $3,225Enrol |
| CIMB-6D37K | Cantonese / PC / MongKok | 07/09 | 12/10 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190907 | $6,450 | $3,225Enrol |
| CIMB-25C10K | Cantonese / PC / MongKok | 10/09 | 18/10 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190910 | $6,450 | $3,225Enrol |
| CIMB-24C32E | English / PC / Central | 24/09 | 29/10 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190924 | $6,450 | $3,225Enrol |
| CIMB-6D13E | English / PC / Central | 27/04 | 25/05 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190427 | $6,450 | $3,225Enrol |
| CIMB-6D4K | Cantonese / PC / MongKok | 04/05 | 01/06 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190504 | $6,450 | $3,225Enrol |
| CIMB-25C7K | Cantonese / PC / MongKok | 07/05 | 11/06 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190507 | $6,450 | $3,225Enrol |
| CIMB-35C22E | English / PC / Central | 22/05 | 26/06 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190522 | $6,450 | $3,225Enrol |
| CIMB-35C12C | Cantonese / PC / Central | 12/06 | 12/07 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190612 | $6,450 | $3,225Enrol |
| CIMB-6D15E | English / PC / Central | 15/06 | 13/07 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190615 | $6,450 | $3,225Enrol |
| CIMB-6D32C | Cantonese / PC / Central | 06/07 | 03/08 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190706 | $6,450 | $3,225Enrol |
| CIMB-14C8K | Cantonese / PC / MongKok | 08/07 | 08/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190708 | $6,450 | $3,225Enrol |
| CIMB-14C22E | English / PC / Central | 22/07 | 22/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190722 | $6,450 | $3,225Enrol |
| CIMB-24C13C | Cantonese / PC / Central | 13/08 | 12/09 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190813 | $6,450 | $3,225Enrol |
| CIMB-6D17E | English / PC / Central | 17/08 | 21/09 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190817 | $6,450 | $3,225Enrol |
| CIMB-6D37K | Cantonese / PC / MongKok | 07/09 | 12/10 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190907 | $6,450 | $3,225Enrol |
| CIMB-25C10K | Cantonese / PC / MongKok | 10/09 | 18/10 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190910 | $6,450 | $3,225Enrol |
| CIMB-24C32E | English / PC / Central | 24/09 | 29/10 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190924 | $6,450 | $3,225Enrol |
| CIMB-35C27C | Cantonese / PC / Central | 16/10 | 15/11 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20191016 | $6,450 | $3,225Enrol |
| CIMB-6D33C | Cantonese / PC / Central | 19/10 | 16/11 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20191019 | $6,450 | $3,225Enrol |
| CIMB-6D13E | English / PC / Central | 27/04 | 25/05 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190427 | $6,450 | $3,225Enrol |
| CIMB-6D4K | Cantonese / PC / MongKok | 04/05 | 01/06 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190504 | $6,450 | $3,225Enrol |
| CIMB-25C7K | Cantonese / PC / MongKok | 07/05 | 11/06 | TUE,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190507 | $6,450 | $3,225Enrol |
| CIMB-35C22E | English / PC / Central | 22/05 | 26/06 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190522 | $6,450 | $3,225Enrol |
| CIMB-35C12C | Cantonese / PC / Central | 12/06 | 12/07 | WED,FRI | 1900-2200 | 30 hours/ 10 sessions | 20190612 | $6,450 | $3,225Enrol |
| CIMB-6D15E | English / PC / Central | 15/06 | 13/07 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190615 | $6,450 | $3,225Enrol |
| CIMB-6D32C | Cantonese / PC / Central | 06/07 | 03/08 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190706 | $6,450 | $3,225Enrol |
| CIMB-14C8K | Cantonese / PC / MongKok | 08/07 | 08/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190708 | $6,450 | $3,225Enrol |
| CIMB-14C22E | English / PC / Central | 22/07 | 22/08 | MON,THU | 1900-2200 | 30 hours/ 10 sessions | 20190722 | $6,450 | $3,225Enrol |
| CIMB-24C13C | Cantonese / PC / Central | 13/08 | 12/09 | TUE,THU | 1900-2200 | 30 hours/ 10 sessions | 20190813 | $6,450 | $3,225Enrol |
| CIMB-6D17E | English / PC / Central | 17/08 | 21/09 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190817 | $6,450 | $3,225Enrol |
| CIMB-6D37K | Cantonese / PC / MongKok | 07/09 | 12/10 | SAT | 1000-1300;1400-1700 | 30 hours/ 10 sessions | 20190907 | $6,450 | $3,225Enrol |
Microsoft Access 切合最佳成本效益，為中小型企業提供了理想的資料庫系統方案。今日，建立一個有效的資料庫系統再不限於是專業程式員的工作，只要將 Microsoft Access 的功能運用得宜，自行建立一個實用的資料庫系統並不困難。本課程會由教授 Microsoft Access 基本元素開始，然後循序漸進讓學員掌握高階概念及功能，包括查詢與報表的進階使用。本課程適合初合者參加。完成課程後，學員將會懂得從頭建立一個資料庫、使用多項 Microsoft Access 實用功能及有效管理資料庫。
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
你可能對以下感興趣
