課程資料
Master in Microsoft Access 高級證書課程
MASTERACCESS
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $4980

 
課程費用無須申請任何政府基金資助。

繳費方法:

一般課程:按月等額收取列明的課程費用。本中心將不早於課程開始的一個月前收取第一期費用。除第一期的費用外,每期的費用會在課程進行期間每月的首個上學日或之後收取。

組合課程:若該課程為組合課程,本中心將按該組合課程分科收費,直至所收學費為該組合課程的等額費用為止。

 
退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
 
質素保證: 本中心備有完善之免費補堂,免費重讀及彈性上課安排,令學員更有保障。
 
   
理論: 0小時 實習: 18小時 示範: 0小時

合共: 18小時

 


課程內容:
Master in Microsoft Access 高級證書課程
1. What is Access?
1.1. What is a database?
1.2. Access as an Relational Database Management System
1.3. Access as an Application Development System

2. Exploring the Access Desktop Database Interface
2.1. Getting started with Databases
2.2. Understanding content security
2.3. Understanding the Office Fluent Ribbon
2.4. Understanding the Navigation pane
2.5. Using the single-document vs the multiple document interface

3. Designing Tables
3.1. Creating a new Database
3.2. Creating your first simple table by entering data
3.3. Creating a table using Data Type Parts
3.4. Creating a table in Design view
3.5. Defining fields
3.6. Defining a primary key
3.7. Defining a table validation rule
3.8. Understanding other table properties
3.9. Defining relationships
3.10. Adding indexes
3.11. Setting table design options
3.12. Database limitation

4. Modifying your table design
4.1. Deleting tables
4.2. Renaming tables
4.3. Changing field names
4.4. Moving fields
4.5. Inserting fields
4.6. Copying fields
4.7. Deleting fields
4.8. Changing data attributes
4.9. Reversing changes
4.10. Taking a look at Lookup properties
4.11. Working with Multi-Value Lookup Fields

5. Creating and working with queries
5.1. Selecting data from a single table
5.2. Working in query Datasheet view
5.3. Selecting data from multiple tables
5.4. Using a query wizard
5.5. Summarizing information with total queries
5.6. Customizing query properties
5.7. Editing and creating queries in SQL view
5.8. Limitations on using select queries to update data

6. Modifying data with action queries
6.1. Updating groups of rows
6.2. Creating a new table with a make-table query
6.3. Inserting data from another table
6.4. Deleting groups of rows
6.5. Troubleshooting action queries

7. Using forms in a databases
7.1. Uses of forms
7.2. A tour of forms
7.3. Moving around on forms and working with data
7.4. Adding records and changing data
7.5. Searching for and sorting data
7.6. Printing forms

8. Building a form
8.1. Forms and object-oriented programming
8.2. A simple input form
8.3. Working with Quick Create and the Form Wizard
8.4. Simplifying data input with a form
8.5. Working with Application Part Forms

9. Customizing a form
9.1. Aligning and sizing controls in Design view
9.2. Enhancing the look of a form
9.3. Setting control properties for forms
9.4. Setting form properties
9.5. Setting form and control defaults
9.6. Working with forms in Layout view
9.7. Using themes
9.8. Working with Shared Resources

10. Advanced Form Design
10.1. Basing a form on a multiple-table query
10.2. Creating and embedding subforms
10.3. Displaying values in an options group
10.4. Using conditional formatting in forms
10.5. Working with the tab control
10.6. Working with navigation controls
10.7. Using web browser controls

11. Using reports
11.1. Uses of reports
11.2. A tour of reports
11.3. Printing reports

12. Constructing a report
12.1. A simple report
12.2. Using the report command
12.3. Using the report Wizard
12.4. Working with reports in Layout view

13. Advanced report design
13.1. Building a query for a complex report
13.2. Creating the basic Facility Occupancy By Date Report
13.3. Defining the grouping and sorting criteria
13.4. Setting section and report properties
13.5. Using calculated values
13.6. Creating and embedding a subreport

14. Creating data macros in databases
14.1. Uses of data macros
14.2. Touring the Logic Designer
14.3. Working with Before events
14.4. Working with After events
14.5. Working with named data macros
14.6. Debugging data macros
14.7. Understanding recursion in data macros

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
MASTERACCESS23010014 
日期 12/1/2023~16/2/2023 (THU)
時間 19:00~22:00 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 2980