Thursday, 3 May 2012

ACCESS ASSINGMENT



TO BE PRESENTED IN CLASS ON WEEK 14 (FINAL WEEK)
ACCESS ASSINGMENT: (70 marks)

This is a group project for no more than 4 people. In this project, your group need to develop a database system using MS Access for one small business company. Start your project by preparing a proposal to get the approval from your lecturer. Information in the proposal must have. Prepare and submit your proposal next week (8 mei) during class:

Proposal Requirement: (10 marks)
  1. Identify the specific types of business you want to develop the database.
  2. Mention the purpose of your database.
  3. Design on paper 5 main table and their field for this database. Each table must have at least 6 fields.
  4. Explain how you will do the relationship for your tables.
  5. Bring your group proposal contain this information’s for your lecturer approval on third week access class.
  6. When you get the approval you can continue with your project.
What need to be included in the database system? You must include at least (this is min requirement. You can create more than this).
Database System Requirements: (60 marks)
  1. 5 main tables (include all what you have learn about design table eg: field name, data types, description and field properties. For data types, please include all types of data eg: date, currency, yes/no, lookup wizard, OLE object, hyperlink, attachment, text, memo, auto number) (10 marks)
  2. For the main table, the record must be more than 10 record. (10 marks)
  3. Create the relationship between tables. (5 marks)
  4. Then create 5 queries. (5 marks)
  5. Create 5 forms using different style eg: form and sub form. Include command button in form to link to other form and to the switch board. (10 marks)
  6. Create 5 reports .(5 marks)
  7. Create 1 start-up page (5 marks)
  8. Create 1 switchboard (MIN 10 BUTTON: 5 BUTTON FOR FORM AND 5 FOR REPORT) (5 marks)
  9. Your database must have calculation in form and in queries. (5 marks)
  10. Design and format all your forms and reports nicely by including the same header and footer. (5 marks)

Wednesday, 25 April 2012

UPDATE YOUR BLOG (3)

Assalamualaikum and good day everyone. It times to update your blog. It have been quite sometimes since the last time I remind you to update your blog. Now you are in your 8 week for this semester and your blog should have at least 16 posting. For those who still don't do anything better start now because in week 14 you will present your blog in class. Good luck and all the best...

Tuesday, 17 April 2012

Power of Positive Thinking: Which One Are You?

Once upon a time a daughter complained to her father that her life was miserable and that she didn't know how she was going to make it. She was tired of fighting and struggling all the time. It seemed just as one problem was solved, another one soon followed.

Sunday, 15 April 2012

LAB TEST EXAM 1

Hope you all enjoy your holiday. This post just to remind you that:

Tomorrow : Tuesday 17/04/2012
Your: Lab test exam 1
Topic cover: Excel (familiar with all the formulas, like IF, IF+AND, VLOOKUP and others)
                     Word (Mail Merge) & Powerpoint presentation
Where & What time: Same place and same time with your class schedule
How long: Around 2 hours.
What to bring: Your pen drive (storage drive)

GOOD LUCK AND ALL THE BEST !!!