Office File Recovery

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 »

How to Effectively Import Data from an Excel Spreadsheet to an Access Database

In this article we look at learning the process of importing data from Ms Excel in Ms Access in an effective manner The Ms Excel application is invariably counted amongst the most popular desktop applications in use today and by far the most widely used spreadsheet tool in the history of computing. Thus it is not surprising to note that many users often use Excel spreadsheets when they should ideally be using Access databases. MS Access might be a little more complicated to use as compared...

Read more »