MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition

6

Destination Corporate Event Planning, Inc.

Event Coordinator

ACCESS WORKING CASE: INTERMEDIATE LEVEL

Submission Instructions Complete Case 6 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.

Preview You are an event coordinator for a corporate event planning company, and your objective is to build several criteria-based queries and reports based on information found in the Destination Corporate Event Planning (DCP) database. DCP needs you to generate reports for current event scheduling and billing to their accounts.

Skill Set

Queries	Reports
Insert criteria	Format reports
Sorting	Sorting
Show option	Grouping
Queries based on more than one table	Header and footer Labels

Background DCP is a corporate event planning company that only carries large national accounts. The company coordinates events including annual sales meetings and large conventions. Attendance at these events is a minimum of 1,000 people up to 15,000 people. At any given time DCP coordinates up to five events simultaneously. DCP uses many database files within its company, including client information and supplier and vendor information. DCP needs you to design a small part of their database just to keep track of the event dates and booking fees to the events. As an event coordinator you need to be able to run queries and reports based on ...