Home > DeveloperSection > Interviews > What are the steps to be taken for improving performance in Microsoft Access database?

Posted on    March-24-2012 2:43 AM

 MS Access MS Access 
 1 Answer(s)
  3776  View(s)
Rate this:

Arun Singh

Total Post:310

Posted on    March-24-2012 12:00 AM

Few of the steps that can be taken to improve the performance of Microsoft Access Database are as follows:

  1. Plan and Design your tables appropriately as required.
  2. Create Normalized Tables.
  3. Do not create redundant data.
  4. Split your database.
  5. Choose appropriate data types and size for fields.
  6. Create indexes for fields where required.

Don't want to miss updates? Please click the below button!

Follow MindStick