Page 86 - iPlus_Ver_2.0_class_7
P. 86
Database and DBMS—
An Introduction
7
Learning Outcomes
Concept of a Database Advantages of a Database System
Types of Databases Terms Related to a Database
Access 2016 Components of Access 2016
Creating a Database Data Types in Access 2016
Types of Views in Access Rules for Writing a Field Name in Access
Creating a Table Adding a Record
Opening An Existing Database Exiting Access 2016
Earlier, a paper-based system was used to store data. But this system had various drawbacks,
such as being prone to damage, editing problems, data repetition, and being difficult to manage.
Retrieving data from file-based systems was a very tedious and time-consuming task. To overcome
the problems in file-based systems, a computerised database system was introduced in the 1960s.
i + CONCEPT OF A DATABASE
Database implies organising the data in a manner that helps to store and retrieve a large amount
of data efficiently. The database concept is one of the oldest ways to maintain records in a
conventional file-oriented data collection system.
Computerised data collection and manipulation systems have replaced conventional
record-keeping systems by using application programs. The various components of the
computerised database system have a logical relationship that helps in accessing data easily.
A collection of programs required to store and retrieve data from a database is called a Database
Management System (DBMS).
i + ADVANTAGES OF A DATABASE SYSTEM
A database system has many benefits. Some of the important benefits or advantages are:
• It minimizes the duplication of data by integrating and sharing the data files.
• It saves storage space.
84
iPlus (Ver. 2.0)-VII

