« previous next »

Author Question: Each query that you create has an underlying SQL statement, which means that even when you create a ... (Read 66 times)

big1devin

  • Hero Member
  • *****
  • Posts: 583
on: Aug 28, 2018
Each query that you create has an underlying SQL statement, which means that even when you create a query in Design view, Access automatically generates the SQL ________ in the background.
 
  Fill in the blank(s) with correct word

Question 2

What is an index? Why would you define an index in a table?
 
  What will be an ideal response?


cupcake16

  • Sr. Member
  • ****
  • Posts: 309
Reply #1 on: Aug 28, 2018
Answer to Question 1

statement

Answer to Question 2

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.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Desert shrubs create distinctive thermal microclimates in the desert landscape Desert shrubs create distinctive thermal microclimates in the desert landscape
Primary aging means changes in hair color and skin texture for almost everyone. Primary aging means changes in hair color and skin texture for almost everyone.
In the summer of 1793, a yellow fever epidemic struck Philadelphia, killing nearly 4,000. Tens of th In the summer of 1793, a yellow fever epidemic struck Philadelphia, killing nearly 4,000. Tens of th
Example of Reconciling a Bank Statement Example of Reconciling a Bank Statement
Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
“Career choice” for many women means leaving their paid jobs for a number of years when they ... “Career choice” for many women means leaving their paid jobs for a number of years when they ...
Video: Digestive chemicals - water, gastric acid, bile & bicarbonate

For a complete list of videos, visit our video library