Course Details

Certificate in Microsoft Access Database Specialist
Access 資料庫專業證書課程

Access 是辦公室資料管理的皇牌軟件。你能利用Access輕易為資料建立關係,方便管理人員作出不同形式的資料查詢。亦能匯合資料建立不同的報表,更能建構出不同功能的小型資訊系統,實在是辦公室資料管理的一大利器。
Image
Course Introduction 課程簡介

當你要管理的資訊日益龐大及複雜,便不能再單靠 Excel來管理,你應該考慮將你的技術層次由Excel進階至Access資料庫。 本課程完整介紹 Access 資料庫設計及製作觀念,帶你由淺入深,學通所有功能,提昇資料的管理能力。

Target and Duration 對像及時數

學習人士需懂得如何運用 Excel 基本功能,方能事半功倍。

課程為期六小時,由持有 Microsoft Access 專家認證的豐富經驗導師任教。

Learning Targets 學習目標
認識Access資料庫
From Excel to Access (Why and How), Import and Export Data between Excel and Access
單一資料表設計及各種限制設定
Single Table, Data Types, Primary Key, Validation Rules, Input Masks, Table Lookup
多個資料表設計及建立資料表關係
Multiple Table, Database Design, Normalization, Foreign Key, Relationship (Inner and Outer Joins)
建立基本查詢及各種排序篩選技巧
Simple Query, Sorting, Text Filtering, Date Filtering, Number Filtering
建立進階查詢(計算欄位及動作查詢)
Calculated Field, Action Query, CrossTab Query, Make Table Query
表單製作
Navigation Form, Form Design, SubForm Designs, Forms Controls, Form Header and Footer
報表製作
Simple Report Design, Complex Report with Summarized Section
資料庫備份,修復及分割
Backup, Restore and Split Database

Course Arrangement 課程安排

本課程針對企業客戶而設,客戶可組團到本校上課或要求導師上門授課均可。一班最多24人,價錢為 HK8,800元。 可安排一天或兩個半天上課。客戶使用軟件為 Access 2010, 2013, 2016均可。此為標準課程內容,如需增強或減少某部分,請與客戶服務主任羅小姐 (21361234) 聯絡。

Course Content 課程內容

1) Create and Manage a Database 建立及管理資料庫

Create and Modify Databases

  • Create a blank desktop database
  • Create a database from a template
  • Create a database by using Import objects or data from other sources
  • Delete database objects

Manage Relationships and Keys

  • Create and modify relationships
  • Set the primary key
  • Enforce referential integrity
  • Set foreign keys
  • View relationships

Navigate through a Database

  • Navigate specific records
  • Create and modify a navigation form
  • Set a form as the startup option
  • Display objects in the Navigation Pane
  • Change views of objects

Protect and Maintain Databases

  • Compact a database
  • Repair a database
  • Back up a database
  • Split a database
  • Encrypt a database with a password
  • Recover data from backup

Print and Export Data

  • Print reports
  • Print records
  • Save a database as a template
  • Export objects to alternative formats

2) Build Tables 建立及管理資料表

Create Tables

  • Create a table
  • Import data into tables
  • Create linked tables from external sources
  • Import tables from other databases
  • Create a table from a template with application parts

Manage Tables

  • Hide fields in tables
  • Add total rows
  • Add table descriptions
  • Rename tables

Manage Records in Tables

  • Update records
  • Add records
  • Delete records
  • Append records from external data
  • Find and replace data
  • Sort records
  • Filter records

Create and Modify Fields

  • Add fields to tables
  • Add validation rules to fields
  • Change field captions
  • Change field sizes
  • Change field data types
  • Configure fields to auto-increment
  • Set default values
  • Using input masks
  • Delete fields

3) Create Queries 建立及管理查詢

Create a Query

  • Run a query
  • Create a crosstab query
  • Create a parameter query
  • Create an action query
  • Create a multi-table query
  • Save a query

Modify a Query

  • Rename a query
  • Add fields
  • Remove fields
  • Hide fields
  • Sort data within queries
  • Format fields within queries

Sharing and Tracking Changes

  • Sharing and stop sharing the worksheets
  • Track changes and view the changes
  • Accept or rejects the changes made by others

Create Calculated Fields and Grouping within Queries

  • Add calculated fields
  • Set filtering criteria
  • Group and summarize data
  • Group data by using comparison operators
  • Group data by using arithmetic and logical operators

4) Create Forms 建立及管理表單

Create a Form

  • Create a form
  • Create a form from a template with application parts
  • Save a form

Configure Form Controls

  • Move form controls
  • Add form controls
  • Modify data sources
  • Remove form controls
  • Set form control properties
  • Manage labels
  • Add sub-forms

Format a Form

  • Modify tab order
  • Configure Print settings
  • Sort records by form field
  • Apply a theme
  • Control form positioning
  • Insert backgrounds
  • Insert headers and footers
  • Insert images

5) Create Reports 建立及管理報表

Create a Report

  • Create a report based on the query or table
  • Create a report in Design view
  • Create a report by using a wizard

Configure Report Controls

  • Group and sort fields
  • Modify data sources
  • Add report controls
  • Add and modify labels

Format a Report

  • Format a report into multiple columns
  • Add calculated fields
  • Control report positioning
  • Format report elements
  • Change report orientation
  • Insert header and footer information
  • Insert images
  • Apply a theme

Trainer Profile

Dannis Mok

who have rich experience in business web and apps system development and have over 15 years of teaching experience. He has great passion in learning and teaching new technologies. His teaching style is clear to point and can explain complex technologies in simple terms. He has delivered various workshops and classes for different corporate, government departments and local universities. He got a MBA, Msc in IT and Msc in Telecommunication.

相關專業認證
  • Microsoft MCSE, MCDBA, MCSD
  • Microsoft Office 2016 Specialist Master
  • Cisco CCNA,CCDA,CCNP,CCDP
  • Sun Microsystems – Certified Java Programmer
  • Oracle – Certified Database Professional
  • Linux - LPI Level 1 & 2
Technical Skills 相關教學經驗
  • 為積金局 IT 員工提供 Android 及 iPhone 視像培訓課程
  • 為香港教育局提供 Android 培訓課程與中學電腦科導師
  • 為香港教育大學 IT 員工提供跨平台流動程式開發課程
  • 為房屋署員工 IT 員工提供跨平台流動程式開發課程
  • 為香格里拉大酒店IT 員工提供跨平台流動程式開發課程
  • 為勞工處提供 HTML5 遊戲培訓課程及電子商店培訓課程
  • 為 VTC 職業訓練局提供各種各類 IT 培訓課程
Office Software 相關教學經驗
  • Prince Hotel 香港太子酒店
  • Marco Polo Hong Kong Hotel 馬哥孛羅香港酒店
  • Kerry Warehouse 嘉里貨倉
  • Labor Department 勞工處
  • Baguio Green Group 碧瑤綠色集團
  • 香港耆康老人福利會
  • Education Bureau 教育局
  • Hong Kong Institute of Education 香港教育大學
  • Hong Kong Housing Authority 香港房屋委員會
  • Hong Kong ICAC 香港廉政公署
  • Hang Seng Bank 恒生銀行
  • Civil Aivation Department 民航處
  • Darty Asia
  • UA Finance 亞洲聯合財務有限公司
  • 基督教香港信義會
Office Software 相關教學經驗
  • NCSI Hong Kong Ltd
  • HACEO 香港飛機工程
  • 香港善道會
  • 恆生銀行
  • 聯合國兒童基金會
  • Hong Kong VTC 職業訓練局
  • Hong Kong IVE 香港專業教育學院
  • VTech Hong Kong 偉易達香港
  • 香港明愛
  • JLL 仲量聯行
  • 救世軍
  • YWCA 女青年會
  • 連續兩年 (2017,2018) 為VTC 職業訓練局的員工作”辦公室軟件” 培訓
  • 連續五年為勞工處YES的會員作”辦公室軟件”培訓

Demo Video - Creating a Pivot Table for business data

More Questions?

Navigation

Social Media

IT Design