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"