Exam 18: Maintaining and Querying a Database

​ The deletion of a record is temporary and can be undone.

In Microsoft Access 2016, the _________ is the "many" table in a one-to-many relationship. A)primary table B)secondary table C)related table D)access table

In Microsoft Access 2016, the _____ determines the number of records selected. ​

Which of the following is true of working with queries in Microsoft Access 2016? ​

In Microsoft Access 2016, the Query Design button appears on the _____. ​

In Microsoft Access 2016, the _________ is the "one" table in a one-to-many relationship. A)related table B)primary table C)secondary table D)access table

In Microsoft Access 2016, queries cannot be based on multiple tables. ​

In the accompanying figure of a Microsoft Access 2016 document, which of the following symbols is Box 1 pointing to? ​ ​

In Microsoft Access 2016, _________ are used to extract data from a datasheet based on a field value. A)conditional filters B)common filters C)field sorters D)record sorters

In Microsoft Access 2016, _________ are the conditions that determine which records are selected in a query. A)Lookup Fields B)criteria C)Macros D)modules

​ In Microsoft Access 2016, you can specify a format for a calculated field, just as you can for any field, by modifying its properties.

In the accompanying figure of a Microsoft Access 2016 document, which of the following boxes is pointing to the Alternate Row Color button? ​ ​

In Microsoft Access 2016, _________ is a query that retrieves the information that precisely matches the example you provide of the information being requested. A)Simple Query Wizard B)detail query C)Query by example D)sample query

Marcus, a professor, uses Microsoft Access 2016 to retrieve and refine the records in a database that stores students' information. He wants to view the list of students whose percentage ends with .99. Which of the following operators should Marcus use to retrieve the list? ​

In Microsoft Access 2016, hiding a field's values removes the field from the query design. ​

Identify an accurate statement about deleting a record in Microsoft Access 2016. ​

Which of the following statements is true of creating a copy of a query in Microsoft Access 2016? ​

In Microsoft Access 2016, the _________ divides the selected records into groups based on the values in the specified field. A)Group By operator B)Query by example C)select group query D)detail query

Which of the following is true of storing calculations in a table in Microsoft Access 2016? ​

In Microsoft Access 2016, the count function determines the total of the field values for the selected records.