Excel - Customer Database

Customer DB

With the help of Microsoft Excel, I created a customer datasheet which as shown below has numerous columns showing the following information:
  1. customer ID
  2. first name
  3. last name
  4. country
  5. city
  6. postcode
  7. address line
  8. phone number
  9. email address
  10. Order ID
The sheet is formatted by adding borders to the tables, a peach coloured highlight to the titles as well as a filter option to each column which could help narrow down the fields to the specific person or customer I am searching for.


Comments

Post a Comment

Popular posts from this blog

Definitions 2

Image
 Internet website cookies Cookies in relation to online websites are text files containing pieces of data used to identify your device as you use a network and it involves data such as username and passwords(KASPERKY, 2020). For instance, as a user visits a website a few days after previously logging in, the website may recognise them(BEHERA, 2020). UI As Churchville(n.d) points out, user Interface is the way humans or users interact and communicate with a website. According to Churchville(n.d), there are numerous types of user interfaces such as:  GUI CLI VUI Page source As Brain(n.d) explains, a websites' page source is the original text and HTML tags the author added to the site which then the browser interprets to output the normally visible web pages across the internet. A page source could mostly be viewed by simply clicking the right mouse button on an unoccupied area on the site and then choosing the 'View source' option. Meta tags According to Hardwick(2020), meta ...
Read more

Pros and Cons of E-commerce

  It was reported with the help of statistics that electronic retail sales are predicted to rise up to 4.8 trillion dollars by 2021 (Ferreira, 2019). However, this increase in usage does not necessarily rule out the fact that it does not have any disadvantages;  Here are some of the Advantages and Disadvantages of electronic commerce in accordance with Ferreira(2019):      Advantages:                       - Low startup financial cost.          - Income could be gained throughout the day(24/7) as the website may always remain open.          - International sales.          - Ability to showcase the best-selling products.          - Ability to customise a page per audiences' searches.     Disadvantages:          - Sales may be affected during a Site Crash.  ...
Read more

Choice of E-commerce

Image
Electronic Books My website will be following the Business-to-Consumer(B2C) E-commerce model as the products are aimed to be sold to none other than the consumers themselves. Two similar websites I am going to be researching two different websites that are famous or known to be selling E-books which are :   1)Ebooks:  This below, is the e-Books.com home-page. The header contains: Title Top menu Amount of members Amount of e-Books sold Search Bar Learn More The body contains: Featured titles Bestsellers per category segment Popular subjects Sign up for the newsletter                 https://www.ebooks.com/en-gb/ The website's about page starts off by showing a picture with a quote/slogan and then talks about what the site offers in two bullet points. Below the bullet-points, the text mentions the companies origination and details more about the company itself. 2)Hive:  This is the page of the Hive.co.uk/eBooks website; In the header:...
Read more