Proposal for Kudler Fine Foods
Proposal for Kudler Fine Foods Our team was charged with the task of selecting a small business for which to implement database forms and reports requirements. We selected an upscale specialty food store located in the San Diego metropolitan area, named Kudler Fine Foods, as our business model. As do many organizations, Kudler utilizes a database system to improve their operational environment. However, they were still manually creating their forms and reports. Each store location uses standardized paper forms, which are then mailed or faxed to the main office to be entered into the database. The inventory system and forecasting for future purchases are done via extrapolations and working knowledge of the company, rather than queried data from their database system. Once we researched the company and gathered all of the necessary data, we were able to determine what type of forms and reports were needed.
Kudler Fine Foods has locations in La Jolla, Del Mar and Encinitas. The stores carry the very best in imported and domestic products, including bakery products, meat and seafood, produce, cheese and dairy, and wine. The departments in each store include: Fresh Bakery & Pastries, Fresh Produce, Fresh Meat & Seafood, Condiments & Packaged Foods, and Cheese 's & Specialty Dairy Products. We learned that the company uses their database to catalog data about their customers, inventory, items, orders, order line, stores, suppliers, tax and tender. Demographic data is collected for each customer and used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birthdays, etc. Further, the database contains information on each position available in the organization, as well as specific data on each employee. Without the use of the forms and reports features, Kudler 's database did not have much functionality.
Databases are made to be used to add and review data, quickly and effectively. "You can enhance
Kudler Fine Foods has locations in La Jolla, Del Mar and Encinitas. The stores carry the very best in imported and domestic products, including bakery products, meat and seafood, produce, cheese and dairy, and wine. The departments in each store include: Fresh Bakery & Pastries, Fresh Produce, Fresh Meat & Seafood, Condiments & Packaged Foods, and Cheese 's & Specialty Dairy Products. We learned that the company uses their database to catalog data about their customers, inventory, items, orders, order line, stores, suppliers, tax and tender. Demographic data is collected for each customer and used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birthdays, etc. Further, the database contains information on each position available in the organization, as well as specific data on each employee. Without the use of the forms and reports features, Kudler 's database did not have much functionality.
Databases are made to be used to add and review data, quickly and effectively. "You can enhance
References: Kudler Fine Foods Internet Website. (2005). Retrieved on July 2, 2005 from https://ecampus. phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Internet/KudlerPort.htm. Kudler Fine Foods Intranet Website. (2005). Retrieved on July 2, 2005 from https://ecampus. phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/KudlerHome002.htm. Microsoft Access Tutorial. (2005). Forms follow function. Retrieved on July 16, 2005 from http://office.microsoft.com/training/training.aspx?AssetID=RC010162551033 Microsoft Access Tutorial. (2005). Reports I: Show off your data. Retrieved on July 16, 2005 from http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033.