Access Solutions

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 »

6 Effective Tips to Use MS Access Database in a Retail Store

In this article, we look at using MS Access effectively in retail stores. You will learn how to quickly detail important aspects like sales, inventory and customer service into an Access database project. Irrespective of the size of your business, maintaining an Access database proves to be a great help in the long run. If you are in a retail business, you would know that there are a lot of things you need to keep a track of. Ranging from inventory and shipping, to customers and employees...

Read more »

7 Useful Tips to Prevent Access Database Crash

In this article, we have addressed seven tips which can help you in preventing your MS Access database crash. Database corruption is worse than a nightmare for Access users. Losing tons of data due to a stupid mistake, after it was maintained through months of organization, hard work, and time can be very frustrating. Fortunately, sometimes users get lucky enough to repair or recover this data. Sometimes third party products come to your rescue to save your database from fading away from...

Read more »