Exam 18: Maintaining and Querying a Database

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. To retrieve details of all the products with a ProductName field value of "Briston" or a RetailPrice value not equal to $10, Anna should enter:

In the accompanying figure of a Microsoft Access 2016 document, the criteria mentioned in the AgreementValue field yields query results that include records with a value _____. ​ ​

Explain property sheets in Microsoft Access 2016.

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

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

​ Zoya, a manager, uses Microsoft Access 2016 to manage employee details. To retrieve information about all the employees with AgreementValue not equal to $50,000, she should enter _____ in the Criteria row in the AgreementValue column.

In Microsoft Access 2016, _________ is the process of rearranging records in a specified order or sequence. A)storing B)compacting C)sorting D)filtering

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. To retrieve the details of all the students with an Age field value greater than 21 but less than or equal to 24, Emily should enter _____ in the Criteria row in the Age column in the design grid.

In Microsoft Access 2016, to create a query that retrieves data from multiple tables, the tables must have unique fields.

In Microsoft Access 2016, a _________ is a query based on more than one table. A)doubletable query B)endtable query C)inherittable query D.  multitable query

In the accompanying figure of a Microsoft Access 2016 document, Box A points to a _____. ​

Sarah, a manager, uses Microsoft Access 2016 to manage employee details. She enters "Dan" in the Criteria row in the FirstName column and "Smith" in the same Criteria row in the LastName column in the design grid. In this case, the query datasheet, created by Sarah, will include the records for employees with a FirstName field value _____. ​

In Microsoft Access, the _________ is the field used to determine the order of records in the datasheet. A)common field B)sort field C)calculated field D)data field

In Microsoft Access 2016, the answer to a select query is returned in a query datasheet. ​

James, a manager at Sugar Maple Inc., uses Microsoft Access 2016 to retrieve flight details. He wants to obtain information about all the flights except those with a SourceCity field value not equal to "Wisbane" To get the information, James should type _____ in the Criteria row in the SourceCity field. ​

Identify a true statement about modifying queries in Microsoft Access 2016. ​

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. To retrieve details of all the products with a RetailPrice field value equal to $10 and an OfferPrice field value not equal to $8, Anna should enter:

​ Explain database record maintenance in Microsoft Access 2016.

To create a query with the And logical operator i n Microsoft Access 2016, _____. ​

In Microsoft Access 2016, a(n) _________ is a query in which you specify the fields and records you want Access to choose. A)action query B)select query C)parameter query D)aggregate query