1.   

Differentiate between data, information and knowledge

2.   

Consider how data, information and knowledge can be applied and utilised in the workplace

4.   

Identify the problems associated with both information and communication channels within the workplace

Access Database consultancy for ‘Jerry’s Haulage Ltd’

Scenario

You are employed as a Consultant by‘Jerry’s Haulage Ltd’. They deliver a wide variety of products to customers all over the country and until recently they have organised their orders and customer details on paper in filing cabinets. The company is looking to reduce its carbon footprint with their new ‘Green Initiative.’ Some progress has been made, creating a database to track their orders, however, there is still a lot of development work which needs to be done in order to improve the system in line with the business processes.

Using the knowledge of databases you have acquired you must make changes in order to develop the database system in Microsoft Access to reflect the requirements of the company, considering what would make for the most effective business process at all times. To do this you will need to design and implement a table, add queries, forms and reports so that the users can manage, manipulate and interrogate the database effectively.

Click here for more on this paper…….

In addition to the database development work which you must carry out, you are required to create a 700 word report in Microsoft Word addressing questions 1b, 5a and 5b(detailed below). You are expected to make reference to theory throughout and therefore the report should be fully referenced in APA format, with each question clearly separated and marked with the relevant question number.

Assessment Deliverables

1.
      
The company’s sales department has previously struggled to control the data quality of customer, product and order details.

a.
      
Use appropriate data validations where possible, to reduce the number of errors staff might make when performing data entry. (10%)

b.
     
Explain how the effective management of data quality can improve the customer experience, taking into consideration what affect this would have on the company’s customer retention rate. (200 words, 10%)

2.
      
The staff are very busy taking orders, so it’s not ideal for them to view the data in the tables. Develop a system where staff are able to view a customer’s details on screen, along with a list of orders which they have made, without going directly into the tables. (15%)

3.
      
In line with the company’s ‘Green Initiative’ the senior management team would like to reduce the carbon emissions by reducing any unnecessary journeys. Produce a report of orders which the driver could use to plan his journeys effectively. (You should consider what might be an effective grouping system). (15%)

4.
      
The company needs to be able to view information on-screen and have the ability to print this, if necessary.

a.
      
The staff need to be able to view a report of outstanding deliveries. Create a report to show all orders which have not yet been delivered. (10%)

b.
     
The company reviews their range of products every quarter. Create a query and report to list the orders placed for each product in a specified time-range. (15%)

5.
      
The Senior Management Team are sceptical about the purpose of the data that they are recording and would like to understand the problems they may encounter during the implementation of a new system.

a.
      
Explain how the data held in their database can become useful information for the Senior Management Team; you should include a brief explanation of the difference between data and information. (300 words, 15%)

b.
     
Explain the potential problems that the Management will face whenaltering the processes, which staff have followed for many years, and explain how these problems might be overcome. (200 words, 10%)

Click here for more on this paper…….