Deck 3: Performing Calculations With Formulas and Functions

Question 1

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

Answer 1

True

Question 2

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

Answer 2

A

Question 3

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

Answer 3

True

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 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 6

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 7

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.

Question 8

To filter for comparative data,use the _____ feature.

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

Question 9

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

Question 10

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 11

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 12

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

Question 13

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 14

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 15

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

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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 26

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 27

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

Question 28

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 29

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 30

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 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

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 33

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 34

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 35

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

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 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 38

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 39

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

Question 40

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 41

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 42

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

Question 43

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 44

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 45

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 46

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 47

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 48

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

Question 49

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

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

Question 50

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 51

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

Question 52

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 53

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 54

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 55

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

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

Question 56

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 57

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

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

Question 58

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 59

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

Question 60

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