Working with Microsoft Access Objects
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Working with Microsoft® Access objects primarily means working with Form, Report, and DataAccessPage objects and the controls they contain. You can use these powerful Access objects to format and display data and make it possible for the user to add or edit data in a database. In addition, Access exposes many other objects you can use to work with your Access application; among the most important are the CurrentProject, CurrentData, CodeProject, CodeData, Screen, and DoCmd objects and the Modules and References collections. This section presents an overview of how to work with Access objects by using Microsoft® Visual Basic® for Applications (VBA).
**Note **You can use the Object Browser and Access Visual Basic Reference Help to learn more about individual objects, properties, methods, and events.
Tables and relationships, the data in tables, and queries are managed and maintained by a database engine. For .mdb-type databases, Access uses the Microsoft® Jet database engine. For .adp-type databases, Access uses the Microsoft® SQL Server database engine or any other ActiveX Data Objects (ADO) data source. You programmatically work with tables, data in tables, or queries by using ADO or Data Access Objects (DAO).
In This Section
- Understanding the Access Application Object
Use the properties and methods provided by the Application objects to create and work with other Access objects. - Built-in Access Functions and Methods
Learn about functions and methods that appear in the Object Browser as methods of the Application object. - Working with Reports, Forms, and Data Access Pages
Use reports, forms, and data access pages provided by Access to display data to the user.
Related Sections
- Working with Office Applications
Take advantage of different objects, collections of objects, properties, methods, and events to build your application. - Working with Microsoft Excel Objects
Use Microsoft® Visual Basic® for Applications (VBA) to work with Microsoft® Excel objects, from within either Excel itself or another Microsoft® Office XP application to gain access to every part of Excel. - Working with Microsoft FrontPage Objects
Create, deploy, modify, and manage Web sites using Microsoft® FrontPage®. - Working with Microsoft Outlook Objects
Create custom Microsoft® Outlook® objects and manipulate those objects from within Outlook or from another application using Microsoft® Visual Basic® for Applications (VBA) code from within Outlook or another Microsoft® Office XP application by using Automation. - Working with Microsoft PowerPoint Objects
Automate Microsoft® PowerPoint® by using the Application object, from which you can open an existing Presentation object or create a new presentation. - Working with Microsoft Project Objects
Build powerful custom applications easily with the Microsoft® Project object model. - Working with Microsoft Word Objects
Use ® Visual Basic® for Applications (VBA) to work with the Microsoft® Word® Document object, Application object, and Documents collection. - Working with Microsoft Visio Objects
Design, model, and manage complex enterprise-level systems with the sophisticated tool set provided by Microsoft® Visio® products.