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 Capabilities of MS Access Access has certain capabilities, which bring it closer to an ideal Database Management System.
These capabilities are : Storing the data in an organised manner. Enforcing data integrity constraints. Representing complex relationship among data. Providing for persistent storage of database objects.
Restricting unauthorised access to database. Allowing fast retrieval of data with or without processing by using SQL. Flexibility to create multiple user interfaces. Providing for data sharing and multi-user transaction processing.
Supporting multiple