Skip to main content

Problem solving database formating


This is an example of a formatting issue. This happened because applying the alignment option while I filtered the database from a particular column and the alignment function was applied only to the customer data which was filtered out and after deselecting the filters which brought back the full database it resulted into exactly as the above screenshot.

So to fix this problem, I had to select the full database again and apply the required alignment.

The resulted database after the success of applying the alignment format is being shown at the below screenshot.


You can also customise the fonts using the font format, by selecting a particular cell. The use of doing it is to write a title of your database as you can see from the one I created it has a title named 'Customer Database' which I have successfully done using the font format and to do this I had to add a new row and format the whole Row using the merge and centre. Then I increased the size of the font and gave a background colour to the cell as well as a Red font colour. Thus using the format alignment and font formatting one can expand his database to his needs.

Comments

Popular posts from this blog

Applying filters and it's benefits

    Above screenshot showing filtered cities of customers only in Bangladesh     Above SC showing the filter options after selecting the column 3 having 'Customer City' To apply the filter you have to select your desired column, and it will pop up a small box from where at first all the options will be selected but you can deselect it all and then start selecting your required information. So from the process of my filtering of cities I have found out the customers living specifically in Bangladesh, out of the 30 customers in my database. Benefits of applying filter: Saves time from trying to search from a larger database. Serving a customer regarding information about anything in the database will be much easier and faster.  Above screenshot showing the box pop-up after clicking column 12 Above screenshot showing off sales on October 2018 So after applying filter on the column 12, I could filter out the customers I have served on a part...

SERVICES : New addition to my E-commerce business website

I have added a new main page with the name SERVICES. The purpose is to provide customers with services which they will be needing after quiet a while regarding the products they will buy or even people with issues without buying any products might even use my services. It is an additional side which is promising for my business growth. In terms of longevity of the equipment I will sell, flexibility of my customers seeking my services after certain time and showing sincerity to everyone who are considering my business important to them. Screenshot : My SERVICE page having three services at the moment : Installation, Cleaning, Hardware repairment So far I have added three services which are common issues in customers daily uses. Hardware, Cleaning and Installation.  I have also added a new slider to my Home Page to draw attention of newcomers and also old customers who are always surfing my website for new updates.  The button let's go is linked to my service page a...

Product Quantity in my website

The number of total products in my website is 25. My product is the main page and it has 5 sub-page: Accessories, Console, Desktop, Games, Laptop. I have categorised all the 25 products into the 5 sub-page. Accessories page consist of 6 products,  Console has 5 products, Desktop has 5 products, Games has 4 products, Laptop has 5 products. This is the total number of products with the categorising. Below you will be able to find the screenshots of all the pages. Total is 6 page. My website URL :  https://kopilkaiser2017.wixsite.com/ded2tech Screenshot of total products Screenshot of products in Accessories Screenshot of products in Console Screenshot of products in Desktop Screenshot of products in Games Screenshot of products in Laptop