Page 84 - iPrime_V2.2_class7
P. 84
7 Database and DBMS—
An Introduction
Chapter Profile
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 Naming Conventions for Writing a Field Name in Access
Creating a Table 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.
CONCEPT OF A DATABASE
A database organises data in a manner that allows for efficient storage and retrieval of large
amounts of information. Although databases are a more recent development, they evolved
from older file-oriented data collection systems. Computerised data collection and manipulation
systems have since replaced these conventional record-keeping methods, using application
programs to manage data. The components of a computerised database system are logically
related, facilitating easy access to data. The software required to store, retrieve, and manage data
in a database is known as a Database Management System (DBMS).
ADVANTAGES OF A DATABASE SYSTEM
A database system has many advantages. Some of the most important are:
It minimises the duplication of data by integrating and sharing the data files.
It saves storage space.
All the users are provided with some access rights or privileges and permissions.
The files can be easily updated whenever any changes are made.
82 Touchpad iPRIME (Ver. 2.2)–VII

