Delft Printing

1. Delft Printing WyoongHee Choi Crystal Jowdy Anthony Mirizio Alec Schon Kenneth Yeo Kai

2. Business Problem/Opportunity • Repercussions of using a manual system • Determining seasonality of products

3. Database Design Overview • Forms • Invoice Information by Customer Form • Customer Main Form contains Invoice Subform & Invoice Description nested Subform • Add Record macro makes the end users input the Organization Name first • Seasonality Business Rules • Detailed Guidelines for end users • Products Data Entry • Short form for Product Services • Help – Forms & Data Entry • Provides Contact Details • Return to Main Menu

4. Database Design Overview • Reports • Seasonality of Products • Visual representation of product sold per season • Total Quantity per season • E-mail macro automatically generates e-mail to Owner, Accounting Department and Purchasing Department • Customer Contact Information • Required information about organizations

5. Database Design Overview • Purchases Report by Customer • Customers categorized by transaction • Automatically highlighted in Red with >$800 • Customer Location & Shipping Information • Customers categorized by city • Payments Report • Organization categorized by type of payment (Cash, Check, Credit, Money Order) • Help – Additional Information • Contact information for help • Return to Main Menu

6. Database Design Overview • Help-General • Macro for Contact detail • Close Database • Exit Microsoft Access

7. Project Demonstration • http://www.acsu.buffalo.edu/~anmirizi/

8. Thank You!!