Commercial package of MS-Office: MS-Access

2. MS-Office: MS-Access

• MS-Access

   Microsoft Access is a very easy and Popular Relational Database Management System that comes as a part of the Microsoft Office suite of Software. It Manages all the information in different tables and allows relations between these tables. The current versions are Microsoft Office Access 2010 for Windows.

 

• Definition of RDMS

   Dr. E. F. Codd of International Business Machin invested the concept of RDMS. RDMS information is stored in different tables that are related to each other.

   MS Access is used to make a database. MS-Access is an information management tool that helps the user to store information for reference, reporting, and analysis. It can help the user to overcome the limitations found when trying to manage a large amount of information in MS-Excel. The Extension of the MS-Access file is.MBD. The default name components of the database are Database 1.

• MS-Access has Following Components

   1. Tabel: All the data of the user is placed in the table. A Table is a named collection of records, related, to a single entity. A task is made out of several columns and records where each column represents some property of the entity. Rows are called records and columns are called fields.

   2. Query: Query is a request for retrieving data from the table, which satisfies a particular condition. The query only retrieves those records that satisfy the condition given in the query. A query not only displays the information but, it can also be used to delete or update records of the table or to perform calculations on data.

   3. Forms: Forms provide an interactive way to data entry into the table. The user can view, modify, or delete data stored in a table by using a form.

   4. Reports: Report is used to present data in pre-defined formate. Reports take data from base tables and present them in the way the user wants.

• Steps to Start MS-Access

   Start --> Program --> MS-Office MS-Access.

   In MS-Access, a database is created and then other components such as tables, queries, and reports are created. A field or group of fields that uniquely identifies a row in a task is called the Primary key. RDMS supports multiple tables that are related to each other. In a relationship, one table is regarded as the Master Task and The other is called the Transaction Task. Access supports three types of oof relations i.e. One-to-One, One-to-Many, and Mant-to-Many. a foreign key is the primary key of the master task included as a non-primary key in a transaction table.