Access Database Recovery

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 »

Think Before you Choose a Primary Key in Ms Access

The Ms Access application has a wide user base and it includes both professional programmers and average computer users. In fact the number of people, ranging from office executives to small business owners, using the Ms Access database base with very little technical knowledge is considerably high. While using the Ms Access application is extremely easy, the lack of technical knowledge can cause hassle at times. Take the case of selecting a primary key while creating a table to store records....

Read more »