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

Week 13: Microsoft Access 2010

 

What is it for?

Access is a database tool for gathering and understanding all information such as phone numbers, inventory, guest lists or whatever that we're tracking—and providing a convenient way to enter, navigate, and report out the data.

As for this week, we learnt that Microsoft Access 2010 stores all database tables, queries, forms, reports, macros, and modules in the Access Jet database as a single file. However, for the purpose of this subject, En. Razak said that we limit ourselves on creating database on tables, queries, forms and reports only.

As to what I gathered on what have been tolf in class, the use of each database are as follows:

• Tables: to add / edit / delete raw data  
• Form:  to create a more user-friendly for entering data
• Query:  a request for data results to supply data for a form or report
• Report: To view on what have been requested using Query.

As for this week, my groupmates and I have completed our individual part of creating Table that consists of data on the lists of book and non-book materials that we have completed in Assignment 1. 

En Razak asked us to develop 2 types of tables to be used in later stage. The extract of tables created are as follows:

Table 1: Material Data

Table 2: Publication table

Video tutorial on how to create Table using Microsoft Access 2010 can be obtained here:  

http://www.youtube.com/watch?v=Zyj5dCeO0so