Course Information
Schedules
- 6 Dec 2024 (Fri) - 13 Dec 2024 (Fri) 10:00 AM - 5:00 PM
Registration period
21 Nov 2024 (Thu) - 22 Nov 2024 (Fri)
Price
HKD 3,880
Course Level
Study Mode
Duration
2 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
Course Overview
This comprehension course will teach students how to leverage the power of VBA to automate the daily tasks in Access and Excel. For example, checking or posting records to the master database or merging data from different workbooks. After finishing the course, students will be able query data using the SQL language, and integrate the Access database and Excel spreadsheets seamlessly without using copy or paste functions.
What You’ll Learn
- VBA Programming Basics
- Working with VBA code editor
- Messages and variables
- Using built-in functions and statements
- Working with Access Objects and Methods
- Working with Access Data Object Model
- Working with Excel Objects
- Introduction to SQL
- Retrieving Data with SQL
- Using WHERE to Filter Results
- Access and Excel Integration
