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 hands-on learning approach
  • Daytime, evening and weekend class options

Learn from the Experts

Get Your Skills Certified

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 CEF reimbursable course Business Analysis with Microsoft Excel.

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.

Schedule & Online Enrolment
Enquiry/Booking
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Access and Excel Integration with VBA 2010
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

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.

You may also be interested in