WHAT ARE THE STEPS TO BE TAKEN FOR IMPROVING PERFORMANCE IN MICROSOFT ACCESS DATABASE?

Arun Singh

Total Post:310

Points:1550
Posted by  Arun Singh
 4094  View(s)
Ratings:
Rate this:
  1. Arun Singh

    Post:310

    Points:1550
    What are the steps to be taken for improving performance in Microsoft Access database?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!