Page 85 - iPro_trackGPT_V5_Class7
P. 85

Data Type                                     Description
                     Yes/No                    It is used in places where the fields can have boolean values. It
                                               can be either True (T) or False (F).

                     OLE (Object Linking       It is used to embed an object created in another application,

                     and Embedding)            such as Word, Excel, or PowerPoint.
                     Hyperlink                 It is used to store links to web pages, websites, files, etc.

                     Lookup Wizard             A  Lookup  Wizard  helps  you  create  a  field  whose  values  are
                                               chosen from the values in another table, query, or list of values.
                                               Lookup field will use the Number data type; if the source field is
                                               Text, the Lookup field will use the Text 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.

                    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.
                 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 records of the table.























                 Design View

                 Design View allows users to define and modify the structure of a table, including field types,
                 properties, etc. 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.




                                                                          Database and DBMS—An  Introduction     83
   80   81   82   83   84   85   86   87   88   89   90