Page 89 - iPrime_V2.2_class7
P. 89

Tech Funda



                       To save the changes in the database, press Ctrl + S keys or select the Save option
                       from the File tab.




                 Clickipedia


                   Templates are the inbuilt format of databases that focus on the specific task. These can be
                   downloaded or used instantly.



                     DATA TYPES IN ACCESS 2016

                 The data types are used to declare the type of the fields in the database. Access 2016 provides
                 the following data types:
                        Data Type                                        Description

                 Short Text                It is a text data type that can store up to 255 characters but cannot be
                                           used for numeric calculations.

                 Long Text                 It is used to store a large amount of text or a combination of text and
                                           numbers. It stores up to 63,999 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 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 values. 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
                 and Embedding)            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 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.





                                                                           Database and DBMS—An Introduction       87
   84   85   86   87   88   89   90   91   92   93   94