Page 90 - iPrime_V2.2_class7
P. 90

TYPES OF VIEWS IN ACCESS

                  There are two types of views in Access: Datasheet view and Design view. We can switch between
                  these two views by clicking on the arrow of the View command in the Views group under the

                  Home tab. We can also use the Design View and Datasheet View buttons located on the right-
                  hand side of the Status bar to switch between two views.
                  Design View

                  In the Design view, the records are not visible. You can only see the field names along with
                  their data types. You can add or delete a field name. The Design view window is divided into
                  two parts:
                      Field Grid Pane: It is used to define the field names and their data types.
                      Field Properties Pane: It is used to set the properties for the fields defined in the table.




                                                                                                     Field grid pane





                                                                                                   Field Properties pane













                                                        Design view
                  Datasheet View

                  By default, Access names the first field ID and sets it as the Primary Key with the AutoNumber
                  data type, which means Access will automatically create a unique number for each record.























                                                              Datasheet view



                  88     Touchpad iPRIME (Ver. 2.2)–VII
   85   86   87   88   89   90   91   92   93   94   95