Access as an RDBMS

An Access desktop database is a fully functional RDBMS. It provides all the data definition, data manipulation, and data control features you need to manage large volumes of data.

You can use an Access desktop database (.accdb) either as a stand-alone RDBMS on a single workstation or in a shared client/server mode across a network. A desktop database can also act as the data source for data displayed on Web pages on your company intranet. When you build an application with an Access desktop database, Access is the RDBMS. You can also use Access to build applications in a project file (.adp) connected to Microsoft SQL Server, and you can share the server data with other applications or with users on the Web. When you create an ...

Get Microsoft Office® Access 2007 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.