OBJECTIVES
The purpose of this assignment is to use some of the database skills about Microsoft Access you
learned in class. In particular, you will use the following database skills:
 Table Design
 Relationships
 Forms
 Reports
 Queries
WHAT YOU NEED
You need the following application and file to complete this assignment:
 Microsoft Access
 EventOrganization.accdb and Customers_Data.txt (available for download on LMS)
HOW TO SUBMIT
 You can complete and submit the assignment individually or as a group of two students.
 If you work as a group of two students, only one student in each group will submit their
assignment on LMS.
 The completed Access file will be submitted on LMS.
 Due Date: June 3, 2019 - Monday @ 23:55 PM
OVERVIEW
You have a company which organizes events for your customers. You would like to implement a
database system to keep track of events you organized.
Your company organizes various events such as birthday, cocktail, reception, banquet, art exhibition,
wedding and conference in 28 different locations. A customer can select multiple events that your
company offers. A customer will be charged for each event your company organizes based on the
price per person and the number of participants. You will build a database with the tables of
Customers, Events you organized, Event Types you offered, and Event Locations.
You are provided with a partially completed database with the Event Locations and Event Types
tables. Complete the following steps: