Exam 18: Maintaining and Querying a Database

In Microsoft Access 2016, which of the following occurs when the Ctrl+End keys are pressed? ​

In Microsoft Access 2016, the Total row added to a datasheet cannot be removed.

To create a query with the Or logical operator in Microsoft Access 2016, _____. ​

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

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 the LastName field value beginning with the letter "a" and ending with the letter "n," Emily should enter _____ in the Criteria row in the LastName column in the design grid.

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

In Microsoft Access 2016, _________ is used to filter a datasheet based on a selected field value in a datasheet or form. A)filter by form B)conditional filtering C)autofiltering D)filter by selection

​ How are calculated fields created in Microsoft Access 2016?

In the accompanying figure of a Microsoft Access 2016 document, which of the following fields will not appear in the query results and why? ​ ​ ​

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 except those with the FirstName field value "Andrew," Emily should enter _____ in the Criteria row in the FirstName column in the design grid.

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

_____ is a Microsoft Access tool that makes it easy for you to create a mathematical expression. ​

In Microsoft Access 2016, the order of the fields in the design grid cannot be changed. ​

Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries. Ali retrieves a list of the authors whose names start with the letters "Jef." He wants to filter this result by including names that have only 5 letters. Which of the following should Ali use to retrieve the names that follow both criteria?

Tina, a teacher, uses Microsoft Access 2016 to manage student information. To retrieve the details of all the students who have a TotalScore field value of greater than 70 but less than or equal to 85, she should enter the condition _____ in the Criteria row in the TotalScore field. ​

In Microsoft Access 2016, the Builder button appears in the _____ on the Query Tools Design tab. ​

In the accompanying figure of a Microsoft Access 2016 document, if you check the option that Box 1 is pointing to, the _____. ​ ​

Case 18-2 Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries. Ali wants to retrieve a record of books whose unit price is not between $30 and $60. Which of the following should Ali use in the Criteria box to retrieve a record that contains a value that is beyond the given range?

Which of the following is a rule of referential integrity? ​

Identify a true statement about working with related data in a subdatasheet in Microsoft Access 2016. ​