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

Step 3:  In the Function row, click to open the drop-down list and select the option Group.

            Step 4:  In the next column  select and use the field on which information is re uired  which in this case is
                    Quantity.

            Step 5:  In the Function row, click to open the drop-down list and select the option Sum.










                                                                                 5



            Step 6:  Press Ctrl + S keys to save the query.

            Step 7:  Double-click on the query name to run the query.
                    Notice that the sum of number of items in each category is shown upon execution of the  uery.










               FORMS

            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.
            In   ase   there are two options to create a form:   reate Form in  esign  iew...  and   se  i ard to  reate Form... .

            Create Form in Design View...

             o create form in design view:

            Step 1:   lick on the  Forms  icon from the   atabase  window.

            Step 2:   ouble-click on the option   reate Form in  esign  iew ....  option.




                      Click here to
                     ‘Create Form in
                     Design View...’.




                            Forms icon













                                                                                  Database Management          285
   282   283   284   285   286   287   288   289   290   291   292