• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. What Is Microsoft Access? > Microsoft Access as an RDBMS

Microsoft Access as an RDBMS

A Microsoft Access desktop database (which uses the .mdb file extension) 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 (.mdb) 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 (which uses the .adp file extension) connected to Microsoft SQL Server, and you can share the server data with other applications or with users on the Web. When you create a Microsoft Access project file (.adp), SQL Server (or the Microsoft SQL Server Desktop Engine—MSDE) is the RDBMS.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint