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.
Friday, June 7, 2013
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:
Step in producing Query:
Step in creating Report:
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:
- Select the table you want to use as a form.
- Choose Create - Forms - Form
- Sort Field in the desired order by dragging to a specific part.
- Column size can be changed at will.
- Assign a name to the Form and Save.
Step in producing Query:
- Choose Create - Query Wizard
- Then select Simple Query Wizard - ok
- 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.
- Click Next. Name Query created. Click Finish.
- Query finished created for reference.
Step in creating Report:
- Select Table to be used in the Report. Choose Create - Report.
- Report can be formatted according to the requirements.
Subscribe to:
Posts (Atom)