Project Description


Welkin Course Codes: DD9I

Course Description

Microsoft Access is a software platform for building relational databases or web apps to store and retrieve information efficiently. Without needing to write any code, Microsoft Access can conveniently manage your data and organize it for display. The course begins from the basics, covering topics including:

  • Database design basics
  • Tables and primary keys
  • Queries
  • Access forms and reports
  • Grouped or summary reports
By the end of the course, participants will be able to take advantage of Microsoft Access’ powerful features to manage and monitor data in a practical and efficient manner.
  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on learning approach
  • Best practices explained and demonstrated
  • Weekday evening and weekend classes available

Learn from the Experts

Get Your Skills Certified

Certify your Access skills with Microsoft Office Specialist certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Access database mangement with the course Microsoft Access for Advanced Users.

Course Fee


Course Duration

12 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Windows.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment

Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Access 2016 / 2019 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DD9I-23021KCantonese / PC / MongKok16/0217/02THU,FRI0930-1230;1400-170012 hours / 4 sessions20230216


Microsoft Access is a powerful database software application used to build relational databases. Access is noted for its friendly user interface and ease of use. In this course, you will learn the essential features of Microsoft Access and the skills to create and use an Access database.

  1. Basic Tasks for an Access Desktop Database
    • Choose a template
    • Create a database from scratch
    • Import or link to data
  2. Database Design Basics
    • Some database terms to know
    • What is good database design?
    • The design process
    • Determining the purpose of your database
    • Finding and organizing the required information
    • Dividing the information into tables
    • Turning information items into columns
    • Specifying primary keys
    • Creating the table relationships
  3. Learn the structure of an Access database
    • Overview
    • See details about the objects in a database
    • Explore a table in Design view
    • See the relationships between tables
    • See how objects use other objects
  4. Introduction to Tables
    • Overview
    • Add a table to an Access desktop database
    • Set table properties in a desktop database
  5. Add or Change a Table’s Primary Key in Access
    • Overview of primary key in Access
    • Add an AutoNumber primary key in Access
    • Set the primary key using fields you already have in Access
    • Remove the primary key in Access
  6. Filter data in a desktop database
    • About filtering
    • Different ways to filter
    • Switch between Filtered and Unfiltered views of your data
    • Clear a filter
    • Save a filter and apply it automatically
  1. Introduction to Queries
    • Queries help you find and work with your data
    • Create a select query
    • Apply criteria to a query
    • Apply criteria to text values
    • Apply criteria to dates
    • Create a parameter query
    • Create a totals query
    • Sum or count values on a datasheet with a Total row
    • Create a crosstab query
    • Create a make table query
    • Create an append query
    • Create an update query
    • Create a delete query
  2. Create an Access Form
    • Create a form from an existing table or query in Access
    • Create a form by using the Form tool
    • Create a blank form in Access
    • Create a split form in Access
    • Create a form that displays multiple records in Access
    • Create a form that contains a subform in Access
  3. Introduction to Reports in Access
    • Overview of reports in Access
    • Create a report in Access
    • Add grouping, sorting, or totals
    • Highlight data with conditional formatting
    • Customizing color and fonts
    • Add a logo or background image
    • Preview and print a report
  4. Create a Grouped or Summary Report
    • Create a quick grouped or sorted report
    • Build a new grouped report by using the Report Wizard
    • Add or modify grouping and sorting in an existing report
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in