Office File Recovery

How to Prevent Bad Data from being Saved in Access Tables by Using Validation Rules

In this article we look at why validation rules are so important in keep the data stored in MS Access in pristine shape MS Access allows the users to manage data in the most convenient way but it’s often observed that accuracy remains a challenge for bigger databases and yes we do end up with Bad data. Also known as dirty data; Bad data is any information that is misleading, erroneous and lacks formatting, causing serious damage to the data purpose. The problem comes in picture because of...

Read more »

How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range

Using parameter query in MS Access is a child’s play; it is as easy as using a Criteria for creating a query. In this article we look at using them to limit records to a specific data range. A parameter query is one of the most useful and easiest ways of creating an advanced query. It is one of the most common methods used for creating queries. One of the unique features about parameter query is that it allows users to create queries which can be updated, during the command to reflect on...

Read more »

How and When to Use Quotation Marks In MS Access

Both users and developers at times use Quotation Marks while working with Access database. In this article we will learn such use case scenarios in detail. MS Access developers have regularly used Quotation marks for several purposes including most notably in SQL statements. Let look at some key situations where you need to use Quotation Marks: When a user wants to specify criteria for any domain aggregate function. When specifying or using criteria for Find method. When the user...

Read more »