1 / 8

Streamlining Business Processes: A Database Solution for Enhanced Product Seasonality Management

This project addresses the inefficiencies associated with manual systems by implementing a comprehensive database design. It focuses on managing product seasonality, providing detailed customer invoicing, and facilitating easy data entry through user-friendly forms. Key features include automated emails to stakeholders, customizable reports on purchases and payments, and essential guidelines for end-users. By enhancing data management, businesses can make informed decisions based on clear visual representations of sold products across different seasons.

wynn
Télécharger la présentation

Streamlining Business Processes: A Database Solution for Enhanced Product Seasonality Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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!!

More Related