Week 14: Form, Query, Report and Relationship

For this final week of face to face interaction, our group tried to complete our Project task by creating Form, Query and Report for our database.
 
Form:

•  to save time when we try to input data into one or more table

•  This is how it should look like in the Microsoft Access

Step by step:

1. In the navigation panel, select the table or query you want to use to generate the form.
2. Choose Create➝Forms➝Form.
3. Arrange the fields in the order you want by dragging them around.
4. Change your columns’ widths or anything of the layout to your likings
5. Save your form. File➝Save.

For a detailed tutorial on creating form, click on this TUTORIAL: FORM


Query: 

• to request a data results to suply data for a form or report

  
Step by step:
    1. Open your database.
    2.  Switch to the Create tab.
    3.  Click the Query Wizard icon.
    4.  Select a Query Type. 
    5.  Select the appropriate table from the pull-down menu.
    6.  Choose the fields you wish to appear in the query results.
    7.  Repeat steps 5 and 6 to add information from additional  tables, as desired.
    8.  Click on Next. Choose the type of results you would like to produce.
    9.  Click on Finish. For a detailed tutorial, click on this TUTORIAL:QUERY
 

Report: 

•  to view what have been requested using Query

 Step by step: 

1. Choose the Reports menu
2. Create a new report - click on "Report Wizard"
3. Choose a table or query.
4. Select the fields to include.
5. Select the grouping levels.
6. Choose your sorting options.
7. Choose the formatting options
8. Make sure that the “Preview the report” option is selected and click on Finish to see our report!

  For a detailed tutorial, click on this TUTORIAL : REPORT



Relationship: 

• to track relationships between data elements

 Step by step:  

Database tool  > Relationship > Choose appropriate table

For a detailed tutorial, click on this TUTORIAL: RELATIONSHIP