200534 Accounting Information Systems Assignment

Assignment Help Management Information Sys

Reference no: EM132663330

200534 Accounting Information Systems - Western Sydney University

Computer Assignment

Assignment Objectives:

On successful completion of the Computer Assignment, students will demonstrate the ability to:

1. Consolidate the knowledge gained in doing the practical exercises using Microsoft Access during the semester.

2. Link the database concepts acquired from the lectures/homework to the practical exercises using Microsoft Access in the Computer Lab.

3. Normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Introduction

Good Fortune Restaurant Supplies (GFRS) is owned by Anna Vuong, a graduate of UWS. GFRS has grown rapidly and has found that managing its Sales function is essential to providing excellent customer service and operating profitably. GFRS has asked you to design a database that will help it control its sale and cash collection operation. GFRS sells ingredients and supplies to several different restaurants, food and drink outlets, and processed food factory. Donna Hay is the account manager who looks after all sale-related activities. Paul Murray is the creditor manager who is responsible for assessing and approving customer credit applications. Anna Vuong is the accounts receivable manager who is responsible for cash collection and accounting function. All orders from customers are processed by account officer/manager, and approved by credit officer/manager. The cash payments are received by the accounts receivable officer/manager. Sale orders from customers are confirmed with a printed customer purchase order signed by customer's purchasing agent. Normally, GFRS delivers shortly after orders are received and approved. A partial delivery of a sale order to a customer is acceptable.

When a delivery/shipment to customer is made, an invoice is prepared by one of the four account officers/manager and sent to the customer. A remittance advice is attached to the bottom of the invoice. Customers are required to tear off the remittance advice and sent it back with their payments. Anna has made an arrangement with each customer that a direct bank transfer is made by the customer per month to FRS's bank account to cover all invoices issued for the previous month. This arrangement has reduced the chance of bad debt and internal control issues in relation to cash collection.

The business stores its sale and cash collection transactions on a worksheet. Anna claims that she has done her best to make sure the data on the worksheet is correct.

Required:

You are required to normalise the data on the unnormalised worksheet provided.

Download the Excel Workbook "Re-Name this File As Your SID" from vuws and re-name it as your student number. When opening the Workbook, before you are allowed to work on the unnormalised table, you have to register yourself with your student ID number, your full name, campus, practical class (not tutorial), and your practical class instructor's name. After filling in the above details, you should click on the "Register" button on the StudentRegistration Form to proceed. You are only allowed to register once and no change of personal details will be permitted after the registration. If you are not ready to proceed, you can click on the Quit Excel button to exit. When you open the Workbook the second time after your registration, you can proceed to your work.

There are fourteen (14) worksheets in the workbook. The "Unnormalised Table" worksheet contains all the necessary data for you to copy to other worksheets. You should not change anything in the "Unnormalised Table" worksheet. The definitions of all attributes in the "Unnormalised Table" are listed in the following data dictionary. You must not change the name of any attribute in the "Unnormalised Table" worksheet when you copy data to a different worksheet to create a new table. Do not copy the entire Unnormalised Table worksheet to other worksheets. Only copy the columns required to other worksheets.

There are three un-named worksheets (New Table 1, 2, & 3) given in the workbook. If you think a separate table is required, you need to change the name of one of the un-named worksheet to the desired name. For example, if there is a many-to-many relationship between Student and Subject, the extra table required should be named as Student-Subject or Subject-Student. Do not change the Instructions worksheet.

The first column of any worksheet (a table) should be reserved for the primary key of the table. If there is a composite key involved, it should occupy the first two columns (for a two-attributes composite key) or the first three columns (for a three-attributes composite key) and so on.

Add the appropriate foreign key(s) to a table (worksheet) when it is needed. Sort all the records in each worksheet according to the ascending order of the primary key. Remove all duplicated records in each worksheet (if there are any). Remove all records which have no corresponding primary key data to maintain data integrity. When you use the Excel function Data->Remove Duplicates, do not highlight the entire worksheet. Only highlight the required columns.

If you have completed your work, you may submit your work for automatic marking. You can use the View->Macros (Alt+F8) to open the Macros list. Run the Marking Macro to start marking your work. The breakdown of your marks received will be displayed. You have five (5) chances to submit your work for marking. You do not have to use all chances if you are happy with the results. The last submission will replace the earlier submissions even if the marks achieved in the earlier submissions are higher. The last marks received from the automatic marking system will be the marks for your computer assignment. You still have to submit your marked assignment to vuws for your marks to be recorded.

You have to complete your whole assignment on the downloaded workbook. You can copy and paste the relevant rows and columns of data from one worksheet to another worksheet in the same workbook freely. However you are not allowed to copy a worksheet or contents of a worksheet from another workbook which belongs to you or to other students. Do not use the SELECT ALL button to copy an entire worksheet as each worksheet is protected by security measures. The automatic marking system has a built-in control system to detect this. Once the above problems are detected, the automatic marking system will not proceed to mark your work. If you believe that there is a mistake in the system, you may still submit your assignment to vuws unmarked. However you need to provide very good reasons to defend yourself against possible academic misconduct allegations as the security measures include, but are not limited to, keeping an activity log of your work done on the Spreadsheet file.

Attachment:- Accounting Information Systems.rar

Reference no: EM132663330

Questions Cloud

Discusses key stakeholders in the health care sector : Write a 350- to 525-word article that discusses key stakeholders in the health care sector in which you work (referral coordinator in a Hospital).

What the impacts have been on the organization overall : If your organization already utilizes one of these systems, describe how it has been deployed and what the impacts have been on the organization overall.

Write a summary narrative about statistical results : Write a summary narrative about statistical results. Prepare a properly formatted demographic table that includes appropriate univariate statistics.

Example how master data differs from transaction data : Explain how the SAP ERP system promotes an integrated approach to business processes? Explain withan example how Master data differs from Transaction data?

200534 Accounting Information Systems Assignment : 200534 Accounting Information Systems Assignment Help and Solution, Western Sydney University - Assessment Writing Service - data to a different worksheet

Company doing redesign of business processes : If you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign

Compute and prepare schedule of cost of goods manufactured : Prepare Schedule of Cost of Goods Manufactured. Bledsoe Corporation has provided the following data for the month of November

Make people aware that there is threat to security : Security practitioners suggest that key IoT security steps include: Make people aware that there is a threat to security;

By what mechanism do they function : The endocrine system is composed of various glands that secrete hormones. By what mechanism do they function? Give one example of a hormone and its effects.

User Account

All Pages