Implement an access database

Assignment Help Database Management System

Reference no: EM13763071

Business Scenario

Your muesli company has been using Excel to track customer orders. They are having difficulty analyzing the data and producing meaningful reports. They have asked you to implement an Access database so they can add, modify and delete data as well as generate queries and reports based on the information contained in the database. Part of the work has already been done for you and the data from Excel was transferred into Access database.

Your muesli company sells different types of muesli which are stored in the table Muesli in your database. Your customers are many different small and large grocery stores. Muesli is sold through three different distribution channels: channel 10 - Hypermarkets (i.e. wholesale like Costco or Sams Club); channel 12 - grocery stores (i.e. supermarkets like Publix); and channel 14 - independent grocers (small grocery stores). Distribution channel types are stored in the Distribution Channel table and your company's customers are stored in Customer table. For every sale transaction the customer, muesli type as well as price and quantity are recorded in table Sale.

Attachment:- database assignment.rar

Reference no: EM13763071

Questions Cloud

Problem encountering in nursing : The rationale must be supported by the current or seminal literature.

The first to place emphasis on psychological variables : Who was one of the first to place emphasis on psychological variables in memorial and association processes?

Modify the inventory program by creating a subclass : Modify the Inventory Program by creating a subclass of the selected product's class that uses one additional unique feature of the product that has been selected for you. You must use the subclass name and additional unique feature

Accounting systems and accruals : From the e-Activity, examine the greatest threats to a computerized accounting system. Suggest two (2) preventive measures or remedies to protect the system and / or mitigate negative impact to the system. Provide a rationale for your response.

Implement an access database : They have asked you to implement an Access database so they can add, modify and delete data as well as generate queries and reports based on the information contained in the database

What is the breakeven point for company : What is the breakeven point for this company? How much would we expect in profit for every unit sold above breakeven? What if the company has its budget set at $35,000 target profit? How many units must it sell?

Useful and well-designed programs of ticketseller : Designing well-written and readable programs using a disciplined coding style, including documentation and indentation standards.Demonstrating how to implement logic involving sequence, selection, and repetition using Visual Basic.

Compute the amount of over head cost : Compute the amount of over head cost that would have been charged to each project during May.

The pros and cons of medical research : Are there any changes that need to be made e.g., medical school structure, government funding, access to medical literature?

User Account

All Pages