File Recovery

Understand the Scenarios where you should opt for Ms Access instead of a spreadsheet

In case of nearly every other small business, spreadsheets such as Ms Excel are typically preferred to store business data. While a section of small businesses do graduate to Ms Access over a period of time, a large section still tends to remain stuck with spreadsheets. As the business grows and number of different activities need to be captured, a whole array of spreadsheets are created. In a matter of years, such a business may be looking at a large set of Excel files, which are not...

Read more »

Sub forms in Ms Access – A Primer

The Ms Access application is known for its versatile features. When we look at creating forms in Ms Access, not only can we create forms as per our need and design requirements, we can even create sub forms. Basically sub-forms allow you to display an additional form within the parent form structure and can prove to be highly apt when you are looking to display interrelated data. For example if you are looking to create a form to showcase product categories, you may wish to display the products...

Read more »

Network Aspects to Consider while running Ms Access from a server

Over the last decade, the Ms Access application has found a very prominent place in many small businesses which have relied on its efficient data management and storage capabilities. Many have created custom applications to run on an Access backend which are used by multiple users. In many cases such applications have been deployed without much thought by making a common office PC as server and giving access to other users. While Access is capable of handling around hundred concurrent users...

Read more »