Access Database Recovery

8 Key Mistakes to Avoid While Designing Forms in Your Access

In this article we look at key mistakes one needs to avoid while designing forms in Ms Access, especially if you prefer to design forms manually instead of using a Wizard. If you are using Ms Access it is quite logical that now or later you would need to design forms. In this article we show you how easy it is to create forms in Ms Access. One of the most commonly used features of MS Access is AutoForm. A lot of different types of forms can be created with the help of the AutoForm Wizard....

Read more »

How to Effectively Import Data from an Excel Spreadsheet to an Access Database

In this article we look at learning the process of importing data from Ms Excel in Ms Access in an effective manner The Ms Excel application is invariably counted amongst the most popular desktop applications in use today and by far the most widely used spreadsheet tool in the history of computing. Thus it is not surprising to note that many users often use Excel spreadsheets when they should ideally be using Access databases. MS Access might be a little more complicated to use as compared...

Read more »

MS Access Security – Understand the Role the Jet Database Engine Plays

In this article we will examine the role the Jet Database Engine plays in the overall security framework of Ms Access The Security features in MS Access are not considered to be one of the best features of the application. Access is in-fact often looked down as one of the database applications with complicated and difficult to understand security features. To be able to use the security features provided in MS Access for database security, it is important to first understand the concept of...

Read more »