Page 85 - Trackpad_ipro 4.1_Class7
P. 85
Database and DBMS—
An Introduction
Chapter
07
Your Aim
to learn about:
Concept of a Database Advantages of a Database System
Types of Databases Terms Related to a Database
Access 2019 Components of Access 2019
Creating a Database Data Types in Access 2019
Types of Views in Access Naming Conventions for Writing a Field Name
Creating a Table Opening an Existing Database
Exiting Access 2019
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, privileges, and permissions.
The files can be easily updated whenever any changes are made.
Database and DBMS—An Introduction 83

