File Recovery

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 »

Understanding the Real World Limits of Ms Access and getting the most out of it

In the computing world, striking a balance between user friendliness and performance is a difficult choice to make. Thus software companies typically end up creating different products aimed at distinct target audiences based on their need for ease of use or complex features. In the RDBMS arena, Microsoft has two distinct offerings, the Ms Access application which is essentially targeted at small businesses and the SQL Server application that is targeted at corporate and large organizations. In...

Read more »