Data Recovery

Dealing with an Ms Word Document from within Access

One of the key advantages of using the Ms Office application suite relates to the flexibility of including data from one application into another. For example you can include an excel table in a PPT or a word document with ease. Similarly in Access too, you can include Ms Office data files like a word documents by using the OLE field type. There maybe many scenarios where you may need to include a world file in an Access database. Imagine you are creating an employee database and wish to...

Read more »

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 »