Page 22 - Code & Click - 8

3 Introduction to Access 2016

Pre-Processing
Pre-Processing
• Database Management System (DBMS) • Microsoft Access 2016
• Components of Access 2016 Window • Database Objects
• Working with Databases • Working with Tables

• Sorting Records in a Datasheet • Design View in Access
• Components of Design View • Working with Tables in the Design View

Microsoft Access is a database creation and management software which allows you to store and
manage large amount of data efficiently.
DATABASE MANAGEMENT SYSTEM (DBMS)
A database is a collection of processed information related to a particular topic or
purpose so that it can be easily accessed, managed, and updated. For example, a
school maintains a database of students containing information about their admission
number, name, date of birth, address, class, mode of transportation, and fee details.
A database can be manual or computerised.
Manual Database is the simplest and most common type of database. It
consists of paper records, folders, and filing cabinets. Some examples of manual
databases are students’ progress reports, Diaries, Atlases, Dictionaries, and
Encyclopedias.
Computerised Database is a soft copy of information in the form of electronic
files stored on a hard disk or other storage media. Some examples of
Computerised database are Aadhaar database and Indian Railways’ database.
Databases touch all aspects of our lives. Databases are used by:
• Telecom companies to keep track of the information regarding calls made, network usage,
customer details, etc.
• Industries to keep records of raw material used, units produced, and production schedules.
• Banks to store customer information, track day-to-day credit and debit transactions, and
generate bank statements.
• Education sector to store and retrieve the data regarding details of students, staff, attendance,
courses, exams, and payroll data.
• Online shopping sites to store the information regarding products,
customers, and payments.
A Database Management System (DBMS) is required to maintain and access
a computerised database.
DBMS is a software that enables the user to create a database and add,
modify, and delete data in it. It provides an interface that is both convenient
and efficient to use.

20