Share via

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.

  • Article

database objects

In a Microsoft Access database, the types of database objects available are tables, queries, forms, reports, macros, and modules.

For a Microsoft Access project connected to a SQL Server database, the database objects are tables (including indexes, triggers, keys, constraints, defaults, rules, and user-defined data types), views, stored procedures, and database diagrams. The Access project objects are forms, reports, macros, and modules.

From both Access databases and Access projects, you can also create data access page objects, which are stored as separate files outside the Access database or Access project file.