MATCH EACH TERM WITH THE STATEMENT THAT BEST DESCRIBES IT: 8. Record Source a. P
ID: 452201 • Letter: M
Question
MATCH EACH TERM WITH THE STATEMENT THAT BEST DESCRIBES IT:
8. Record Source a. Placing the records of a datasheet in a certain order
9. Select query b. Entered on more than one row of the query design grid
10. Wildcard character c. Report property that determines what fields and
records the report will display
11. AND criteria d. Asterisk ( * ) or question mark ( ? ) used in query criteria
12. Sorting e. Retrieves fields from related tables and displays records
in a datasheet
13. OR criteria f. Entered on one row of the query design grid
SELECT THE BEST ANSWER FROM THE LIST OF CHOICES:
14. The query datasheet can best be described as a:
a. Logical view of the selected data from underlying tables.
b. Duplication of the data in the underlying table’s datasheet.
c. Separate file of data.
d. Second copy of the data in the underlying tables.
15. Queries may not be used to:
a. Calculate new fields of data.
b. Set the primary key field for a table.
c. Enter or update data
d. Sort records.
16. When you update data in a table that is also selected in a query:
a. You must relink the query to the table to refresh the data.
b. The updated data is automatically displayed in the query.
c. You must also update the data in the query datasheet.
d. You can choose whether to update the data in the query.
17. Which of the following is not an aggregate function available to a summary query?
a. Avg
c. Count
b. Subtotal
d. Max
18. The order in which records in a query are sorted is determined by:
a. The order in which the fields are defined in the underlying table.
b. The importance of the information in the field.
c. The alphabetic order of the field names.
d. The left-to-right position of the fields in the query design grid that contain a sort order choice.
19. A crosstab query is generally constructed with how many fields?
a. 1
b. 3
c. 2
d. More than 5
20. In a crosstab query, which field is the most likely candidate for the Value position?
a. FName
b. Department
c. Cost
d. Country
Explanation / Answer
8. Record Source :e) Retrieves fields from related tables and displays records
9. Select query : d. Asterisk ( * ) or question mark ( ? ) used in query criteria
10. Wildcard character :f) Entered on one row of the query design grid
11. AND criteria : c. Report property that determines what fields and records the report will display
12. Sorting : a. Placing the records of a datasheet in a certain order
13. OR criteria : b. Entered on more than one row of the query
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
14. The query datasheet can best be described as a:
a. Logical view of the selected data from underlying tables.
b. Duplication of the data in the underlying table’s datasheet.
c. Separate file of data.
d. Second copy of the data in the underlying tables.
Answer :
a. Logical view of the selected data from underlying tables
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
15. Queries may not be used to:
a. Calculate new fields of data.
b. Set the primary key field for a table.
c. Enter or update data
d. Sort records.
Answer :
b. Set the primary key field for a table.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
16. When you update data in a table that is also selected in a query:
a. You must relink the query to the table to refresh the data.
b. The updated data is automatically displayed in the query.
c. You must also update the data in the query datasheet.
d. You can choose whether to update the data in the query.
Answer :
b) The updated data is automatically displayed in the query.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
17. Which of the following is not an aggregate function available to a summary query?
a. Avg
c. Count
b. Subtotal
d. Max
Answer:
b. Subtotal
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
18. The order in which records in a query are sorted is determined by:
a. The order in which the fields are defined in the underlying table.
b. The importance of the information in the field.
c. The alphabetic order of the field names.
d. The left-to-right position of the fields in the query design grid that contain a sort order choice.
Answer :
a. The order in which the fields are defined in the underlying table.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
19. A crosstab query is generally constructed with how many fields?
a. 1
b. 3
c. 2
d. More than 5
Answer :
b 3
------------------------------------------------------------------------------------------------------------------------------------------------------------------
20. In a crosstab query, which field is the most likely candidate for the Value position?
a. FName
b. Department
c. Cost
d. Country
Answer :
A FName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.