Database creation

I have designed customers database by using Excel programme. This information relates to the personal details of consumers that including names, address, postcodes, etc.

Then, I created another database for products information such as product number, name, quantity, price, and stock sold, total cost, total sale, and profit.

I changed the formation of the table in order to make the accessibility to the data more easier and clear.

Then, I used a mathematical process to represent the total sales, then i applied this process to other cells which is an existing feature on Excel.

I used the sum function to calculate the total sale. I selected the total sale cells for each product then I executed the process to see if it is work. This process applied as well on total cost and profit cells.

Then, i used a pie chart to declare the percentage of products sold.

The pie chart above shows the total cost for each product.

This bar chart represents the profit for each product.