Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 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

Module 11: Using reports

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

Module 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

Module 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

Module 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
　

合共: 18小時

課程費用: $4980

於6月8日前報名，可享超級優惠價 $2,980 (原價: $4,980) 及免費送你 i-FEVA FevaWorks 網上視像課程 (1年)，價值 $1999

你亦可以優惠價 $999 換購 SAMSUNG Galaxy Tab A7 Lite (Wi-Fi)，價值 $1,288。

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

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

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

請按此查閱付款方法

退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件，學員亦可按此閱讀。

本中心備有完善之免費補堂，免費重讀及彈性上課安排 (攝影課程除外)，令學員更有保障。

本中心榮獲各大國際機構 (Adobe, Autodesk, Microsoft, H3C, Lenovo, Corel, Prometric, VUE, Certiport, Wacom 等等) 邀請成為香港區指定的認可教育中心及連續15+ 年榮獲香港社會服務聯會嘉許為「商界展關懷」公司，以表揚 Feva Works 對社會的貢獻。

除此之外，Feva Works 更連續 10 年獲 Microsoft 頒發全港最佳 Microsoft 授權培訓中心 (Best Microsoft Certified Partner for Learning Solutions of the Year) 及被 Adobe 選定為 Adobe CS4 & CS5 & CS6 & Creative Cloud 指定認可培訓中心。最近，Feva Works 更連續 10 年獲e-zone 電腦雜誌頒發最佳IT培訓中心。