Page 94 - iPrime_V2.2_class7
P. 94

Step 3  Select the required database from the Open dialog box.

                  Step 4  Click on the Open button. The selected database gets opened.























                                                       Opening an existing database

                           Tech Funda



                         The shortcut to open an existing database is Ctrl+O keys.




                      EXITING ACCESS 2016
                  To exit from MS Access 2016, follow these steps:

                  Step 1  Click on the File tab.
                  Step 2  Click on the Close option. It closes the database currently opened.
                  Step 3  Click on the Close button at the top-right corner. The Access Window will exit.


                    Reb            t


                        A collection of programs required to store and retrieve data from a database is called
                       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.
                        The final result of the manipulated data that comes from tables or queries in DBMS is
                       known as the report.
                        A form is a database object used to create a user interface to enter or update a record in
                       a table that is connected to it.





                  92     Touchpad iPRIME (Ver. 2.2)–VII
   89   90   91   92   93   94   95   96   97   98   99