Page 35 - TP_Prime_V2.2_Class8
P. 35
03
WORKING WITH
ACCESS 2016
Learning Objectives WORKING WITH ACCESS 2016
• Concept of a Database
• Advantages of a Database System
• Types of Databases
• Terms Related to a Database
• Access 2016
• Starting Access 2016
• Components of Access 2016
In my school's accounts department, • Creating a Database 33
• Data Types in Access 2016
the clerk uses software to save • Types of Views in Access
• Naming Convention for Writing a Field Name in
the details of all the students and Access
teachers. Which type of software • Creating a Table
• Opening an Existing Database
did he use to store data? • Exiting Access 2016
He uses the database management system to store the data. Let's learn about
database management system in this chapter.
Earlier, file-based system was used to store data. But, this system had various drawbacks
such as prone to damage, editing problem, data repetition and difficult to manage. Retrieving
data from file-based systems was very tedious and time-consuming task. To overcome the
problems in file-based systems, computerised database system was introduced in 1960s.
Concept of a Database
A database is a structured collection of data that is stored and managed to facilitate easy
access, retrieval, and manipulation. Designed to organise information efficiently, databases
enable users to quickly find and utilise the data they need. They support various operations,
including querying, updating, and managing data, while ensuring accuracy, security, and
consistency. This structured approach to data management makes databases essential
tools for a wide range of applications, from business systems to online platforms.
Computerised data collection and manipulation systems have replaced the conventional
record keeping systems by using application programs. The various components of the
computerised database system are logically interconnected, making data access more
straightforward and efficient.

