Question

how can you speed up access of data and instructions?​

Answer 1

Answer:

Try these five tips to boost the speed of your database:

Make sure all of your tables have primary keys. Running a table without a primary key is like running a four-cylinder engine with only two active pistons. ...

Optimize by adding secondary indexes. ...

Be like an atom and split. ...

Use Compact and Repair. ...

Load only what you need.

Answer 2

Answer:

Help Access run faster

• In this article. ...

• Help improve performance of a local database. ...

• Turn off Name AutoCorrect. ...

• Set the database to compact and repair automatically. ...

• Open the database in exclusive mode. ...

• Turn off AutoCorrect options. ...

• Help improve performance in a multiuser environment. ...

• Split the database.