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.
   30   31   32   33   34   35   36   37   38   39   40