Office Solutions

6 Main Causes for Data Corruption in MS Access

In this article we look at several common causes which can induce data corruption in an Ms Access database Incidents of Data Corruption in MS Access databases are a fairly common occurrence. Corruption in Access Databases can occur due to several reasons that include both software and hardware related issues.  It is difficult to do away with corruption of data or to find its cause, once it has occurred; therefore it is always better to make attempts to avoid corruption of Access databases....

Read more »

8 Key Mistakes to Avoid While Designing Forms in Your Access

In this article we look at key mistakes one needs to avoid while designing forms in Ms Access, especially if you prefer to design forms manually instead of using a Wizard. If you are using Ms Access it is quite logical that now or later you would need to design forms. In this article we show you how easy it is to create forms in Ms Access. One of the most commonly used features of MS Access is AutoForm. A lot of different types of forms can be created with the help of the AutoForm Wizard....

Read more »

How to Analyze Data by Using Slicer in Pivot Table in Your Excel Worksheet

Pivot table has provided many useful features for you to analyze data and information. In this article, we will talk about the usage of slicer feature in pivot table. In Excel, the pivot table is very efficient in analyzing data and information. You can also demonstrate data in the way that you need by this feature. The image below shows the sales volume in a worksheet. In order to analyze this range, we have created two pivot tables in another worksheet. In the first table, we will show...

Read more »