特別通告

CUSCS 中環教學中心課堂特別安排 (2019年10月14日)

 

原定於香港中文大學專業進修學院中環教學中心(美國銀行中心)進行的晚間課堂將會調往其他地點上課,詳情請按此查閱有關安排。本院將個別以電郵及電話短訊聯絡有關學員。不便之處,敬請原諒。

關閉
Main content start

資訊科技基礎及管理

Database Software and Application (Access)
微軟ACCESS資料庫應用

Course No. : 193-189307-01|Start Date : 22/11/2019

Admission Requirements

Participants should have basic knowledge in computer and Internet operations.

Instructor

CUSCS Instructor

Language Used

Cantonese (supplemented with English)

Total Hours

15.0 hour(s)

Session

5

Place

Tsimshatsui Oriental Learning Centre

Start Date

22/11/2019

Schedule

Friday

Time

18:45 - 21:45

Tuition Fee

HK$ 1,550.00

Level

General Short Courses

Course Enquiries

3943913127708275[JavaScript encoded]

Enrolment Enquiries

2209 0290

Closing Date for Application

Enrolment deadline is 10 calendar days before the course commencement date. Late enrolment will only be considered if there are still vacant places.

1
Objectives

MS Access is one of the most popular database software in the commercial world. MS Access is a powerful, mature relational database management system (RDBMS) which runs under the Windows environment. Participants are expected to learn how to view, manipulate and find required data using Access visual tools quickly and easily. Participants are capable of fully applying what they have learnt in class on their real business.

2
Course Content

1. Building up a database concept, table design, fields, data type, data entry, working with records;
2. Relationships, Queries, Forms, Reports, Macros;
3. Querying a database data search, Update query;
4. Maintaining a database relationship, index, referential integrity;
5. Presenting data reports and forms;
6. Advanced topics macros and modules, GUI as menu;
7. Working with Hyperlinks;
8. Introduction to Application Development;
9. Other Useful Tools:Importing and Exporting, Compact & Repair, Object Dependencies;
10. Database Security.

Each participant will be provided with one PC terminal for hands-on practice.

3
Software used

Access 2010