Page 90 - iPlus_Ver_2.0_class_7
P. 90

Creating a Database Using Templates

                  To create a database by using templates, follow the given steps:

                                                                                     3  Select any template
                                                 2  Click on the New option.         from the available list








                     1  Click on the File tab.


















                  A new database with a selected template is created.
                      Info Byte

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



                   i +  DATA TYPES IN ACCESS 2016

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

                            Data Type                                      Description
                      Short Text               It is used to store text. It can have a maximum of 255 characters.
                                               It 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 a 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.


                    88
                         iPlus (Ver. 2.0)-VII
   85   86   87   88   89   90   91   92   93   94   95