![[SOLVED] MICROSOFT ACCESS LAB TEST 2 Semester 2 2014-2015 Matlab](https://assignmentchef.com/wp-content/uploads/2022/08/downloadzip.jpg)
LAB TEST 2
MICROSOFT ACCESS
May 2015
Semester 2 (2014-2015)
2.5 Hours
Lab Test 2 – Microsoft Access
Please create Microsoft Access file, named with your Matric Number (example – A123456). Please follow the instruction that being given inside this questions. Please name your “Table”, “Query”, “Form”, “Report” and “Button” with the right and suitable name. Please submit 2 items in the end of the Lab Test, 1) Microsoft Access file, and 2) “Switchboard Drawing” (hand-written).
1) Create 4 “Table” with the given data below:
i – Personal
|
ID_A |
Name |
ID_B |
ID_C |
Address |
|
A001 |
MUHAMMAD FARID ABDUL AZIZ |
B001 |
C001 |
3A-7, Tingkat 4, Blok A, Jalan Perdana, CBD Perdana, 63000 Cyberjaya, Selangor |
|
A002 |
ABDUL MUIZ SHAMSUL BAHARI |
B002 |
C001 |
Lot 133, Jalan Pukal, Kawasan LPJ, Pasir Gudang, 81700 Johor |
|
A003 |
SAIFULLAH MUHAMMAD ALIAS |
B003 |
C002 |
No 8, Jalan SS21/39, Damansara Utama, 47400 Petaling Jaya, Selangor |
|
A004 |
NURUL AIN ABDUL LATIF |
B001 |
C002 |
2790, Jalan Changkat Permata, Taman Permata, 53300 Kuala Lumpur |
|
A005 |
NUR SYAFIQAH MUSTAFFA |
B002 |
C003 |
7A, Jalan TTJ S/A, Taman Tunku Jaafar, 71450 Seremban, Negeri Sembilan |
|
A006 |
CHAN WAI YAN |
B003 |
C002 |
Kg. Padang Panjang, Jalan Bukit Wang, 60000 Jitra, Kedah |
|
A007 |
YUGENDRAN A/L KUMAR |
B003 |
C003 |
No 6, Jalan Panglima 2, Taman Panglima, 75400 Bukit Serindit, Melaka |
|
A008 |
KISHANTRAN A/L MISWARAN |
B001 |
C003 |
Jalan Damai 1, Janda Baik, 28750 Bentong, Pahang |
|
A009 |
MUHAMMAD LUTHFI JOHAN |
B002 |
C002 |
AL 97, Lot 2781, Jalan Kg. Baru, 47000 Sg.Buloh, Selangor |
|
A010 |
SHAFIQ HAIKAL JOHARI |
B001 |
C001 |
Lot 9895, Jalan Kampung Jawa, Seksyen 35, 40470 Shah Alam, Selangor |
|
A011 |
AINA SYUHADA ABDUL GHAFUR |
B001 |
C001 |
No 2, Jalan Astaka U8/84, Seksyen U8, 40150 Shah Alam, Selangor |
|
A012 |
FARAH NATASYA KAMARUL |
B002 |
C002 |
Lot 16, Jalan Sementa 27/92, Seksyen 28, 40000 Shah Alam, Selangor |
|
A013 |
SHAFIRAH AHMAD |
B003 |
C003 |
No 5, Jalan USJ 2/7, UEP Subang Jaya, 47600 Subang Jaya, Selangor |
|
A014 |
MUHD AZROL MOHD ARIFFIN |
B004 |
C004 |
25-32, Jalan Kuala Kurau, 34200 Parit Buntar, Perak |
|
A015 |
SITI SYAKIRAH MUHD KAMAL |
B001 |
C001 |
247, Jalan Pekeliling, 81700 Pasir Gudang, Johor |
|
A016 |
SYARIFAH SHAHIRAH SYED RASUL |
B002 |
C002 |
23, Putera Jaya, Bandar Permaisuri, 22100 Setiu, Terengganu |
|
A017 |
ABDUL HAKIM ABDUL RAHMAN |
B003 |
C003 |
203, Jalan Pasir Puteh, 31650 Ipoh, Perak |
|
A018 |
FAHRIN AHMAD MUHD ZAMREE |
B004 |
C004 |
1528, Jalan Hospital, 15200 Kota Bharu, Kelantan |
|
A019 |
KHAIRUL AZHAR RIDHWAN |
B003 |
C004 |
248, Jalan Pekeliling, 81700 Pasir Gudang, Johor |
|
A020 |
WONG SIEW FANG |
B004 |
C004 |
No. 13, Jalan IM3/7, Bandar Indera Mahkota, 25200 Kuantan, Pahang |
ii – Income
|
ID_B |
Salary |
Allowance1 |
Allowance2 |
|
B001 |
3000 |
500 |
200 |
|
B002 |
2900 |
250 |
150 |
|
B003 |
2800 |
100 |
100 |
|
B004 |
2700 |
50 |
50 |
iii – Expenses
|
ID_C |
ID_D |
Expense1 |
Expense2 |
|
C001 |
D001 |
60 |
60 |
|
C002 |
D002 |
30 |
30 |
|
C003 |
D003 |
15 |
15 |
|
C004 |
D004 |
10 |
10 |
iv – Addition
|
ID_D |
Add1 |
Add2 |
Add3 |
|
D001 |
40 |
455 |
700 |
|
D002 |
35 |
453 |
800 |
|
D003 |
49 |
543 |
850 |
|
D004 |
99 |
555 |
530 |
2) Build suitable “Relationship” which connects all “Table” that you have created. Please make sure the right “Primary Key” being used.
3) Create 4 “Query” with the details below:
i – Full_Data (should have these data: Name, ID_A, ID_B, ID_C, ID_D, Address, Salary, Allowance1, Allowance2, Expense1, Expense2, Add1, Add2 and Add3)
ii – Income_Data (should have these data: Name, ID_A, ID_B, Salary, Allowance1 and Allowance2) – should have a suitable “Calculation” for Total_Income
iii – Expenses_Data (should have these data: Name, ID_A, ID_C, ID_D, Expense1, Expense2, Add1, Add2 and Add3) – should have a suitable “Calculation” for Total_Expenses
iv – Balance (should have these data: Name, ID_A, Total_Income and Total_Expenses) – should have a suitable “Calculation” for Total_Amount
4) Create 4 “Form” with the details below:
i – Personal ii – Income iii – Expenses iv – Addition
5) Create 4 “Report” with the details below:
i – Full_Data ii – Income_Data iii – Expenses_Data iv – Balance
6) Create “Switchboard” with the details below:
i – “Startup Page” (Please make sure your “Startup Page” is functioning)
ii – “Main Menu” iii – “Form” (Add Mode) iv – “Form” (Edit Mode) v – “Report”
Reviews
There are no reviews yet.