Page 304 - IT 402 v2.0 class 10
P. 304

Step 14:  lick on the radio button of   reate report now  option.

        Step 15:  lick on the  Finish  button to generate the report.

        Step 16:  o take a hard copy of the report  click on the printer icon from the Standard  oolbar.
        Inserting Date and Time

         fter creating the report  we can add different types of fields
        from the Insert menu in the report.  et us add date and time
        in the report. Perform the following steps to add date and
        time in a report:

        Step 1:  Open a report in  esign Mode.
        Step 2:   Place the cursor at the place where we want to add
                 the date and time.

        Step 3:   Click on the Insert menu from the menu bar.

        Step 4:   Hover the mouse pointer on the Fields option.
        Step 5:   Select the  ate or  ime option.  urrent date or time
                 will be inserted on the report.



            Recap Zone


                 database is defined as an organised collection of data that can be visualised as a container of
              information. The data is processed and interpreted to the real aspects to support processes that
              require this information.

               A database management system is a software package that controls the creation, maintenance and
              use of a database.

               Database servers are dedicated computers that can hold the actual databases. It can run only the
                MS and its related software.

               Data integrity implies validation of data. The database management system ensures that only valid
              data can be entered into the database.

               A table is a collection of logically related records. The multiple records of a database are arranged
              together in a tabular structure to make a table.
               A call or a request to generate some information from the tables is called query. It is the basic tool
              for retrieving information from the database.
                rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field and
              it cannot be left blank.
                i ards are the predefined format which already exist in the package.  his option provides the
              facility that enables the user to select a category  re uired fields from predefined tables and to set
              type, formats and primary key and create a table.
               Sorting means to arrange the data of a table in a particular order like in ascending or descending order.
               here are two options for sorting records of a table:  Sort  scending  and  Sort  escending .
               Field level data validation ensures that the data entered in a particular field is correct and valid.
               Forms enable to provide a user interface for entering of data or to display intermediary information.
              In the Form, the user can add or modify data.



         302       Touchpad Information Technology-X
   299   300   301   302   303   304   305   306   307   308   309