AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Access Objects

Courses


Access Objects

Length: 1    Cost: $425 + GST    Version: Access

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreAprMayJunJul
Auckland------
21
Hamilton------
04
Christchurch--------
Wellington--------

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

Our aim is to provide you with an introduction to Access Objects, allowing you to make the most of your VBA skills.



Prerequisites

Access Optimising and VBA Essential Skills in conjunction with having recently practised the topics covered in this course.
OR, Equivalent experience in developing Access databases.

Course Outline


Referencing Controls and Properties
A revision of how to reference controls & properties and some new and better ways of doing so.

SQL
An introduction to the SQL syntax with a bonus use this syntax to create a Union Query.

Using the Object Browser
Here you get to find all the objects available to you and easy access to help associated with them.

Working with a Combo Box
Now we show you how to dynamically filter the data shown in combo boxes.

Microsoft Access Objects
Learn about objects and how to use them to speed up your application and create generic procedures.

Data Access Objects
This topic will show you how to access your data directly from within your code. This can be useful for data validation when importing data or complex tasks beyond standard queries.

Error Handling
Since you have tested your code and deemed it to be working, everything should be just fine, shouldnt it? And then there is Murphys Law! No code is complete without appropriate error handling. The error handling covered here extends the error handling used in VBA Essential Skills.

Combo Box NotInList Event
Add new data to a combo box from the combo box itself your users will love you for it!


 Print this page