Course Information
Schedules
- 6 Jun 2025 (Fri) - 13 Jun 2025 (Fri) 10:00 AM - 5:00 PM
Registration period
5 Mar 2025 (Wed) - 23 May 2025 (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
1 views
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
Skills covered in this course
Start FollowingSee all
Courses that Might Interest You
- ACCESS TRAINING COURSE Computer Academy
- Microsoft Office 綜合應用證書 (資歷架構第 3 級 及 CEF 資助課程) Excel Pro Education
- Certificate Course in Python Programming x ChatGPT/GPT Computer Academy
【自我增值】被譽為21世紀最性感職業？！數據分析師8個必備技能
【自我增值】IT創科行業職位逆市增長 自學進修有錢途！
【自我增值】想學好Microsoft Office？ 而家喺屋企都有得上堂！
