Access and Excel Integration with VBA 2017-09-15T14:26:02+00:00

Project Description

Loading...
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

By the end of the course you will have acquired the techniques to combine the features of Microsoft Access and Excel to share and organize information, automate tasks and produce reports.

  • Qualified and experienced trainer
  • Easy-to-follow, step-by-step learning approach
  • Daytime, evening and weekend classes

Learn from the Experts

Get Professional Recognition

mos-certificate

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

After completing this course you may further develop your knowledge and skills in data analysis with the course Business Analysis with Microsoft Excel.

Course Fee

$3060

Course Duration

12 Hours

Course Prerequisites

Course participants should be at least 18 years old and have an education level of Form 5 or above.

Title of Award

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

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
AXI7-13C16K
 Mongkok
 Cantonese / PC
16/10~25/10
1900-220012 hrs/
4 sessions
MON, WED3,060.00
AXI7-24C14C
 Central
 Cantonese / PC
14/11~23/11
1900-220012 hrs/
4 sessions
TUE, THU3,060.00
AXI7-6A9K
 Mongkok
 Cantonese / PC
9/12~6/1
1000-130012 hrs/
4 sessions
SAT3,060.00
AXI7-13C15C
 Central
 Cantonese / PC
15/1~24/1
1900-220012 hrs/
4 sessions
MON, WED3,060.00
AXI7-24C20K
 Mongkok
 Cantonese / PC
20/2~1/3
1900-220012 hrs/
4 sessions
TUE, THU3,060.00
AXI7-6A17C
 Central
 Cantonese / PC
17/3~14/4
1000-130012 hrs/
4 sessions
SAT3,060.00
Access and Excel Integration with VBA 2010/2007
Complete your Enrol
How to enrol/pay online

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
  1. Microsoft Access
    • Microsoft Access overview
    • Tables and relationships
    • Design effective database using generalization techniques
    • Importing Excel data into Access
  2. 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
  1. 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
  1. 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.
  2. 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.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in