Database Management System

Forms : This object class allows the designer to create an appropriate user interface to formally interact with the back end database, defined by the tables and queries. Reports : This object class is used to create various reports, the source of information content of which is based on tables, queries or both. Such reports are designed in Access according to the requirement of end-user. Pages : This object class is meant to create Data Access Pages, which can be posted on a Web site of an organisation using Internet or sent via e-mail to someone of the organisation’s network.

Macros : In macro programming, the objects using individual instructions called macro-oriented actions are manipulated. A Macro is a list of macro- oriented actions that run as a unit. Access provides for such Macro programming. Fig.

. : An example of database window to work in Access Modules : These are the foundations of any application and allow the designer to create a set of programming instructions, called functions or sub-routines that can be used throughout the application. The functions return a value while subroutines do not return any value. Access provides for creating such modules.

Each of these object classes is contained in the named database file of Access with MDB extension. Whenever this file is opened, a database window, as shown on next page, opens with all the above object classes available on the left hand side. As and when the specific objects are created or designed, they get listed on right hand side of this window against each of these object classes. Box