Page 92 - TP_iPlus_V2.1_Class7
P. 92

Data Type                                        Description
                   Hyperlink                It is used to store links to web pages, websites, files, etc.
                   Lookup Wizard            A Lookup Wizard helps you to create a field whose values are chosen
                                            from the values in another table, query, or list of values. By default,
                                            Access sets the Lookup fields to the Number data type.
                   Currency                 It is used to store currency values.
                   Attachment               It  is  used  to  store  attached  images,  spreadsheet  files,  documents,
                                            charts, and other types of supported files.

                   i +  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



                  Datasheet View

                  Datasheet view is the default view of the table. It displays all the fields and the records as entered
                  by the user. In this view, you can edit the content of the table.























                    90
                         iPlus (Ver. 2.1)-VII
   87   88   89   90   91   92   93   94   95   96   97