Accounting Report: UK Company Customer Order Database Analysis

This report analyzes a customer database and order tracking system for a new UK company using an MS Access database. The report details customer information, including names, addresses, and order details. It describes queries involving one or more tables and provides data on orders per customer, including the quantity of each food item ordered. The analysis includes sorting products and services by price and title. The report concludes with an analysis of the accounting data, emphasizing its importance for recording products and services and its use in planning future growth. The report references several accounting information systems books and journals and an online source related to customer order analysis.

Accounting information

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Report for Table “Customers”....................................................................................................1
TASK 2............................................................................................................................................1
Description about queries involves one or various tables...........................................................1
TASK 3............................................................................................................................................3
3aorders per customers................................................................................................................4
TASK 4............................................................................................................................................5
Report analysis............................................................................................................................5
CONCLUSION................................................................................................................................5
REFERENCES................................................................................................................................6

INTRODUCTION
Accounting information is basically a computer related method which is used for tracking
accounting activity in respect to conjunction with digital technology resources. These outcomes
are mainly statistical report that can be internally associated with management through other
concern parties such as investors, creditors and tax department. Accounting data is concern with
end outcomes that results of accounting cycle which start with recording of business transaction
and concluded with production of product and services of an organisation. This report is all about
explaining crucial information about customers and their relationship (Hall, 2012). All the
analysis is done to determining various method that are employed in respect to make valuable
database to fulfil organisational demands.
TASK 1
Report for Table “Customers”
According to the mentioned case study, it has been found that one of the experience
person has currently opened a new company in UK. They are realising that an MS access
database would be taken into consideration which would help them to a specialist in information
systems in setting up of order tracking system (Demski, 2013).
CUSTOMERS Detail's
First name Last name Address Delivery instruments
John Lewis 61, Walfield road, Roath Cardiff,
CF24 3DG
Use main entrance
Chris Martin 3, Edger Buildings, George street
bath, England, BA1 2FJ
Same
Tom - 14, Tottenham court road, London
England W1T 1JY
Main entrance
David - 44-46 Morning side road Edinburgh
Scotland EH10 4BF
Hotel
1

TASK 2
Description about queries involves one or various tables
MS access database consists of key components to the unique areas and combination of
needed and determine relationship as per the denotative integrity regulations. Formulation of
specific database can be differ, but the outcome of queries to be develop in the report that would
be same regardless of the design (Christensen and Feltham, 2012). The total number of
customers are taken into consideration is 4 customers and 6 types of product as well as services
in database.
(1) John
Date Title Number
15/04/18 Pizza 2
17/04/18 Breakfast 1
20/04/18 Pizza 1
25/04/18 Burger 2
27/04/18 Pizza 1
29/04/18 Bibimpab 3
02/05/18 Sandwich 1
05/05/18 Burger 2
06/05/18 crinkle cut fries 1
10/05/18 Breakfast 2
12/05/18 Pizza 3
(2) Chris
Date Title Number
15/04/18 Breakfast 2
16/04/18 Burger 1
21/04/18 Breakfast 1
15/04/18 Pizza 2
17/04/18 Sandwich 2
25/04/18 Sandwich 1
19/04/18 Crinkle cut fries 2
2

02/05/18 BiBiMPAB 3
07/05/18 Pizza 1
10/05/18 Burger 1
12/05/18 Breakfast 1
(3) Tom
Date Title Number
14/04/18 Crinkle cut fries 2
16/04/18 Sandwich 2
18/04/18 breakfast 1
21/04/18 breakfast 1
29/04/18 Sandwich 1
02/05/18 Bibimpab 2
05/05/18 Burger 2
07/05/18 Pizza 1
10/05/18 Crinkle cut fries 2
12/05/18 Sandwich 1
15/05/18 Pizza 1
(4) David
Date Title Number
15/04/18 Sandwich 2
17/04/18 Breakfast 1
19/04/18 Breakfast 1
20/04/18 pizza 1
22/04/18 Burger 2
25/04/18 Bibimpab 3
28/04/18 Bibimpab 1
02/05/18 Crinkle cut fries 2
07/05/18 Crinkle cut fries 1
3

10/05/18 Crinkle cut fries 1
12/05/18 pizza 1
TASK 3
Sorting is said to be effective process of making arranging items systematically and has
two common aspects. Arranging products in a proper sequence ordered through some criteria
such as grouping products with similar properties. “2a product sorting used to provide an
appropriate types of food which an individual or region is famous for a their food business for
children with particular requirements as per the demand of customers. Formulate as specific
query those are sort every food descending according to their costs. All product and services
which displayed similar prices will be sorted ascending as per there title (Simkin, Norman and
Rose, 2014). The attributes to be displayed in appropriate manner just like, Title, Ingredients and
prices.
This particular layout provide specific information about obligatory data that would be
stored in MS access database. A customers used to place order as per their demand and choice. It
has been seen that for each order placed must representing various types of product and services
requested and their total quantity. There is no any representation in the order placed by various
customers. All the data associated with product and services are recorded individually. Below
mentioned obligatory data products are mentioned and recorded below:
FOOD
Title Ingredients Price £
Bibimpab Hot rice, combination of various vegetables 15
Pizza Tomato, paneer, cheese and capsicum 14
Breakfast Bread, egg, coffee and fruits 12
Crinkle cut
fries Potatoes, vegetable oil, rice flour, Dextrin, salt leaving and other 12
Burger Bun bread, potato chips, cream, cheese and tomato 10
Sandwich Brown bread, cream, vegetables etc. 10
TASK 3
4

3aorders per customers
Name Pizza Breakfast Burger BibiMPAB Sandwich Crinkle cut fries
John 7 2 4 3 1 1
Chris 3 4 2 3 3 2
Tom 2 2 2 2 4 4
David 2 2 2 4 2 4
Total 14 10 10 12 10 11
According to the above information about all those products that are being use by various
customers are placed in systematic order. The outcome generated from this are indicating a
healthy return which is collected from order of Pizza. The total number of orders are collected is
about 14 with the rate of 14*14=£196. One of the more reliable ways to boost their overall
earning which is more simply to get maximum income from their current customers. Mainly
every business wants to enhance their customer base by offering wide range of products and
services to their customers (3aorder per customers, 2018). This particular method not only done
to encourages their present customers in respect to look elsewhere but research has to be
indicated that it is consider as more expensive. There are certain effective measure which is used
to maximise the total amount of earning that can get from each of their present customers
without limiting their option for gaining maximum profit during an accounting period of time.
There are certain aspects which are needed to be taken into consideration. Such as:
Increasing their transaction size: The fast food giants used to increase their transaction
which is similarly through offering complementary products that go with their order in regular
course of action. This act of attaching other products from their business during the checkout
process for each customers (Ghasemi and et. al., 2011).
Personalise their customers services: Various customers are not only wants to be
activated as a lot from customer services that are representatives in effective manner. Total 4
customer are having ended relationship due to a effective base as well as service experiences. All
is that need is a digital system that used to collect reliable information about increasing future
aims and objectives for an organisation.
5

TASK 4
Report analysis
This particular report is providing crucial information about all accounting data which is
used for the purpose of recording all crucial products and services those are being offered by an
organisation to their customers. It has been seen that all detail sequences made by organisation
about their customer are equally essential to determine total amount of products used during the
period of time. This report is showing vital information about all food details that are offered by
to various customer in UK. The positive aspects are helpful for planning their future growth and
sustainability for an organisation (Worrell, Wasko and Johnston, 2013).
CONCLUSION
This project is concluding vital accounting information systems that are being used by an
organisation in respect to determine total amount of order made by customers during the time.
All the data are recorded into MS access database to easily made analysis about overall cost for
the company. This will assist them to get more reliable and accurate results through proper
utilisation of organisation resources.
6