INTERNATIONAL UNIVERSITY-VIETNAM NATIONAL UNIVERSITY–HCMC MIDTERM EXAMINATION
BUSINESS COMPUTING SKILLS – B 1 A 20IU Date: 20 November 2023 Duration: 90’
Student ID: ......................................Name:................................................
SUBJECT: Business Computing Skil s School of Business Lecturer Signature: Signature: Ful name: Ful name: Do Ngoc Hung GENERAL INSTRUCTION(S)
1. Students wil 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 al owed to leave the exam room during the first 30 minutes of
working time, or the last 10 minutes of the exam.
2. This is a closed book exam.
3. Students access Blackboard to take the midterm examination
4. ONLY MS-ACCESS application can be opened.
5. The exam contains two parts:
a. Part A: Multiple-Choice Questions (30 marks)
b. Part B: A practical MS-Access exercise doing on the computer (70 marks)
Part B: MS-Access Exercises (70 marks) Question 1 (20 marks)
Create a database YourStudentID_Q1 (ex BABAIU23001_Q1)
a) Create a new table Category (3 marks)
Set data type to the fol owing fileds:
CategoryId: number, filed size:4
CategoryName; ColourCode: shortext, filedsize: 255
b)Create a new table Film (3 marks)
Set data type to the fol owing fileds: FilmId: AutoNumber
FilmName: shortext, filedsize: 255 RentalPrice: Currency
CategoryId: number, filed size:4
c) Create a new table Member (3 marks)
Set data type to the fol owing fields: MemberId: AutoNumber
MemberName: shortext, filedsize: 255 DateJoined: Date/Time
d) Create a new table Rental (3 marks)
Set data type to the fol owing fileds:
RentalId, MemberID, VideoId: Number, Feld Size: 2 0
DateRented, DateReturned: Date/Time OtherSpending: Currency
e) Create a new table Video (3 marks)
Set data type to the fol owing fileds: VideoId: AutoNumber FilmId: Number Withdrawn?: Yes/No Condition: Long Text
f) Set the relationship (5 marks) Question 2 (50 marks) (Use Movies database)
Rename the database to YourStudentID_Q2
Rename the tables to YourStudentID_OldTableName
(ex: tblActor BABAIU23001_tblActor)
a) Create the fol owing form for entering actors (10 marks)
b) Create a query cal ed Male actors 1975 to show al of the male actors born since
1st January 1975, in date of birth order: (6 marks)
c) Create a query cal ed Female actors 7x to show al of the male actors born from 1st
January 1970 to 1st January 1980, in date of birth order: (6 marks)
d) Create a query cal ed Luvvies to show the number of characters in the Movies
database for each film, and use this to show that The Return of the King had more
character roles in the database than any other: (6 marks)
e) Create a query OscarWinCountries to count and sort the total of Oscar Wins by country (6 marks)
f) Create a parameter qu ery OscarWinNumber to enter the tota l of Oscar wins of
films and display the information as fol ows: (6 marks)
g) Using the report wizard, create a report showing films by studio, and format it to
look something like this: (10 marks) ---------The End---------