THE INTERNATIONAL UNIVERSITY (IU) – VIETNAM NATIONAL UNIVERSITY – HCMC MID-TERM EXAMINATION Date: 9/11/2021 Duration: 90 minutes
Student ID: ..................................
Name:................................................
SUBJECT: Business Computing Skills (BA120IU)
School of Business Lecturer Signature: Signature: Full name:
Full name: Huynh Vo Trung Dung, Ph.D. GENERAL INSTRUCTION(S)
1. Students will be admitted to the exam venue approximately 5-10 minutes before
the start time and leave the exam venue max. 15 minutes before the end time. You
are not allowed to leave the exam room during the first 30 minutes of working
time, or the last 10 minutes of the exam.
2. Candidates shall open their webcam through MS Teams.
3. This is an open-book exam.
4. ONLY MS-ACCESS application can be opened.
5. The exam contains two parts:
a. Part A: Multiple-Choice Questions (20 marks)
b. Part B: A practical MS-Access exercise doing on the computer (80 marks)
A.Multiple-Choice Questions (20 marks, 20 questions each 1 mark) - Blackboard!
B. MS Access Exercise (80 marks)
Create a database with the name as: Yourfullname, e.g., Nguyentheanh
1. Create 3 Tables as follows: (10 marks) Table 1: Department Department Code Department Name DRD Director Department ADD Administration Department PLD Planning Department ACD Accounting Department MKD Marketing Department PDD Production Department Note:
Department Code: primary key Table 2: Employee Employe Full Name Gender Department Code Labor Union e Code EC01 Huynh Tong Trach Male DRD  EC02 Ho Hanh Nhi Female ADD ⸋ EC03 Duong Di Female DRD  EC04 Ho Dinh Han Female MKD  EC05 Ma Tuan Vy Male ACD ⸋ EC06 Lam Van Long Male PLD ⸋ EC07 Le Dieu Tuong Male PDD  Note:
Employee Code: datatype: primary key Table 3: Salary Month Employee Evaluation Basic Working Insurance of Code Salary Day Salary Jan EC01 A 300,000 25 0.05 Jan EC02 B 200,000 24 0.05 Jan EC03 C 180,000 28 0.05 Jan EC04 D 150,000 23 0.05 Note:
Month of Salary and Employee Code: primary key ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 1-Easy
2. Create a new Multivalued Lookup Field as the last field in the Table 2 that uses
the Department Name field in Department table (10 marks) ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 2-Average 3. Using Queries:
a) Create a Query with a name: P3a, to calculate a salary for each employee. The
query includes the fields as follows (get from Table 3): Month of Salary,
Employee Code, Evaluation, Basic Salary, Working Day, Insurance, Final
Salary; where Final Salary: X*[Working Day]*[Basic Salary] -
[Insurance]*[Working Day]*[Basic Salary] + Y*[Bonus] (10 marks) Notice that:
 If [working day] > 24, [working day]: [working day] + ([working day] – 24)*2
else [working day]: [working day]
 If an employee has an evaluation of A, he will get a bonus of 400,000.
If an employee has an evaluation of B, he will get a bonus of 200,000.
If an employee has an evaluation of C, he will get a bonus of 0.
If an employee has an evaluation of D, he will get a bonus of -100,000.
 X = your date of birth, Y = your month of birth. Example: your
birthday 9 November  X = 9, Y = 11. ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6
Level of Difficulty: 3-Difficult
b) Create a Query with name: P3b to display the salary of each department?
The query includes the fields: Department Code and Department Name (Table 1) T
, otal Salary, where Total Salary is the summation of all
employees’ Final Salary in a department. (10 marks) ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 2-Average
c) Create a Query with a name:
to check which employees do not have P3c
salary calculation yet? The query includes the fields: Employee Code,
Full Name, Department Code from Table 1 (10 marks) ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 2-Average
d) Create a Query with name: P3d to display (10 marks) -
How many male employees joined Labor Union? -
How many female employees did not join Labor Union? -
How many male employees joined Labor Union? -
How many female employees did not join Labor Union?
This query includes the fields: Gender (Table 1), Joined Labor Union,
Did not join Labor Union. ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6
Level of Difficulty: 3-Difficult
e) Create a query with name: P3e to display who has a basic salary >
180,000. This query includes the fields: Full Name and Department
Code (Table 1), Basic Salary (Table 3). (10 marks) ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 2-Average
4. Create a Report with the name: P4 with all fields from Table 2 (10 marks) ACBSP: Knowledge Topic: MS Access Bloom's Taxonomy: Application
Relevant Program Learning Outcomes: PLO6
Relevant Course Learning Outcomes: CLO6 Level of Difficulty: 1-Easy