Office File Recovery

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 »

How to Create and Use Calculated Expression in MS Access

This article explains how and why Calculated Expression is used in MS Access. It also addresses an efficient way to properly use it. An expression can be defined as a formula, which is used in Excel. Calculated Expression consists of multiple elements which can be used as a combination or individually to produce any desired result. Expressions can be a combination of logical or mathematical operators, controls, constants, functions, properties and table fields, which evaluates these...

Read more »

How to Use Query Criteria in MS Access Effectively

This article explains the importance and use of Query Criteria in MS Access while also explaining a proper method to use it. Query Criteria is used for retrieving specific items from an Access file. Users use Query criteria for retrieving search and view data, without performing an in-depth search of the database. If an item or information matches with all criteria entered by the user, it automatically appears in query results. This helps in saving time and energy of the user. Users use...

Read more »