ABSTRACT

Microsoft Access 2013 (called “Access” in the following text) is a database management system (DBMS) that is included in Microsoft Office to support the implementation of a database on computers based on a relational model of database. An Access database contains a collection of data objects: tables to store records of relations, queries to retrieve data selectively in various ways, and forms and reports to present retrieved data in userpreferred formats. This chapter describes the use of Access to implement data storage and data queries in a database. Access forms and reports are not included in this chapter because the graphical user interface for the data presentation in user-preferred formats is created using Microsoft Visual Studio and is described in Chapters 11, 12, 13, and 16. Visual Studio is used to develop a Windows-based or Web-enabled database application with an Access database embedded.