CA CH12 Exam

Which button is used to the clear the filter in the active datasheet

toggle filter

When multiple criteria are on the same row in the query design grid, it is referred to as _______ statement, meaning that ALL criterion must be met to be selected

AND

which of the following is a valid query expression to calculate an amount by multiplying the value in the field name Qty times the value in the field name Price and title the column Amount

Amount: [Qty]*[Price]

Which key can be used to open a field for editing in a table

F2

When multiple criteria are on different rows in the query design grid, it is referred to as a _________ statement, meaning that any criterion can be met for a record to be selected.

OR

What does the run button on the query tools design tab do

access to produce the query results

which feature adjusts the width of the column to accommodate the longest entry

best fit

What does DBMS stand for

database management system

Query results display in a

datasheet

Every access object has at least two views: a data view and a _________ view

design

You opened a table with thousands of records and need to locate one specific person to edit his phone number. What feature will you use to move to the correct record quickly

find

You have a table for invoices with a field name Paid? that displays a check box in the datasheet. Checked boxes mean that the invoice is paid. What would you type in the criteria box in a query to instruct access to show you only those records where the check box is empty (not paid)

no

Generally, a form displays

one record at a time, in a columnar layout

A ___ is a field that contains the data that uniquely identifies each record in a table

primary key

Which task pane do you open to change the format of a calculated field to currency?

property sheet

To add a new record to a table, open the table and click the New (blank) record button in the

record navigation bar

in which group on the home tab will you find the delete button to delete the selected record from the database

records

to see all the records for library fines issued on the first day of march in 2021, you type March 1. 2021 in the criteria box of the dateIssued field. How does Access display your entry after you press Enter?

#3/1/2021#

The _________ helps you create a query by asking you for your information in a series of dialog boxes

simple query wizard

in which access object is data stored

tables