Page 91 - TP_iPlus_V2.1_Class7
P. 91

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 will be created.
                     Info Byte

                     Templates are built-in database formats designed for specific tasks. They can be used
                     instantly or downloaded.




                  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 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 can store up to approximately one gigabyte of text but
                                           only displays the first 64,000 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, such as
                  and Embedding)           Word, Excel, or PowerPoint.


                                                                                                                  89
                                                                            Database and DBMS—An Introduction
   86   87   88   89   90   91   92   93   94   95   96