Microsoft Access VBA Programming (2 days)

Designed for experienced Access users wishing to use VBA for database application development.

The Visual Basic Editor

Using the Project Explorer window
Using the code window
The Property window
Using the Immediate window
Setting user options

VBA Fundamentals

Benefits of VBA
Modules and procedures
Standard modules and form modules
Understanding Access objects
Using the Object Explorer
Understanding object properties
Understanding object methods

VBA Programming

Creating sub procedures
Defining variables
VBA data types
Conditional statements
Using If statements
Using Select Case statements
Looping structures
Using For Next loops
Using While Wend loops
Calling a subroutine
Supplying parameters
Calling a funciton and supplying parameters
Returning a value

Objects and collections

Setting properties
Creating command buttons
Using ActiveX controls
Pop-up forms
Manipulating objects
Properties and methods
Manipulating collections
Using object variables
Understanding events

Programming forms

The Forms collection
The Me keyword
Opening and closing forms
The form module
Form and control properties
Form events
Selection controls
Populating a list control
Working with option groups

Programming reports

An introduction to the report module and events
Opening and closing reports
Passing arguments Using OpenArgs
Populating the report
Handling report-level errors
Working with subreports

Error handling

Overview of error handling
Errors in design/logic
Compile errors
Run-time errors
Getting feedback on errors
Replacing standard error messages

Debugging

Stepping through code
Using breakpoints
Stepping through procedures
Examining variables

Back to top

Microsoft Access Training Enhances Individual Effectiveness

MS Access is always associated with the difficult side of computing and some teachers really make it hard for the students to learn this subject, but this is no longer an issue. If you really wish to learn MS Access, then here is the solution, Microsoft Access Training. Yes, the new training courses of MS Access are specifically designed for rapid learning and students can actually experience an improved efficiency with these valuable courses.

An administrator can also choose these courses in order to perk up the efficacy of his employees. From tracking the customer inquiries with more superiority to observing the data in a new manner, these training courses can guide people with every important aspect. People can discover working with various useful things and can bring a drastic change in the way of operating their business by getting trained in this powerful program.

Accurate & Easy To Use Database

A common misconception about using databases is that if multiple users make use of the same database, then the probability of missing out some important data becomes higher. Such people believe that database used by multiple users creates a mess in the database which results in decreased efficiency of the employees.

Microsoft Access Training courses help people to learn the creation of checks and balances. This system ensures that if multiple users are using the same database, even then the input statistics will be accurate, thereby improving the overall efficiency. In addition to this, these training courses also guide people about organizing the data appropriately so that extracting and inputting the information becomes easier for all.   

Inventory Control Databases

There are several advanced Microsoft Access Training courses which can help entrepreneurs in managing the information with inventory control. These advanced courses target the use of Access Wizard so as to create different kinds of databases for handling various facets of a business.

Whether a person is a beginner or a professional, these advanced courses can lend a hand at every step and the best part is that these are very easy to learn and understand. People can become fluent in working with various database programs by simply opting for these advanced courses.   

Custom Database Tables

Becoming a whiz at databases is very easy with Microsoft Access Training courses. These courses with relational databases help people in personalizing their database just the way they want. For adding different kind of information, people can easily create specific tables and add different fields as per their requirements.

These days, the internet can be used as a great tool and an online help for learning MS Access. The documented material, videos and audios offer a great learning experience and make it really easy for the students to grab things. This way, employers can also train their staff members without any efforts and have the benefit of increasing the overall proficiency of the organization. So, don’t feel threatened of MS Access, just choose Microsoft Access Training courses and get clued up.