image 

Trophy Max

Small-Business Database

ACCESS CAPSTONE

Submission Instructions Complete the Access Capstone. You will need to start with a blank database for this assignment. Ask your instructor for submission instructions.

Preview You are a business owner of a trophy and recognition gift store. You offer trophies and awards for corporate, school, and sporting events. Trophy Max provides a wide variety of award types such as plaques, medals, and trophies. You also offer engraving and shipping.

Skill Set

image

Background You have just purchased a small trophy and awards store in Oceanside, California. The business is well established and has been around for many years. The previous owners used an Excel spreadsheet for their store's database. As the new owner you want to transfer their data from Excel into an Access database. The database will have four tables: Existing Customer table, Product table, Supplier table, and Order table. You also want to create forms for each of the tables for your sales team to enter new data when necessary. As store owner of Trophy Max you need to create several weekly reports showing a variety of weekly sales statistics.

image CASE ANALYSIS

Output Requirements

You need ...

Get MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.