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
   75   76   77   78   79   80   81   82   83   84   85