What is an index? Why would you define an index in a table?
What will be an ideal response?
Indexes are created and used to increase performance. For example, if you repeatedly search or sort your data on a specific field, you could create an index to speed up the procedure. An index in Access is similar to an index in a book. It is a lot easier and faster to find a topic in a book's index than having to search through the book page by page to locate what you need. By creating an index for a field or fields in a table, Access can quickly locate all the records that contain specific values for those fields without having to read through each record in the table.
You might also like to view...
Classes enable programmers to model objects that have ___________ (represented as data members) and behaviors (represented as )_______.
Fill in the blank(s) with the appropriate word(s).
____ is a special effect that is created by reducing the number of colors available for the image.
A. Blur B. Reduction C. Posterize D. Compress
PowerPoint goes one step better by enabling you to ________, or make notations or marks on the slides during your presentation
Fill in the blank(s) with correct word
In the Datasheet view, Yes/No fields are displayed as a(n):
A) Spin box. B) Option button C) Action button. D) Check box.