Friday, June 7, 2013

REFLECTION WEEK 16: FINAL EXAM, ASINGMENT SUBMITION AND HOOREYY!!!

Assalamualaikum WBT and Salam Sejahtera,

Alhamdulillah on 06/06/2013 I have completed the final exam for this subject and also completed and submitted our cataloging database group asignment to En. Abd Razak. Although the exam questions is quite tough, I still prays to Allah hope En. Abd Razak give A to me..hehe.

           Well, Allhamdulillah because ultimately this is my last semester and means I have completed 4 semesters at UTM. I hope Mr. Abd. Razak has given the best marks for this semester so can I ended successfully. For the last ... Hoorayyy!





Thanks a lot En. Abd Razak.

Tuesday, June 4, 2013

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.