Page 91 - iPlus_Ver_2.0_class_7
P. 91

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 View command under the Views group on 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.
                 Datasheet View

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





















                 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






                                                                                                                  89
                                                                            Database and DBMS—An Introduction
   86   87   88   89   90   91   92   93   94   95   96