Deck 3: Performing Calculations With Formulas and Functions

Question 1

What should you do before applying a new filter to a datasheet?

A) Switch to Query Design view.
B) Change the sort order of the records.
C) Save the previous filters.
D) Clear all previous filters.

Answer 1

D

Question 2

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

Answer 2

True

Question 3

To filter for comparative data, use the _____ feature.

A) Filter By Selection
B) Filter By Form
C) Clear Filter
D) Calculate Data

Answer 3

B

Question 4

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

A) Look in arrow
B) Match arrow
C) Search Fields as Formatted check box
D) Match Case check box

Question 5

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

Question 6

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

Question 7

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

Question 8

A _____ is a saved object within the database, whereas a _____ is temporary.

A) criterion; wildcard
B) field; record
C) query; filter
D) selection; form

Question 9

To add, delete, or change fields in a query, you use Query Design view.

Question 10

Use Query Design view to display the results of a query.

Question 11

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

Question 12

The easiest way to filter the records for an exact match is to use the _____ feature.

A) Filter By Form
B) Advanced Filter
C) Find and Replace
D) Filter By Selection

Question 13

To apply the last filter you selected to a datasheet, you click the _____ button.

A) Clear All Filters
B) Remove Filter
C) Toggle Filter
D) Repeat Filter

Question 14

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

A) categories
B) filters
C) properties
D) lists

Question 15

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

A) sort orders
B) listings
C) layouts
D) criteria

Question 16

Sorting a table datasheet temporarily displays only those records that match given criteria.

Question 17

In a datasheet, you can find data, but not replace it.

Question 18

To delete a field from a query, drag the field out of its field list.

Question 19

How do you display the results of a query listed in the Navigation Pane?

A) Right-click the query, and then click Design View on the shortcut menu.
B) Right-click the query, and then click Run on the shortcut menu.
C) Double-click the query.
D) Click the query, and then click the Open button in the Navigation Pane.

Question 20

A query is a temporary view of the data that is removed when you close the query in Query Design view.

Question 21

One way to format a form is to set the alternate record color of the form in Form Layout view.

Question 22

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?

A) to the right of the City field
B) to the left of the City field
C) in the first column of the query design grid
D) below the City field

Question 23

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?

A) [DiscountPrice]: Price-10
B) [Price]-10=DiscountPrice
C) DiscountPrice: [Price]-10
D) DiscountPrice: [Price]*10

Question 24

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

A) record selector
B) field list
C) field selector
D) Criteria row

Question 25

What happens when you run a query from Query Design view?

A) Access displays the query in Print Preview.
B) Access clears the query design grid.
C) Access creates a report based on the query.
D) Access displays a datasheet containing the query results.

Question 26

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?

A) Modify Function
B) Modify Expression
C) Modify Calculation
D) Modify Data Type

Question 27

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

A) Query Design view
B) Query Datasheet view
C) Query Print Preview
D) SQL view

Question 28

Which of the following are ways to run a query? Select all the options that apply.

A) Right-click a query in the Navigation Pane, and then click Run.
B) Double-click the query in the Navigation Pane.
C) Click the Run button in Query Design view.
D) Click the View button in Query Design view.

Question 29

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

A) Field List button
B) Show Table button
C) View button
D) Table Names button

Question 30

Which of the following options are available as you filter a datasheet? Select all the options that apply.

A) Filter By Form
B) Filter By Selection
C) Save the Filter
D) Clear All Filters

Question 31

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

A) Query Tools Design tab on the ribbon
B) upper pane
C) Navigation Pane
D) query design grid

Question 32

Access adds @ signs around date criteria in Date/Time fields.

Question 33

How can you list the records in a query datasheet in A-Z order by CustomerName?

A) Click a value in the CustomerName field, and then click the Descending button.
B) Click a value in the CustomerName field, and then click the Ascending button.
C) Click the Advanced button, and then click Filter By Form.
D) Click the CustomerName column heading.

Question 34

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?

A) Simple Query Wizard
B) Find and Replace
C) Filter By Form
D) query design grid

Question 35

What might you need to do after increasing the font size in a table datasheet?

A) Change the field sizes in Table Design view.
B) Widen the columns.
C) Check the spelling of the data.
D) Reset table relationships.

Question 36

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

A) number of rows
B) page numbers
C) number of columns
D) background color

Question 37

Which of the following statements describe Query Design view? Select all the options that apply.

A) Field lists appear in the upper pane of Query Design view.
B) Query Design view shows the SQL code for the query.
C) The query design grid provides a way to sort records.
D) Query Design view lets you modify an existing query.

Question 38

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

A) field size
B) font
C) background color
D) font color

Question 39

Which of the following statements describe a filter? Select all the options that apply.

A) In a datasheet, a filter displays only those records that match criteria you specify.
B) Access saves filters when you click the Toggle Filter button.
C) A filter displays a temporary subset of records in the current datasheet.
D) A filter is not as powerful as a query.

Question 40

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

A) %5/7/2021%
B) >5/7/2021<
C) #5/7/2021#
D) "5/7/2021"

Question 41

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

Question 42

You can add fields to a form in Design view or _____.

A) Layout view
B) Form view
C) Print Preview
D) Datasheet view

Question 43

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

A) The Bonus field is removed from all objects based on the Employees table.
B) Only the Bonus column heading appears in the Employees datasheet.
C) The Bonus column no longer appears in the datasheet, but is still part of the Employees table.
D) The Bonus column moves to the end of the datasheet.

Question 44

What data type is most appropriate for a field named PaymentAmt?

A) Number
B) Currency
C) AutoNumber
D) Input Mask

Question 45

When you delete a column from a table in Table Datasheet view, you delete the field and all of its data.

Question 46

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?

A) the company name of each employer
B) the positions offered by each employer
C) details about the employer with the most positions
D) the names of employers offering no positions

Question 47

What does the criterion <=200 mean?

A) less than or equal to 200
B) less than 200
C) greater than or equal to 200
D) not equal to 200

Question 48

You use a subdatasheet to modify a field's properties.

Question 49

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

Question 50

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

Question 51

How do you display the records in a subdatasheet?

A) You click the expand button in the datasheet.
B) You click the record selector button in the datasheet.
C) You click the Relationships button on the Database Tools tab.
D) You widen all the fields in the datasheet.

Question 52

Which of the following statements are true about subdatasheets? Select all the options that apply.

A) They appear for a table on the "one" side of a one-to-many relationship.
B) You can click the expand button to view the records in a subdatasheet.
C) You can click the Sub button to display the subdatasheets in any table.
D) You can use a subdatasheet to enter new records.

Question 53

What criterion would you use to find numbers greater than or equal to 100?

A) <=100
B) <>100
C) >+100
D) >=100

Question 54

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

A) infinity symbol
B) field list
C) subdatasheet
D) primary key symbol

Question 55

Which of the following are examples of correct criteria syntax? Select all the options that apply.

A) <= "12/31/2020"
B) >= #1/1/2021#
C) < "Anderson"
D) <= 33.50

Question 56

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

Question 57

Use a Number field to store values that represent money.

Question 58

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

Question 59

What are you doing when you enter data into a subdatasheet?

A) You are entering properties for the fields.
B) You are creating an alternate view of the data.
C) You are enforcing referential integrity.
D) You are entering records in the related table.

Question 60

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

Question 61

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.

A) Sum
B) Average
C) Count
D) Index

Question 62

You use the Field List to add fields to a form in Form Design view.

Question 63

The Alternate Background Color command changes the background color of alternate records in a selected section.

Question 64

What can you add to a query datasheet to display statistics for a group of records?

A) Statistics row
B) grouping field
C) Total row
D) calculated field

Question 65

To create a banded rows effect in a report, you _____.

A) apply a table style to the report
B) set the alternate row color of a report section
C) insert a background image
D) change the column layout

Question 66

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

A) Total
B) Sum
C) Count
D) Avg

Question 67

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

A) select query
B) subtotal query
C) statistics query
D) summary query

Question 68

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

Question 69

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