Devry BIS245 Week 4 Chapter 3 Quiz Latest 2021 March

BIS245 Database Essentials for Business with Labs

Week 4 BIS245 Chapter 3 Quiz

1              Which of the following is used to locate data in a database?

2              Which of the following Ribbon tabs do you use to create a query?

3              Which of the following functions finds the total value of a field?

4              Which of the following functions finds a specific number of characters from the left of the field?

5              How does Access evaluate a criterion expression that just includes a criteria value?

6              Which of the following functions converts a value to uppercase?

7              Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

8              Which of the following functions counts the number of records that have a value in the field?

9              Which of the following comparison operators means "similar to this value"?

10           Which of the following functions rounds a value?

11           How many fields can you add to the query design grid?

12           Which of the following functions performs a comparison and does one of two alternatives?

13           Which of the following logical operators requires that a record meet all the individual conditions specified in order to be included in the results?

14           What should you use to write criterion into a query?

15           Which of the following keyboard shortcuts opens the Save As dialog box?

16           Which of the following cannot be changed in Datasheet view of a query?

17           What determines the type of criterion you enter, along with the way you enter the criterion?

18           What is created when values are entered on the same Criteria row of the query design grid?

19           Which of the following should you add into a query to search for records that meet a specific value?

20           Which of the following requires you to enter the specific criteria value when you run the query?