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 !!!

Wednesday 28 March 2012

CORRECTION FOR EXCEL ASSIGNMENT


Click here for the revised version for excel assignment

Due date for this assignment is extended until 10 April 2012 not 4 April. Finish your powerpoint first for next week presentation. All the best. For those who already send your work you can revised your work and send again your task to the correct email.

Upload in your blog and send a copy to:  eppd1063set1@gmail.com

Attention: Make sure you email your assignment using the software you used to create the documents like word for microsoft word assignment and excel for microsoft excel assignment. Don't send me the pdf file.

Monday 26 March 2012

UPDATE YOUR BLOG (2)

 
May Allah bless Us All
Hope all of you are in a good health. Today blog update instruction:
Find a video clips in YouTube or what ever media regarding your topics (topic for newsletter assignment) and paste into your blog. At least one video or more.

For those who still don't start blogging or update your blog, start now. Now is week 6.

Good Luck and All the Best.


HOW TO CREATE AND EDIT VIDEO

First you need to record your video using either webcam, camera or your hand phone. Make sure the video you want to post on your powerpoint is .wmv types. When your video is in that format you can directly put in your presentation.

If your video is in different format you must convert it using video converter. You can find the converter from the internet. If you want to edit you video, one way is through youtube editor. When you already have the video you must create your account in youtube and then upload the video there. After uploading you can still edit the video. Following is on how to do so. Good Luck.





Power Point Task: CREATE YOUR OWN VIDEO

Assalamualaikum and hi everyone, This week you will learn about powerpoint presentation. The topic for your powerpoint presentation assignment is same with the topic for your newsletter.


Your presentation must consists of at least 10 pages (more than 10 is accepted).

Your presentation must have all this elements:
 
Text
Sounds
Slides Transitions
Pictures /Graphics
Shorts movies/ videos
Slides Number
Animation
Background
Chart
Charts
Link or hyperlink

Custom Animations
Tables


**For videos, I want you to create your own video. For example for the fist or second slide you put your video introducing your name and the title of you presentation. The video duration should be no more then one minutes. Beside this you also can add other video related to your topic.


EVALUATION:

Marks will be given according to:

  • The contents (must be informative)
  • The creative layout and style of the presentation 
  • The elements in Microsoft PowerPoint
SUBMISSION:



Your Due date presentation is on 3 March 2012


BLOG: In your own blog, please upload your video (1 file) and your PowerPoint presentation file (1 file) in two separate blog entries.

EMAIL: Please don't forget to email a copy of your assignment.
to the email: eppd1063set1@gmail.com after presentation.







VIDEO FOR VLOOKUP IN EXCEL 2007

See This:








Vlookup in separate workbook and in saperate worksheet:

Sunday 11 March 2012

LIST OF STUDENTS BLOGS

The name highlight with yellow colour mean your blog is not registered or wrongly registered or cannot open. So you need to registered again with the correct address.


 Bil
 No.Pend
 Nama
URL BLOG
 1
A133457
 NOOR FARHANA BINTI ABDUL NASIR
 2
A133489
 MUHAMMAD AZLAN BIN ZAINAL
 3
A135905
 SUHAILI BINTI SUBAIRA
 4
A135909
 NIK NOOR SYAHIRA WAHIDA BINTI MUHAMAD
 5
A135962
 FATIN ZETISYAKILA BINTI MD YUSOF
 6
A135985
 NURUL MALYANA BINTI SAHLAN
 7
A135991
 MUHAMAD SYAHAM BIN SUZMIN
 8
A136005
 NURUL NUR ASYIKIN BINTI GHAZALI
 9
A136016
 NOOR AMIRAH BINTI YUSOF
 10
A136020
 SITI AZMIRA BINTI SUKIYAT
 11
A136041
 NUR HIDAYU BINTI HALIM
 12
A136060
 KONG XIN LIN
 13
A136262
 NURZATIL IZZATI BINTI SALEH
 14
A136286
 NURUL FAIZAH BINTI ISMAIL
 15
A136344
 EE LI XIA
 16
A136393
 NURIN HAZIRAH BINTI OTHMAN
 17
A136501
 NADHILAH BASIRAH BINTI ABDUL RAZAK
 18
A136544
 ANN NUR BINTI JOHN
 19
A136552
 FAIQAH BINTI ABDULLAH
 20
A136559
 HANDRIERISYANO BIN SATE
 21
A136573
 TEH BOON CHIANG
 22
A136577
 SITI NURUL NAJIHAH BINTI AUZAR
 23
A136581
 NOR AZIRA BINTI NGADENAN
 24
A136591
 PUTERI NAQUIAH NADHIRAH BINTI YUSRI
 25
A136605
 BRENDA ALPEUS
 26
A136607
 NORHAPIZAH BINTI ISMAIL
 27
A136610
 NURUL AMIERA DYANA BINTI ZAINUDDIN
 28
A136612
 NUR ANEESA BINTI SUHAIMI
 29
A136613
 NIK ATHIRAH ILLANI BINTI NIK WAN
 30
A136631
 NORAFIQAH BINTI JAMIL
 31
A136681
 RUZANNA BINTI ABD KADIR
 32
A136704
 NUR ALIAH BINTI MOHD SUKERI
 33
A136784
 NORHALIZA FARIDA BINTI SULAIMAN
 34
A136789
 ROZILAWATI BINTI RAMLI
 35
A136846
 NOR SURYATI BINTI AIRUDDIN @ DIN
 36
A136888
 NURULFARIDAH BINTI M. MAZLAM
 37
A136943
 MUHAMMAD NOR SHAFIQ BIN SHAFARUDIN
 38
A136995
 NORASHIKIN BINTI TALKAH
 39
A137008
 RADHIAH BINTI KHALID
 40
A137037
 NOR SYAMILA BINTI MOHD MOHKHERI
 41
A137051
 SITI FATIMAH BINTI ABDUL MUTALIB
 42
A137082
 HO MUN YEE
 43
A137458
 SHUHAIDA BINTI SAMAT
 44
A138732
 ICBAL WIJAYA LESMANA