Page 46 - TP_Prime_V2.2_Class8
P. 46

Exiting Access 2016


                  Step 1:  Click on File tab.

                  Step 2:  Select the Close option. This will open a dialog box asking whether to save the
                            changes to the database or not. Click on the Yes button.
           Prime (Ver. 2.2)-VIII  Step 3:  Click on the Close button at the top-right corner. The Access Window will exit.
















                                                                                                      21 st
          44           Warm              Match the following:                                      Century   #Critical Thinking
                                                                                                     Skills
                       Up!               1.  Design View              (i)  stores a sequential number automatically

                                                                         for every record added to a table

                                         2.  AutoNumber               (ii) default view of the table
                                         3.  Short Text               (iii) allows you to add or delete a field name

                                         4.  Datasheet View           (iv)  used to define the field names and their
                                                                          data types

                                         5.  Field Grid Pane          (v) cannot be used for numeric calculations






                                  Let's Revisit

                  •  A collection of programs is 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.

                  •  Access  2016  window has  the various components such  as  Quick Access  Toolbar,
                    Menu bar, Navigation  Pane, and Work Area.

                  •  The data types are used to declare the type of the fields in the database.

                  •  There are two types of views in Access: Datasheet view and Design view.
   41   42   43   44   45   46   47   48   49   50   51