资讯科技基础及管理
Database Software and Application (Access)
微软ACCESS资料库应用
Course No. : 223-189307-01|Start Date : 11/10/2022
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
Start Date
11/10/2022
Schedule
Tuesday
Time
18:45 - 21:45
Tuition Fee
HK$ 1,630.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.
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 2016