Page 40 - TP_Prime_V2.2_Class8
P. 40

Creating a Database Using Templates


                  Perform the following steps to create a
                  database by using templates:

                  Step 1:  Click on the File tab.
           Prime (Ver. 2.2)-VIII  Step 3:  Select  any  template  from the
                  Step 2:  Select  the  New  option. The
                            available templates appear.



                            available  list.  A new database

                            with
                                    selected
                                                              is
                                                 template
                            created.
                                                                             Creating a Database using Templates

          38                                                  Soft Hint


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






                          Fun             Templates  are the inbuilt format of databases  that focus on the
                          Fact!
                                        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 large amount of text or a combination of text

                                            and number. 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.
   35   36   37   38   39   40   41   42   43   44   45