File Recovery

Key Business Functions where Ms Access can be used in a Small Business

The Ms Access application which ships with the Ms Office software suite is typically available with nearly every other small business. While the presence of the software is rather widespread, many small businesses fail to take advantage of this powerful application since they cannot figure out where it may be useful. Instead they resort to using spreadsheets in several areas where a relational database would be the perfect choice. In this article we would look at business scenarios where an Ms...

Read more »

Consider Enforcing Referential Integrity in Ms Access

When we look at the advantages of using relational databases like Access over spreadsheets, we find that their capacity to enforce referential integrity makes a significant difference. For those unfamiliar with the concept of referential integrity, the term essentially refers to shared relationship between multiple tables in an RDBMS. The concept can be best explained with an example. Consider an employee database used for disbursal of salary and other benefits. It has several tables with one...

Read more »

Using SQL in Ms Access – A Primer

The Ms Access application makes database accessible to people without the knowledge of Structured Query Language (SQL). You can easily create queries using the Wizard in Ms Access or develop them in Design view. Yet both these options have limitations and the knowledge of SQL helps in creating modules that are effective in gleaning out relevant information in an effective manner. In this article we would look at using SQL queries in Ms Access.   Ms Access Supports SQL with minor...

Read more »