Office File Recovery

How to Create Queries in Access

When you want to retrieve information from a database, the best way to do it is by using a query. Access makes it easy to set up queries to consistently pull the data you want for analysis and reporting. The whole point of a database is to have the ability to retrieve and manipulate the data for analysis and reporting. The query is the database tool that allows you to do just that. When you first start to learn about queries, it is best to start with a simple query that will give you basic...

Read more »

How to Add and Disable Add-Ins for Your Excel Files

You can use add-ins in Excel to fulfill some complex task. And in this article, we will introduce how to add and disable add-ins in Excel. If you need to use add-ins in Excel, you need to add and activate it into Excel. On the other hand, if you don’t need to use add-ins, you can also disable it. Here we will demonstrate the steps to add and disable add-ins in Excel. Add Add-Ins Click “File” in the ribbon. And then click the button “Options”. In the “Excel Options”...

Read more »

How to Merge and Unmerge Cells in Your Excel Worksheet

The details of merge and unmerge cells in Excel will always be ignored by most of the users. Here we will discuss about this feature in detail. Merge cells is a very common feature in Excel. With this feature, you can make your worksheet better. Here we will show you the details of this feature. Merge & Center Suppose now you need to merge cells of the last row in this range. Thus, you can input the total sales volume in one cell. To finish this task, now you can merge the three...

Read more »