• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Access 2000 VBA

View course dates

Course Duration: 2 days

Course Code: DAC2KVBA

Course Description:

Microsoft Access is the desktop database design product from the Microsoft Office professional suite. This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA).

 

Course Content

 

Session 1 - Macros: Creating basic macros and attaching them to events

Session 2 - Advanced macros: Group and Conditional macros

Session 3 - Introduction to the Object Model

Session 4 - Using the VBA Integrated Development Environment

Session 5 - Collections, Variables and Notation

Session 6 - Message Boxes and Input Boxes

Session 7 - Control Structures I: Branching with ‘if’ and ‘select case’

Session 8 - Control Structures II: Looping with ‘for each’, ‘do while’ and ‘do until’

Session 9 - Using built-in VBA functions

Session 10 - Control Structures III: Jumping; creating your own Methods & Functions

Session 11 - Error trapping and debugging

Session 12 - Workshop and practise time

 

The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to programming, in particular the Visual Basic programming language.

 

At the end of the course you will be able to:

 

- Create macros to automate tasks, as well as understand their limits
- Create macros which carry out different actions according to a condition
- Understand what VBA is
- Understand the Access object model, and make use of its properties, methods and events
- Work with forms to create better user interface
- Declare variables, and manipulate them
- Write code which looks at a condition and carries out different actions accordingly
- Write code which repeats an action a specified number of times
- Write code using built in VBA functions
- Write user defined functions, frequently used pieces of code
- Trap errors, to avoid users seeing problems
- Find problems in your own code

Prerequisites:

The course is aimed at those with no previous programming experience, who are looking to develop databases that go beyond what Access alone is capable of.
Delegates must have an excellent working knowledge of Microsoft Access. You must be able to create tables, queries, forms and reports.

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course