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
- 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
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.
Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Enrol 報名 | |
---|---|---|---|---|---|---|---|---|
DD9I-25C20K | Cantonese / PC / MongKok | 20/09 | 30/09 | TUE,FRI | 1900-2200 | 12 hours / 4 sessions | 20220920 | $2,400Enrol |
DD9I-22081K | Cantonese / PC / MongKok | 01/08 | 02/08 | MON,TUE | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20220801 | $2,400Enrol |
DD9I-22101K | Cantonese / PC / MongKok | 17/10 | 18/10 | MON,TUE | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20221017 | $2,400Enrol |
DD9I-22121K | Cantonese / PC / MongKok | 12/12 | 13/12 | MON,TUE | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20221212 | $2,400Enrol |
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.
- Basic Tasks for an Access Desktop Database
- Choose a template
- Create a database from scratch
- Import or link to data
- 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
- 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
- Introduction to Tables
- Overview
- Add a table to an Access desktop database
- Set table properties in a desktop database
- 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
- 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
- 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
- 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
- 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
- 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
- You can enrol this course by our online system, or call (852) 3605 3322 for reservation.