Page 27 - ModularV1.1 _c8_flipbook
P. 27

DATA TYPES IN MS ACCESS 2010

                 The data types are used to declare the type of fields in the database. MS Access 2010 provides
                 the following data types:

                       Data Type                                         Description

                  Text                    It is used to store text. It can have maximum of 255 characters. It cannot
                                          be used for numeric calculations.

                  Memo                    It is used to store large amount of text or a combination of text and
                                          number. It stores up to 65,536 characters.

                  Number                  It is used to enter numerical values and perform numerical calculations.
                                          The maximum size of the Number field is 16 bytes.

                  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).

                  OLE (Object Linking  It is used to embed an object created in another application such as MS
                  and Embedding)          Word, MS Excel or MS 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  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.

                     RULES FOR WRITING A FIELD NAME IN MS ACCESS


                 Following rules you should remember while writing field names:

                    Field name can be up to 64 characters long.
                    Field name can include any combination of letters, numbers, spaces, and special characters
                    except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).

                    Field name cannot begin with the leading spaces.

                    Field name cannot include a double quotation mark (").





                                                                                   Introduction to MS Access 2010  25
   22   23   24   25   26   27   28   29   30   31   32