Week 15 (Reflection) 22 May 2013

          Today is our last lesson where we get to learn about form, query, report and relationship.
The form will help us save a lot of time when entering data into the table. Below are the step in producing Form:

     (a) Select the table you want to use as a form.
     (b) Choose Create - Forms - Form
     (c) Sort Field in the desired order by dragging to a specific part.
     (d) Column size can be changed at will.
     (e) Assign a name to the Form and Save.


          Query displays the results of collection of raw data before we generate the report. Below are the step in producing Query:

 

     (a) Choose Create - Query Wizard
     (b) Then select Simple Query Wizard - ok
     (c) 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.
     (d) Click Next. Name Query created. Click Finish.
     (e) Query finished created for reference.

 

          The report is to display the database reports that had been produced. Below are the step in creating Report:

     (a) Select Table to be used in the Report. Choose Create - Report.
     (b) Report can be formatted according to the requirements.