Which of the following is true about the Simple Query Wizard? Select one: a. It

Question

Which of the following is true about the Simple Query Wizard?

Select one:

a. It doesnt allow you to take advantage of all of the options available when creating a query.

b. It lets you take full advantage of all the options available when creating a query.

c. It provides great flexibility when creating queries.

d. Most people create queries using the Simple Query Wizard.

Question 22

Not yet answered

Scored out of 1.00

Flag question

Question text

When you use a wildcard, the criterion of your expression must be enclosed in parentheses.

Select one:

a. True

b. False

Question 23

Not yet answered

Scored out of 1.00

Flag question

Question text

When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?

Select one:

a. at the end

b. at the beginning

c. at the beginning and end

d. any of the above

Question 24

Not yet answered

Scored out of 1.00

Flag question

Question text

What name does Access assign to new queries?

Select one:

a. Query

b. Query1

c. QueryData1

d. QueryResults1

Question 25

Not yet answered

Scored out of 1.00

Flag question

Question text

Access refers to formulas as criterion.

Select one:

a. True

b. False

Question 26

Not yet answered

Scored out of 1.00

Flag question

Question text

Which of the following is added to the Design grid of a summary query?

Select one:

a. AND operator

b. OR operator

c. Total row

d. Count function

Question 27

Not yet answered

Scored out of 1.00

Flag question

Question text

Which of the following comparison operators means "Contained in this list of values"?

Select one:

a. <>

b. Between

c. In

d. Like

Question 28

Not yet answered

Scored out of 1.00

Flag question

Question text

You can create a query in Design view or with the Query Wizard.

Select one:

a. True

b. False

Question 29

Not yet answered

Scored out of 1.00

Flag question

Question text

When you build a query you must tell Access where to find the data.

Select one:

a. True

b. False

Question 30

Not yet answered

Scored out of 1.00

Flag question

Question text

Which of the following is a valid criterion for the Number data type?

Select one:

a. 5

b. $5

c. 5t

d. 5n

Explanation / Answer

Which of the following is true about the Simple Query Wizard?

Select one:

a. It doesnt allow you to take advantage of all of the options available when creating a query.

b. It lets you take full advantage of all the options available when creating a query.

c. It provides great flexibility when creating queries.

d. Most people create queries using the Simple Query Wizard.

Answer: c)It provides great flexibility when creating queries.

When you use a wildcard, the criterion of your expression must be enclosed in parentheses.

Select one:

a. True

b. False

Answer: a.True

When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?

Select one:

a. at the end

b. at the beginning

c. at the beginning and end

d. any of the above

Answer: d. any of the above

What name does Access assign to new queries?

Select one:

a. Query

b. Query1

c. QueryData1

d. QueryResults1

Answer: a. Query

Access refers to formulas as criterion.

Select one:

a. True

b. False

Answer: a.True

Which of the following is added to the Design grid of a summary query?

Select one:

a. AND operator

b. OR operator

c. Total row

d. Count function

Answer: a.AND operator

Which of the following comparison operators means "Contained in this list of values"?

Select one:

a. <>

b. Between

c. In

d. Like

Answer: a.<>

You can create a query in Design view or with the Query Wizard.

Select one:

a. True

b. False

Answer: a.True

When you build a query you must tell Access where to find the data.

Select one:

a. True

b. False

Answer: a.True

Which of the following is a valid criterion for the Number data type?

Select one:

a. 5

b. $5

c. 5t

d. 5n

Answer: a.5

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.