Page 41 - TP_Prime_V2.2_Class8
P. 41

Data Type                                         Description

                  AutoNumber               It  stores a sequential number  automatically  for  every record
                                           added to a table. The maximum size of the field is 4 bytes.

                  Date/Time                It is used to store the  information  like date  of birth, date of
                                           joining, etc. The maximum size of the field is 8 bytes.


                  Yes/No                   It is used in places where the fields can have boolean value. It can
                                           be either True (T) or False (F).                                                 WORKING WITH ACCESS 2016

                  OLE (Object Linking  It is used to embed an object created in another application such
                  and Embedding)           as Word, Excel or PowerPoint. The maximum size of the file is 2 GB.

                  Hyperlink                It is used to store the 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           39
                                           default, Access sets the Lookup fields to the Number data types.

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

















                                                            Datasheet View
   36   37   38   39   40   41   42   43   44   45   46