Coupon Accepted Successfully!


Microsoft (MS Access)

It is one of the easiest and the most popular database software for creating storing and managing Database Management System. MS Access provides database properties and startup options to meet most of the customization needs. The startup options facilitate protection of the standard Access settings in the database that may be in conflict with their application needs, from being modified by unauthorized users. It also ensures that, when the applications are distributed, other programs that are in use do not override customer settings and also tests their application under different configurations.


MS Access is a popular Database Management System because it facilitates
  1. Easy creation of Data Tables
  2. Retrieval of Data
  3. Creation of Forms
  4. Generating of reports in different ways
MS Access is capable of storing a much larger volume of data than any other database systems. Generally, it is used to create user - friendly modules which help in maintenance of accounting work like making invoices, ledgers, record of clients, payroll of employees, debit and credit vouchers and task scheduler for any type of organization. It exercises complete control over the database objects, their properties and the relationships in this software.


In another way, we can say the MIS Access is a RDBMS that enables us to manage relational database in a Windows environment. It enables us to
  1. Create tables to organize data into manageable related units
  2. Enter, retrieve and modify data
  3. Extract information based on specific criteria
  4. Create forms to enter data, and
  5. Create reports
The term database refers to a single file that contains a collection of information stored in various tables with a default extension of .mdb. MS access database consists of a number of objects called database objects, which are shown below:
  1. Tables: It is used for data storage in a row - and - column format which is similar to spreadsheets. The components of a table are:
    1. Byte - It is a group of eight bits and is used for storing a character
    2. Data Item - A data item is one type of information and is normally referred to as data element.
    3. Record - It is a collection of data items representing a unit of information.
  2. Queries: It is used to view data from a table based on a specified criteria.
  3. Forms: It is used to enter, view and modify data in the table.
  4. Reports: It enables us to generate reports based on tables and query results.
  5. Data Access Pages: It enables us to view data from the internet where the data is stored in an Access database.
  6. Macros: It consists of a series of commands and functions that can be executed whenever we need to perform a task.

Test Your Skills Now!
Take a Quiz now
Reviewer Name