Project Description
Welkin Course Code: AXI7
Course Features
Microsoft Access and Excel can work together to improve work productivity. This course teaches you the techniques to manipulate data easily between the two programs using VBA, an effective tool to automate redundant processes.
- Extracting and moving data between Access and Excel
- Presenting Access data in Excel
- Using VBA to manipulate queries
- Qualified and experienced trainer
- Easy-to-follow, step-by-step hands-on learning approach
- Daytime, evening and weekend class options
Learn from the Experts
Get Your Skills Certified
Certify your Excel and 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
Course Fee
$3100
Course Duration
12 Hours
Course Prerequisites
Course participants should have a basic knowledge of Microsoft Excel and Microsoft Access.
Title of Award
Upon successful completion of the course, students will receive a Certificate of Achievement for the course.
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 報名 | |
|---|---|---|---|---|---|---|---|---|
| AXI7-52C20C | Cantonese / PC / Central | 20-Sep | 04-Oct | FRI,TUE | 1900-2200 | 12 hours / 4 sessions | 20190920 | $3,100Enrol |
| AXI7-6A33K | Cantonese / PC / MongKok | 16/11 | 07/12 | SAT | 1000-1300 | 12 hours / 4 sessions | 20191116 | $3,100Enrol |
| AXI7-35C33C | Cantonese / PC / Central | 18/12 | 03/01 | WED,FRI | 1900-2200 | 12 hours / 4 sessions | 20191218 | $3,100Enrol |
Upon course completion, you will understand how to:
- import and organize information effectively by using a Microsoft Access database
- import and query data in Excel files
- use advanced queries such as aggregate queries, action queries and sub-queries in filtering and retrieving records from Access
- use ADO and advanced SQL statements in Excel VBA to retrieve or manipulate Access records
- Microsoft Access
- Microsoft Access overview
- Tables and relationships
- Design effective database using generalization techniques
- Importing Excel data into Access
- Queries
- Creating queries using Access query window
- Creating SQL statements (in SQL window)
- Using SQL operators, aggregate queries, calculated fields, action queries and sub-queries
- Querying multiple tables
- Excel VBA programming – using ADO
- Intermediate VBA programming skills
- Programming ADO
- Using advanced queries in VBA to retrieve and modify Access database records
- Practical project
- Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
- CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
