O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required