Page 17 - Code Craft Computer-8

Let's Know about
2 MS Access 2021

Core Concepts

On completion of this chapter you will be able to know:
¨ Exploring Databases ¨ Features of database
¨ Database management systems (DBMS) ¨ Advantages of DBMS

¨ Database applications ¨ Disadvantages of a DBMS
¨ Introduction to MS Access 2021 ¨ Objects in MS Access
¨ Starting MS Access 2021 ¨ Parts of the MS Access 2021 window
¨ Creating a Database ¨ Creating a table using templates
¨ Opening an existing Database ¨ Closing a database in Access

Warm Up #Art Integration

Draw and colour the icon of MS Access 2021 in the space given below.

EXPLORING DATABASES
Database is a collection of inter-related data which helps in efficient retrieval (taking out
information) insertion and deletion of data from the database and organises the data in the form of
tables, views, reports, etc. Let's discuss a few examples:

• An online telephone directory would use a database to store data pertaining to people, their
phone numbers and their other contact details, etc.
• Your electricity service provider is using a database to manage billing, client-related issues,
to rectify the faulty data, etc.

• A school's database organizes data about students, teachers and admin staff, etc.

FEATURES OF DATABASE
Look at the given example of database. It has four fields, namely, Roll No., Name, Class, and
Marks.

17