Why might you find it necessary to create a query in Design view instead of using the Simple Query Wizard? Explain your reasoning. 

What will be an ideal response?


The Simple Query Wizard does not allow you to use selection criteria when creating a query, set the sort order of the results, or change the order of the fields displayed in the results. If you need to perform any of these tasks, create a query in Design view instead of using a wizard.

Computer Science & Information Technology

You might also like to view...

Which of the following is NOT true about the third part of a custom Yes/No field?

A) This part contains the text to display in place of No, False, or Off values. B) Custom formats can be defined with the exception of colors. C) A semicolon is required between the second and third part. D) This section has an effect on the Yes/No data type.

Computer Science & Information Technology

In a database, the template for a record is referred to as a record ______.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

____ is not a valid C statement.

A. struct {int month; int day; int year;} birth; B. struct {int month; int day; int year;} birth, current; C. struct Date {int month; int day; int year;}; D. struct {int month, int day, int year} birth;

Computer Science & Information Technology

The IEEE standard specifies that the access points and devices can hold up to four shared secret keys, one of which must be designated as the ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology