Đã Đóng

Microsoft Access

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

Kỹ năng: Excel, Microsoft Access

Xem thêm: access total receiving reports, wizard form design, type consultant business, staff required restaurant, spreadsheet consultant, shipping box draw line, purchasing agent, purchase summary, purchase order form excel, product design supplies, preston, access consultant, microsoft number, microsoft excel help functions, microsoft design, microsoft consultant, microsoft access database consultant, microsoft access consultant, level one bank, inventory receiving form, help excel spreadsheet business, form wizard design, find database consultant, find consultant purchase, find chef

Về Bên Thuê:
( 0 nhận xét ) Australia

Mã Dự Án: #1645424

22 freelancer đang chào giá trung bình $283 cho công việc này

Krusche

Please check the PMB.

$720 AUD trong 7 ngày
(26 Đánh Giá)
5.6
srinichal

Let me know more details

$320 AUD trong 5 ngày
(3 Đánh Giá)
4.6
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c Thêm

$100 AUD trong 5 ngày
(25 Đánh Giá)
4.5
infoshree80

I ahve read your requirement and understood wht exactly you need.Please Check Private message

$250 AUD trong 20 ngày
(11 Đánh Giá)
4.3
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

$630 AUD trong 30 ngày
(3 Đánh Giá)
4.1
ifaisal

Hello I can do this for you, I have experience and expertise in Ms Access and has done many similar projects. I can do it quickly and accurately and you do not have to make any payment until you are completel Thêm

$250 AUD trong 7 ngày
(8 Đánh Giá)
4.0
ExactSystems

Please see detail on PMB. regards

$300 AUD trong 15 ngày
(4 Đánh Giá)
4.1
Dhruvika111

Dear karmenzhang123, Highly Experienced and Expert Team Here.Please check your PM For Details. Thanks Dhruvika

$500 AUD trong 2 ngày
(4 Đánh Giá)
3.4
Aronvitki

I can easily do this within 5 days, if not sooner, exceeding your expectations.

$100 AUD trong 5 ngày
(6 Đánh Giá)
3.2
AccessAuthority

Hello Mr Karmen, We are Sydney-based database specialist with 8 years professional experience. We successfully completed similar projects in freelancer. We do strictly maintain our quality and deadline(our completi Thêm

$300 AUD trong 7 ngày
(5 Đánh Giá)
3.1
shagoon2u

Experts are ready to start immediately

$249 AUD trong 5 ngày
(3 Đánh Giá)
2.9
YLombard

Happy to help you with this. Please supply the Excel spreadsheet and I will start right away.

$100 AUD trong 2 ngày
(0 Đánh Giá)
3.4
anandakishor857

Hi,I interested to work with you.

$150 AUD trong 7 ngày
(0 Đánh Giá)
0.0
kerrydesi

I have over 25 year IT experience withmore than 18 years SQL/database experience and 20+ years development experience. I deliver all my projects on time and the quality of my work is exceptional

$500 AUD trong 3 ngày
(0 Đánh Giá)
0.0
gtorikt

I'M FINE IN MS ACCESS DBASE. I WILL DO MY BEST AS I'M BEGINNER IN FREELANCER.

$210 AUD trong 7 ngày
(0 Đánh Giá)
0.0
kusas

I can do a good job on this Thank you

$250 AUD trong 5 ngày
(0 Đánh Giá)
0.0
arh36

Hi I'm UK based and provide Access solutions to clients; Most recently I have been finishing a Order/customer/Inventory database for a Furniture company. The work as you have described in your documentation is very Thêm

$160 AUD trong 3 ngày
(0 Đánh Giá)
0.0
LeeuLion

Good day Let's start immediately. Will assist you. I have worked a lot with excel spreadsheets - converting to databases and visa versa. Regards

$400 AUD trong 1 ngày
(0 Đánh Giá)
0.0
ahamedkabir

Dear Sir We have gone through the information provided by you and can work on your project. We would love to work on this project as it matches with our skills set and development(s) related to your requirement, we ha Thêm

$200 AUD trong 25 ngày
(0 Đánh Giá)
0.0
ungoswami2012

I have wide knowledge of the project as you required

$200 AUD trong 25 ngày
(0 Đánh Giá)
0.0