Page 80 - iPro_trackGPT_V5_Class7
P. 80
Database and
DBMS—An 7
Introduction
Goal Glimpse
Concept of a Database Advantages of a Database System
Types of Databases Terms Related to a Database
Access 2021 Components of Access 2021
Creating a Database Data Types in Access 2021
Types of Views in Access Naming Conventions for Field Name
Creating a Table Opening an Existing Database
Exiting Access 2021
Previously, data was stored using a paper-based system, which had several drawbacks, including
vulnerability to damage, difficulty in editing, data redundancy, and challenging management.
Retrieving information from file-based systems was often tedious and time-consuming. To address
these issues, computerised database systems were 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
These advantages make DBMS a powerful tool for managing information efficiently and securely
are as follows:
Keeps Data Accurate: DBMS helps ensure that the information stored is correct, reducing
mistakes.
Fast Data Access: It makes finding and retrieving information quick and easy.
Protects Information: DBMS lets you control who can see or change the data, keeping it safe.
Allows Sharing: Many people can use the same data at the same time without any issues.
Automatic Backups: It saves copies of the data and can restore it if something goes wrong.
78 TrackGPT iPRO (V5.0)-VII

