Access Database Recovery

How to Create an About Form in MS Access

This article addresses an effective method using which users can easily create an About Form in MS Access. We always recommend users to create an About Form, during the installation of Microsoft Access Application project. A typical About Form is used for displaying a customized Logo, name, copyrights information, and version number of the project, including other details, which a user wants to add about his form. About Form can be considered as a basic description of a project.   It is...

Read more »

How to Create Union Queries to Get Combined Results in MS Access

This article addresses the importance and the use of Union Queries and also gives steps to effectively use it to get combined results. Suppose a user has an MS Access database with two unrelated tables, one with client data and another with customer data. We assume that both these tables will have a field for contact information. Now if the user wants to see contact information in one view of both these tables, he will have to use the Union Query. Union Query is used for selecting and...

Read more »

3 Different Ways to Compact MS Access Database

In this article, we have addressed three different ways using which users can compact their MS Access Database, and what are their possible pros and challenges. In this article, we will discuss three different ways of compacting MS Access Database. Compact on Close Compacting Current Database in UI Compacting another Database in UI 1. Compact on Close Steps: Open File > Select Options > Open Current Database > Select Compact On Close (checkbox) This option is...

Read more »