/
/
/

Microsoft Access VBA (1 day)

(5.0)1 review
Recent reviews of this course provider

Introduction to Microsoft Excel

Clare was a really helpful and funny trainer and made the course fly by it wasn'...more

See all reviews
Add to shortlist

https://www.hotcourses.com/courses-by-subject/Microsoft-Access-VBA-1-day-courses/55677830/

Course description

Microsoft Access VBA (1 day):

Price: the price opposite is a total per day, click on View Course for full price details

Benefits of Microsoft Access VBA Course

This Microsoft Access VBA course has been designed to give experienced Access users the skills they need to understand the basics of VBA Programming. The course is 100% hands-on, with exercises to practice the skills as you learn them.

Visual Basic is, by far, the most widely used programming language in the world. VBA is no different from regular Visual Basic, but it can only be used to add features to Microsoft Office applications rather than to write free-standing applications. During the VBA course you will learn how to design an application, automate forms, create custom navigation and work with switchboards. You will also acquire the knowledge of working with VBA code and advanced VBA programming.

Our trainers are fully conversant with the Microsoft Office product suite and have many years of practical experience.

Trainees should have attended the Advanced Microsoft Access course or have a good working knowledge of table creation, basic query and report writing functions and relational database concepts. No programming experience is needed..

Course Content

Designing an application

  • Examining an application
  • Planning an application

Automating forms

  • Working with dialog boxes
  • Working with macro groups
  • Automating navigation across forms

Working with Switchboard and Splash Screen forms

  • Working with Switchboard forms
  • Working with Splash Screen forms
  • Automating Splash Screen forms

Creating custom naviagtion (ribbons & tabs)

  • Working with ribbons
  • Creating custom and shortcut menus

Working with VBA code

  • Discussing VBA programming elements
  • Working with modules
  • Creating procedures

Advanced VBA programming

  • Using control structures
  • Handling events
  • Resolving errors
  • Displaying a Web site
  • Working with MDE files

A total price for training up to 6 people and computers are provided free of charge (one per person).

Additional entry requirements

Trainees should have attended the advanced Access course or have a good working knowledge of table creation, basic query and report writing functions and relational database concepts. No programming experience is needed.

Training for employers

This course has been specifically designed for companies training their employees.

Course reference: MSACVB1 (use this when contacting provider)

Course info
116 views

Location:

Basingstoke, RG21 3EE, Birmingham, B1 1BD, Brighton, BN1 1YR, Bristol, BS1 6EA, Cambridge, CB1 1BH + 32 more

Time:

During the day

Duration:

1 day

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediate Advanced

From: £792

Other Access Database training courses

Microsoft Access Level 1

Insight IT Training Limited

Duration: Variable

Beginner

Certificate of Attendance

Microsoft Access Level 2

Insight IT Training Limited

Duration: Variable

Intermediate

Certificate of Attendance

View 4 courses

Summary of all course reviews for Insight IT Training Limited

1 review

(100%)

Average student ranking

Reviews of other courses at Insight IT Training Limited

insight-it-training

Introduction to Microsoft Excel
5 5
Hotcourses
by Tony - August 2017

Clare was a really helpful and funny trainer and made the course fly by it wasn't dull and was very engaging.

Was this review helpful? Yes No
1 Hotcourses user(s) found the following review helpful.

Please note reviews of Introduction to Microsoft Excel are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Microsoft Access VBA (1 day) by Insight IT Training Limited on Hotcourses

Ask a question

Get course info