Page 84 - iPro_trackGPT_V5_Class7
P. 84

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.
                         Boost Bits

                   Templates are pre-designed database structures tailored for specific tasks. They can be used
                   immediately or downloaded for convenience, providing a ready-made layout that simplifies
                   database creation and management.



                     DATA TYPES IN ACCESS 2021

                  The data types are used to declare the types of the fields in the database. Access 2021 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 date and time information, like date of birth or
                                                date of joining. The maximum size of the field is 8 bytes.



                    82    TrackGPT iPRO (V5.0)-VII
   79   80   81   82   83   84   85   86   87   88   89