Office File Recovery

How to Use Wildcards in MS Access

In this article we learn about the Wildcards present in MS Access, their types, and features. In Access databases it is common for us to look for similar data. When you are looking to locate locating a set of similar looking values, the Wildcards in MS Access come handy. These are a form of special characters that replace all these unknown values and can find items with similar characters. The important point to note about these wildcards is that they can be used for locating similar values...

Read more »

Why One Should Use Queries instead of Calculated Fields for Access Tables

The article explains why the users should avoid using calculated fields in the database and instead use Queries. MS Access allows its users to create calculated columns (field type) in the table design to perform various calculations, but more often it breaks the rules of normalization. It is therefore recommended to use Queries instead of calculated fields. This article will elaborate this point in detail. Calculated Fields in MS Access Calculated fields are integral part of the...

Read more »

How to Easily Use Controls in Subforms in MS Access

The article explains the uses of Subforms in multiple controls on multiple forms and how to acquire information using subforms. Subforms are useful tools in dealing with relational data in tables in Microsoft Access. They allow users to control multiple forms or Queries using a many side relationship. A subform, as the name suggests is part of a main form, and is a part of it. The article will explore the uses and functioning of Subforms in MS Access. Subforms in MS Access Subforms are the...

Read more »