/
/
/

Microsoft Access 2013 VBA

(5.0)1 review
Recent reviews of this course provider

Very Good Course

Really good and thorough course. It moved at a good pace and covered many aspect...more

See all reviews
Add to shortlist

https://www.hotcourses.com/courses-by-subject/Microsoft-Access-2013-VBA-courses/55411252/

Course description

Microsoft Access 2013 VBA:

Who is this course for?

This course will enable the delegate to automate database tasks, add command buttons to forms, respond to data entry events, write functions and procedures, create a custom user interface, and display custom menus and toolbars. The course will provide knowledge of customising Access to an Advanced level and an introductory to intermediate level of VBA.

Content

Customising Access using VBA

Some practical uses for VBA in your applications, including:

Customising command buttons, making a form read only by default.

Displaying a message to the user, and using combo-boxes to find records.

Understanding Event Procedures

Performing actions as a user moves through a form

Validating data.

Asking the user a question.

Programming in VBA

Introducing some commonly used commands to give more power and flexibility to your code:

Understanding and using constants.

Toggling settings.

Managing user-input and displaying messages.

Declaring and using variables.

Use of conditional statements.

Responding to 'Events'.

Creating sub-procedures and functions.

Use General Functions on a form.

Monitor And Debug Your Code

Stepping through code line by line.

Monitoring variables and other values.

Finding and fixing bugs in your code.

Respond To Unexpected Errors

Replace standard error messages with your own message.

Respond to a Combo Box error.

Create error-handling routines.

Create a Custom Application

Gather information from a dialogue box.

Filtering data in a report.

Display custom toolbars.

Control how your application starts.

Customise the applications appearance.

Replace the Microsoft Access Splash screen.

Additional Topics

Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Additional entry requirements

It is assumed that you have a strong working knowledge of Access.

Training for employers

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

Course info

Location:

Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside

Time:

During the day or In the evening

Duration:

By arrangement

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

From: £405

Other Visual Basic courses

Microsoft Excel 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

Microsoft Word 2013 VBA

Vantage Training Ltd

Duration: Variable

Advanced

Certificate of Attendance

View 11 courses

Summary of all course reviews for Vantage Training Ltd

1 review

(100%)

Average student ranking

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info
Next steps
Add to shortlist