Access 3 Review Practice Test.

Access 3 Review Practice Test. In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query. - CORRECT ANSWER query design grid How can you list the records in a query datasheet in A-Z order by CustomerName? - CORRECT ANSWER Click a value in the CustomerName field, and then click the Ascending button What are you doing when you enter data into a subdatasheet? - CORRECT ANSWER You are entering records in the related table. . In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table? - CORRECT ANSWER the positions offered by each employer If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid? - CORRECT ANSWER to the right of the City field To replace "coffee" with "beverage" in any part of a field, you click the ____ in the Find and Replace dialog box. - CORRECT ANSWER Match arrow To create a banded rows effect in a report, you _____ - CORRECT ANSWER set the alternate row color of a report section Which of the following can you change when formatting a table? - CORRECT ANSWER background color How do you display the results of a query listed in the Navigation Pane? - CORRECT ANSWER Double-click the query. To filter for comparative data, use the _____ feature - CORRECT ANSWER Filter By Form What should you do before applying a new filter to a datasheet? - CORRECT ANSWER Clear all previous filters What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field? - CORRECT ANSWER DiscountPrice: [Price]-10