Exam 18: Maintaining and Querying a Database

Case 18-1 Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information. Emily wants to retrieve records of students who are from China, Italy, and Mexico. Which of the following operators should Emily use for this purpose?

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected. ​

​ In Microsoft Access 2016, if you want to delete a record from the primary table, you first must delete the related records in the related table.

Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement. Anna types Like "a*" in the Criteria row in the ProductName column and 25 in the same Criteria row in the RetailPrice column. In this case, the query datasheet, created by Anna, will include the records for products with a ProductName field value that :

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

After you run a query, the query datasheet uses a default column name that cannot be changed.

In Microsoft Access 2016, the _________ is the thin bar above each column in the design grid in a Query window that you click to select the entire field. A)Menu bar B)field selector C)query modifier D)Status bar

In Microsoft Access 2016, you can select as many as _____ different sort fields. ​

Robert, a manager, uses Microsoft Access 2016 to retrieve employee details. He types 50000 in the Criteria box in the Salary column in the design grid and runs the query. The results for the query include all the records _____. ​

In Microsoft Access 2016, the _____ determines the total of the field values for the selected records. ​

Raj, a professor, uses Microsoft Access 2016 to manage student details. He enters 50 in the Criteria row in the PhysicsMarks column and 50 in a different Criteria row in the MathMarks column. In this case, the query datasheet, created by Raj, will most likely include the records for students with a PhysicsMarks field value : ​

In Microsoft Access 2016, the Alternate Row Color button appears in the Text Formatting group on the _____. ​

In Microsoft Access 2016, a(n) _________ exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when each record in the second table matches at most one record in the first table. A)one-to-many relationship B)many-to-many relationship C)one-to-one relationship D)many-to-one relationship

In Microsoft Access 2016, calculations, such as sums, averages, minimums, and maximums, cannot be performed on the displayed records using a query datasheet.