Microsoft Access

CLOSED
Bids
24
Avg Bid (AUD)
$287
Project Budget (AUD)
$30 - $250

Project Description:
Supreme Seafood Restaurant (SSR) is a restaurant owned by George Calombaris, Gary Mehigan and Matt Preston that specialises in Asian cuisine. SSR has grown rapidly and has found that managing its purchasing function is essential to controlling costs and operating profitably. SSR has asked you to design a database that will help it control its purchasing operation. SSR buys ingredients and supplies from several different food products wholesalers. Adam Liaw is the restaurant’s executive chef and functions as its purchase agent. All orders with vendors are placed by Adam and are confirmed with a printed purchase order. Normally, vendors deliver shortly after orders are placed.
A partial delivery of a purchase order from a vendor is acceptable. When the shipment arrives, one of the four staff members counts the items and fills out a receiving report. A single receiving report is prepared for the same vendor even though multiple deliveries are received on the same day. However, a separate receiving report is prepared for each delivery from a different vendor. If a purchase order is delivered on multiple days, multiple receiving reports will be prepared. These staff members sign each report at the bottom on the “receiving staff” line. Vendors attach invoices when shipping the orders to SSR. At the end of each month, Gary matches copies of the purchase orders, receiving reports, the invoices received from the vendors, and writes cheques for the amounts due on the first day of the month. Gary always pays vendors with one cheque even if that vendor has sent multiple shipments during the month. He may draw cheques from either of the business bank accounts.
The business stores its purchasing transactions on a worksheet. George claims that he has done his best to make sure the data on the worksheet is correct. You are hired as the consultant to create a computerised database system using MS Access 2010 to handle the purchasing process of the business.
After you have done the work to normalise the data on the worksheet, you are now ready to proceed to create the database system.

You are required to create appropriate tables, forms, queries and reports based on the data from an Excel
Workbook provided based on the Purchasing Process of Supreme Seafood Restaurant.

1. Import the information in the Excel workbook to the Access Database. Each worksheet sould form
a table. Use Show Named Ranges in the Import Spreadsheet Wizard to import the worksheets.
The ranges for the tables have been named, just scroll down the list to find them. Change the
data type for all attributes in each table according to the data dictionary provided.

2. Establish relationships between the tables and then create a Relationship Report. This report
should appear in the Report section .
3. Create a Form with a sub-form for Purchase Order Entry purposes. The form should capture
information such as purchase order number, vendor number, vendor name, vendor address
(street address, suburb, state and postcode), vendor phone number, vendor contact person, and
a total amount for the purchase. The sub-form should show inventory item number, inventory
item description, quantity ordered, unit price and total amount for each inventory item. You
should use a combo box that lists vendors alphabetically; a combo box that lists inventory item
number in an ascending order.

4. Create the following reports (with current date and page number): (30 marks)
a. Purchases by vendor, and within vendor, by product. The following information should
be available from the report: Vendor name, purchase order number, inventory
description. A subtotal amount should be calculated at Vendor level, purchase order
level, and inventory item level. Name the report as “Purchases by Vendor by Product.”

b. Create a Purchase Summary report that lists all items purchased, sorted by total quantity
purchased. Inventory item number, inventory item d

Skills required:
Excel, Microsoft Access
Additional Files: Capture.PNG Excel+Work+Book.xlsx Supreme+Seafood+Restaurant.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 720
in 7 days
$ 320
in 5 days
Hire KellogITSolution
$ 100
in 5 days
$ 250
in 20 days
$ 630
in 30 days
$ 250
in 7 days
$ 300
in 15 days
$ 500
in 2 days
$ 100
in 5 days
$ 300
in 7 days