While using Access, you might get the impression that it's one big application. In reality, it consists of many smaller pieces, all working in harmony. These pieces are generally described as objects . For example, you have tables for storing data, queries that allow you to get at the data, in a specific way, and forms to allow the data to be displayed in a user -friendly way. These objects can also contain other objects - forms, for example, contain controls, such as text boxes and command buttons . Access allows you to program against these objects.
In this chapter, we are going to look at the different Access objects and how they provide a framework that you can use to build robust applications.
In particular we are going to look at:
What objects are
How they are used within Access 2002
What collections are, and the different types available in Access
How to use properties and methods