COMPUTER APPLICATION - EPPD1063 SET 1(Norazila Mat)
"Learning is finding out what we already know. Doing is demonstrating that you know it. Teaching is reminding others that they know just as well as you. You are all learners, doers, and teachers." -- Richard Bach
Saturday 29 August 2015
Wednesday 23 May 2012
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)
- Identify the specific types of business you want to develop the database.
- Mention the purpose of your database.
- Design on paper 5 main table and their field for this database. Each table must have at least 6 fields.
- Explain how you will do the relationship for your tables.
- Bring your group proposal contain this information’s for your lecturer approval on third week access class.
- 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)
- 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)
- For the main table, the record must be more than 10 record. (10 marks)
- Create the relationship between tables. (5 marks)
- Then create 5 queries. (5 marks)
- 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)
- Create 5 reports .(5 marks)
- Create 1 start-up page (5 marks)
- Create 1 switchboard (MIN 10 BUTTON: 5 BUTTON FOR FORM AND 5 FOR REPORT) (5 marks)
- Your database must have calculation in form and in queries. (5 marks)
- 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)
Labels:
Announcement,
Blog Instructions,
Reminder,
Students Blogs
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 !!!
Subscribe to:
Posts (Atom)