REFLECTION WEEK 15: PRODUCING FORM, QUERY AND REPORT

Assalamualaikum WBT and Salam Sejahtera,

For this 15th week, members of the group try to complete the tasks given by En. Abd. Razak to produce a database for cataloging materials. Proceed with construction assignments Form, Query and Report after learning and view sample database shown.

Step in producing Form:

1. Select the table you want to use as a form.
2. Choose Create - Forms - Form
3. Sort Field in the desired order by dragging to a specific part.
4. Column size can be changed at will.
5. Assign a name to the Form and Save.

Step in producing Query:

1. Choose Create - Query Wizard
2. Then select Simple Query Wizard - ok
3. Select fields that are involved in queries such as Title, Author, Publisher, Year Published, etc. to be displayed in the Query. Field also choose from different Table.
4. Click Next. Name Query created. Click Finish.
5. Query finished created for reference.

Step in creating Report:

1. Select Table to be used in the Report. Choose Create - Report.
2. Report can be formatted according to the requirements.