Page 89 - iPro_trackGPT_V5_Class7
P. 89

Closing Database

                 After completing the work, you need to close the database. To close the current database, select
                 the Close option from the File tab.


                                   If a database is like a treasure chest and you're the treasure keeper, how would
                                   you organise and store your precious items to make sure you can find them
                                   easily when needed?



                    OPENING AN EXISTING DATABASE

                 To open an existing database, follow the given steps:                1  Click on
                                                                                      the File tab.




                     2  Select the Open option.                         5  Select the database.






















                                                               4  Navigate to the location where   6  Click on the
                           3  Click on the Browse option.     you have saved the database.         Open button.


                    EXITING ACCESS 2021

                 To exit from MS Access 2021, Click on the Close         button at the top-right corner to exit the
                 Access window.






                        A collection of programs required to store and retrieve data from a database is called a
                       Database Management System (DBMS).
                       There are mainly two types of database—Flat File Database and Relational Database.
                       Table is a group of related data organised in columns and rows in a database.
                       A set of values for the fields is called a record.
                       Primary key is a unique field by which the records are uniquely identified in a table.
                       Query allows you to retrieve information from a table based on some criteria or condition.




                                                                          Database and DBMS—An  Introduction     87
   84   85   86   87   88   89   90   91   92   93   94