If you are already an expert Access user you might have encountered requirements that are too complex to be implemented using standard Access features. Mastering VBA (Access 2000's programming language) will enable you to write custom code to implement just about any feature it is possible to describe!  Mastering VBA is also the only way to produce polished, professional, saleable applications using Access.

Visual Basic for applications is not an additional product. It already ships with Access.

VBA isn't for everybody. To get value from this course you'll need to already be an accomplished Access expert user (preferably by taking our core and advanced courses). Much of what you learn in our VBA course will also be relevant to writing custom VBA extensions to other office applications too (such as Excel).

If you are still unsure about what VBA can do for you review the course outline below by clicking the What Will I Learn? button. It things still aren't clear one of our Access experts would be pleased to advise how our VBA course can enable you to achieve your corporate goals.

Even if you are already competent with Access the process of designing and building a properly normalised and constrained database can be a daunting proposition.

We will guide you through the process of identifying the entities and attributes in your data model, correctly defining the one-to-many and many-to-many relationships and applying appropriate constraints. Our expert database designer will leave you with a database model that will serve you well and avoid the need for a costly re-design exercise in the future if your first draft contained design errors.

Leverage on our 20+ years of database design experience and book an Access database design day. We know you'll be truly delighted with the end result!

If you would like to know more about how we can help you achieve instant success in your next database project feel free to telephone or Email (numbers are at the bottom of the page) at any time.

Some of our clients have an urgent business requirement.  They need a solution fast.  A working Access application that can be used right now and further developed as required.  The problem is that they do not have the required advanced Access skills in-house.

One solution would be to employ an Access contractor to develop it.  The application might take months to build (at a daily rate of £500+) and still not really address requirements.  This is because the developer is an Access expert but NOT expert in your own business and will not fully understand your requirements.  Communicating them may take a long time - but the business needs the solution NOW.

Does this sound like you?

Give us an intelligent person (or persons) with a logical and analytical mind  - who may never have even seen Access before but completely understands your business requirement.  We'll send them back with a working application and all of the Access, Database Design and VBA skills they need to maintain and add new features. 

The delegate will build your application during the course by analysing which entities (tables) and attributes (fields) are needed by defining correct relationships. The delegate will then build all (or a subset of - depending upon what is possible during five days)  of the forms and reports needed to start using the application right away.

We'll cover all topics in our Access Expert course and Access VBA Course - all within the concept of your own business requirement.

Without a doubt this course provides the fastest and lowest-cost route to creating a custom business database application.

To discuss this in more detail feel free to Email or telephone us at any time.  An Access expert will clearly communicate what is, and isn't achievable in five days.  You'll be amazed at how much can be delivered in so little time and at such little cost.

• Basic, intermediate and advanced Access skills.
• Application development using VBA.
• The complete process of system analysis and the hands-on design and build of a correctly normalised and constrained Access database.
• Development of associated forms and reports.

See the outlines for the Complete, VBA and Database Design courses above for detailed information about what you will learn.