Understand Cascade-to-Null Feature and How it Can Allow the Use of Null Foreign Key

Here we understand the Cascade-to-Null feature in MS Access and how to use it for allowing Null values in foreign key fields. Indexed fields in MS Access are usually not Nulls mainly because the fields have been set with a ‘Required’ property, to ensure that there are values entered for all fields, irrespective of the data type. But as the case maybe there can be situations where having a Null foreign key can actually be of some help. An example can be of a situation where you need to...

Read more »

5 Most Common Cases of Mistaken File Deletion

As we all know, mistaken file deletion is a pretty common kind of data losses. Now, in this article, we'll expose 5 most common cases of mistaken file deletion. It's known that data can get lost due to various factors, including hardware issues, software failures, power surges or outages, virus attacks and human errors, etc. Among all kinds of data losses, undoubtedly, mistaken file deletion has disturbed myriad of users for a long time. Now, here we'll expose 5 most common scenarios of...

Read more »

How to Batch Print Envelopes for All Addresses of an Outlook Contact

Outlook supports you to add 3 addresses to a contact, namely business, home and other address. Now, if you want to print envelopes for all addresses of a contact, you can use the way introduced in this article. It can let you realize it in bulk. When it comes to creating envelopes for contact, "Mail Merge" feature may come to your mind in the first place. Yet, by default, it can only create one envelope for one address of a contact at once. If you would like to batch print envelopes for all...

Read more »