Create access database for inventory management

Assignment Help Operation Management

Reference no: EM132228031

Part 1. You will create an Access database for inventory management for the Pie Safe Bakery and Creamery in Deary Idaho. This will be for finished products only. Deliverables 1. ERD 2. Data Dictionary Then Create a database in Access from the ERD 1. Screen shot of each table 2. Screen shot of the relationship page.

Part 2. Then develop a two table query and enter in some test data. Then run the query and show me that it works. 1. Screen shot of the results 2. Screen shot of the query in SQL View. Then write a paragraph or two on what you learned doing the project. The best way to put this together would be to take all your screen shots and put them into a Word document. (Do only part two since part one is already done)

Reference no: EM132228031

Questions Cloud

What should they do about the home coffee market : What should they do about the home coffee market? How soon should they plan to enter? What other strategic advice do you have for Lazaris?

Develop MPS manually with given initial inventory : Develop an MPS manually with a given initial inventory of 35, when will you be able to deliver the order, without regenerating the MPS?

Summarize and define themes in a research codebook : Summarize and define themes in a research codebook. What are the primary themes in the customer reviews? What is the biggest source of positive or negative.

Fundamental difference between management and leadership : What is the fundamental difference between Management and Leadership? Are they in diametric opposition, can they co-exist or is there something in between.

Create access database for inventory management : You will create an Access database for inventory management for the Pie Safe Bakery and Creamery in Deary Idaho.

Talent management and development program : I stated that an organization can survive without a talent management and development program.

What is the optimum quantity of snowboards to produce : What is the optimum quantity of snowboards to produce? What is the total annual cost of producing and storing the company's best-selling snowboard?

Communication and listener anxiety-nonverbal skills : Do you have communication and/or listener anxiety? nonverbal skills: From your school, work, or volunteer communications experience,

What quantity should the store order with each order : What quantity should the store order with each order? What is the store's minimum total annual ordering and inventory carrying cost?

User Account

All Pages