Exam 3: Performing Calculations With Formulas and Functions

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

When working in Table Datasheet view,which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

Query Design view presents the fields you can use for a query in small windows called field _____.

In Query Design view,the _____ shows you the field names,sort orders,and criteria used with a query.

Which of the following can you change when formatting a table?

How do you display the records in a subdatasheet?

In Table Datasheet view,a(n)_____ shows the records on the "many" side of a one-to-many relationship.

Hiding a column in Table Datasheet view is that same as freezing the column.

Add a Number field to a table to store values that represent money.

Before you close a query datasheet,you must save your changes to the data.

Which of the following are views you can use to display a query? Select all the options that apply.

A customer has moved to a new address in the same city.What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

What button do you use on the Query Tools Design tab to add a field list to a query?

You can add a Total row to a query datasheet to calculate statistics such as Sum,Average,or Count.

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?

To perform calculations on field values in Table Datasheet view,you click the Totals button in the Records group on the Home tab.

To replace "coffee" with "beverage" in any part of a field,you click the _____ in the Find and Replace dialog box.

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options thatapply.

To create a _____,you add the Total row to the query design grid to specify how to group and perform calculations on the records.