File Recovery

Understand the different uses of Forms in Ms Access

For many small businesses Ms Access serves as a critical point of data storage. From payroll records to sales data, everything is stored within Access tables. At some point of time they need to create a mechanism to view or input related data and this where forms are called in. Forms in Ms Access can be created to several purposes from data reading to navigation. Let’s look at some form types in Ms Access and how they can be used to our advantage.   Sub-Forms can allow you to showcase...

Read more »

Learn How Ms Access can save a Small Business from a Mess of Spreadsheets

A large number of small businesses tend to still rely on the ubiquitous spreadsheet applications like Ms Excel to store their business data.  Over a period of time they end up having multiple files for employee records, customer records, product sales, leave records and possibly a separate file on every other conceivable business function. Since Excel files are difficult to correlate, there is a huge duplicity of data. Making a change across several Excel sheets can prove to be a nightmare....

Read more »

Including a Calendar in Ms Access – A Primer

The Ms Access application is teeming with a host of features that makes it an extremely versatile product. In some cases you need to enter date into a specific record in Access. Now if you are looking to input the date data in the text format, there is a chance that different users may choose a different format. The solution lies in using a calendar popup which users can browse through and select the date. Let’s look at how this can be achieved in Ms Access.   Avoid endless...

Read more »