Page 89 - Trackpad_ipro 4.1_Class7
P. 89

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



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


                     DATA TYPES IN ACCESS 2019
                 The data types are used to declare the types of the fields in the database. Access 2019 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).



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