The Architecture of Access

Access calls anything that can have a name an object. Within an Access database, the main objects are tables, queries, forms, reports, macros, and modules.

If you have worked with other database systems on desktop computers, you might have seen the term database used to refer to only those files in which you store data. In Access, however, a desktop database (.accdb) also includes all the major objects related to the stored data, including objects you define to automate the use of your data. You can also create an Access application using a project file (.adp) that contains the objects that define your application linked to a Microsoft SQL Server database that stores the tables and queries. Here is a summary of the major ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.