Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
EPPM 1113/EPPD 1063
Computer Applications
LAB TEST 2
December 2024/
This question paper consists of 5 sections. Please answer all sections.
Total mark for this paper is 60 marks.
SECTION 1 (20 marks)
· Open a file in Microsoft Access and save it as your matric number.
· Create a new table and name the table as Friend Details. This is a personal database of greeting cards sender and whether they sent you a card or not and whether you sent them a card or not.
· The fields should be: CardID, First Name, Last Name, Street, City, State, Postcode, Send Me a Card 2024, Send a Card 2025, Postage Cost and Number in Family.
· Add these data to the table:
o C001, Adam Ahmad, 984 Jalan Duta, Ayer Keroh, Melaka 48592, no, yes, 0.80, 5
o C002, Lim Sze Sian, 48 Jalan Majidee, Johor Bahru, Johor 85603, yes, no, 1.50, 9
o C003, Rahim Ahmad, 23 Jalan Bunga Raya, Kluang, Johor 86500, yes, no, 0.40, 3
o C004, Samsiah Daud, 65 Jalan Semantan, Jasin, Melaka 45633, yes, yes, 0.60, 6
o C005, Kamala Dewi, 75 Jalan Cempaka, Muar, Johor, 87500, yes, no, 0.20, 4
o C006, Fazilah Rahim, 3 Jalan Melati, Nilai, Negeri Sembilan, 65400, yes, no, 0.70, 3
o C007, Raina Jalil, 54 Jalan Bintang, Alor Setar, Kedah, 45800, yes, yes, 0.90, 4
o C008, Masyitah Ahmad 66 Jalan Restu, Miri, Sarawak, 98000, yes, yes, 0.80, 4
o C009, Hamdi Rahim, 15, Jalan Anggerik, Pekan, Pahang, 04560, yes,no, 0.70, 3
o C010, YourFirstandLastName, YourAddress, YourState, YourPostcode, and leave the other fields empty.
· Add 15 records to the table (Create your own records). So the total records is 25.
· Create 2 more tables with the title:
i. Work Profile.
These are the fields: WorkProfileID (set this as Primary Key), Designation, Workplace and Working Since.
Then, add these data to the table and add another 15 to match your own data, so you have 25 data altogether for this table. For the WorkProfileID column, please create your own ID number.:
o Finance Executive, MP Sdn Bhd, 2000
o Marketing Executive, Berjaya Sdn Bhd, 1998
o Sales Executive, Mutiara Holdings, 1997
o IT Executive, Prodata Sdn Bhd, 2003
o Sales Manager, Mutiara Holdings, 1990
o IT Executive, Berjaya Sdn Bhd, 2006
o Marketing Executive, Prodata Sdn Bhd, 2001
o Finance Manager, Impian Enterprise, 1994
o Sales Executive, MP Sdn Bhd, 1998
o General Manager, Impian Enterprise, 2005
ii. History Profile.
These are the fields: HistoryID, Relation History, Place Name, Years of Relation
Add the data below to the table and add another 15 to match your own data, so you have 25 data altogether for this table. For the HistoryID column, please create your own HistoryID number:
o School, SM Sri Cendana, 30
o School, SM Sri Cendana, 30
o University, UKM, 8
o Workplace, Prodata Sdn Bhd, 7
o University, UKM, 8
o School, SM Sri Cendana, 30
o University, UKM, 8
o Workplace, Prodata Sdn Bhd, 7
o University, UKM, 8
o School, SM Sri Cendana, 30
SECTION 2 (10marks)
· Please create appropriate relationships between the tables.
· Calculate the Average of the Number in Family field
· Calculate the Total of the Postage Field
· Save the database.
SECTION 3 (20marks)
Queries
· Make a query that looks for the values greater than 2 in the Number in Family field. Show all fields in the answer. Save the query with the name YournameQuery1.
· Create a query that looks for all records that have a postage value greater than $0.60 and Years of Relation is less than 10. Show all fields in the answer. Save the query with the name YournameQuery2.
· Create a query that looks for all records that have a Number in Family greater than 3 OR a last name of Ahmad. Show all fields in the answer. Save the query with the Query name YournameQuery3.
· Make a Query that looks for friends who live in the State of Johor and Workplace is Mutiara Holdings. Show all fields in the answer. Save the query with the Query name YournameQuery4.
· Make a Query that looks for friends who work as IT Executive. Show all fields in the answer. Save the query with the Query name YournameQuery5.
SECTION 4 (5marks)
Please create 2 forms from the database and save it as YourNameForm1 and YourNameForm2.
SECTION 5 (5marks)
Please generate 2 reports from the database and save it as YourNameReport1 and YourNameReport2.
ALL THE BEST!