Access Database Objects

With the Navigation pane grouped on Object Type, you can see that there are four different types of database objects included in the Issues database: Tables, Queries, Forms, and Reports. The Access 2007 File Format (ACCDB) actually supports eight types of database objects: Tables, Queries, Forms, Reports, Macros, Modules, Class Modules, and Data Access Pages (DAPs). All of these objects except DAPs can be created through code or through the Access user interface (DAPs are deprecated in Access 2007, but can still be viewed). There are many reasons why you would want to create database objects via DAO or ADO code in an automated fashion, but often, it makes more sense to design database objects via the Access UI. The following sections explain how to create five of the object types via the Access 2007 UI.

0 0

Post a comment