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

