Deck 12: Access_Module_2

Question 1

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

A)Caption
B)Property Sheet
C)Field Name
D)Format

Answer 1

B

Question 2

The ____ operator allows you to search for a range of values in one field.

A)BETWEEN
B)RANGE
C)IN
D)SEARCH

Answer 2

A

Question 3

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

A)FILE
B)CREATE
C)DATABASE TOOLS
D)EXTERNAL DATA

Answer 3

D

Question 4

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

A)Datasheet View
B)Layout View
C)Change View
D)Design View

Question 5

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

A)Datasheet View
B)Design View
C)Open
D)Run

Question 6

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

A)colon (:)
B)semi-colon (;)
C)equal sign (=)
D)exclamation point (!)

Question 7

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

A)curly braces { }
B)square brackets [ ]
C)parentheses ( )
D)single quotes ''

Question 8

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

A)Use Parameter
B)Enter Values
C)Open
D)Run

Question 9

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

A)Show
B)List
C)Sort
D)Order

Question 10

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

A)compound conditions
B)comparison operators
C)compound values
D)conditions

Question 11

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

A)DATABASE TOOLS
B)EXTERNAL DATA
C)OFFICE EXPORT
D)CREATE

Question 12

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

A)Expression Builder
B)Builder box
C)Build
D)Field Builder

Question 13

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

A)Preview
B)Query
C)Print Query
D)Print

Question 14

To save a query, click the Save button on the ____.

A)status bar
B)Quick Access Toolbar
C)CREATE tab on the ribbon
D)HOME tab on the ribbon

Question 15

To order the records in the answer to a query in a particular way, you ____ the records.

A)index
B)sort
C)arrange
D)list

Question 16

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

A)CREATE
B)DATABASE TOOLS
C)REPORT
D)FILE

Question 17

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

A)Query
B)Design View
C)Query Design
D)Select Query

Question 18

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

A)No
B)Yes
C)Off
D)On

Question 19

You can include ____ in calculations to indicate which calculation should be done first.

A)curly braces { }
B)brackets [ ]
C)parentheses ( )
D)slashes //

Question 20

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

A)Enlarge
B)Resize
C)Magnify
D)Zoom

Question 21

The special criteria that can be used in queries are ____.

A)AND
B)INCLUSIVE
C)BETWEEN
D)IN

Question 22

To create a crosstab, click the ____ button on the CREATE tab.

A)Crosstab Wizard
B)Query Wizard
C)Statistics
D)Chart

Question 23

The asterisk (*) wildcard represents any collection of characters.

Question 24

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Question 25

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Question 26

To enter a number in a criterion, type the number without any dollar signs or commas.

Question 27

The question mark (?) wildcard represents any collection of characters.

Question 28

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

A)Like
B)Where
C)Same
D)Group By

Question 29

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

A)Having
B)Where
C)Restrict
D)Find

Question 30

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

A)Aggregate
B)Statistics
C)Calculations
D)Totals

Question 31

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Question 32

For group calculations, Microsoft Access supports ____ built-in statistics.

A)STDEV
B)VAR
C)MAX
D)LOW

Question 33

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

Question 34

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

A)Large
B)Maximum
C)LGE
D)MAX

Question 35

When you enter text data in a criterion, you must enclose the text in quotation marks.

Question 36

A query that prompts for input whenever it is run is a dialog query.

Question 37

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

A)Objects by Table
B)Table Object
C)Tables and Related Views
D)Default

Question 38

The field or fields on which records are sorted is called the sort key.

Question 39

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.

Question 40

To show the Navigation Pane if it is hidden, click the ____ Button.

A)Show
B)Shutter Bar Open/Close
C)Restore
D)Show/Hide

Question 41

The results of a query display in ____________________ view.

Question 42

A question that is asked of Access or any other database management system is called a(n) ____________________.

Question 43

You cannot create a report for a query.

Question 44

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

Question 45

The expression for a calculated field can be typed directly into the Field row.

Question 46

Wildcards are symbols that represent any character or combination of characters. ____________________

Question 47

To include all fields for a table in the design grid, double-click the ____________________ in the field list.

Question 48

The only calculated fields you can create in Access are those involving addition and subtraction.

Question 49

You can export data from Access to the standard Word format.

Question 50

A property sheet is a window containing the various properties of the object.

Question 51

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

Question 52

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

Question 53

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

Question 54

When you sort data in a query, the records in the underlying table are actually rearranged.

Question 55

Grouping means creating groups of records that share some common characteristic.

Question 56

Crosstab queries are useful for summarizing data by category or group.

Question 57

When you sort data, duplicates are not included.

Question 58

A summary function is a function that performs some mathematical function against a group of records. ____________________

Question 59

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

Question 60

To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________

Question 61

The ____________________ function finds the smallest value in a group of records.

Question 62

Critical Thinking Questions
Case 2-1
PrattLast needs to gather some additional statistics on its managers. A manager at PrattLast has created an initial query that calculates the accounts located in specific cities. The manager is unsure what aggregate functions to use for additional calculations.
Which aggregate function will find the standard deviation?

Question 63

In ____________________ files, the width of any field is the same on every record.

Question 64

____________________ are symbols that represent any character or combination of characters.

Question 65

Case 2-2
PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015.
What criteria should PrattLast enter in the Start Date column of the design grid?

Question 66

A(n) ____________________ function is a function that performs some mathematical function against a group of records.

Question 67

To combine criteria with ____________________, place the criteria on the same row.

Question 68

The ____________________ wildcard represents any collection of characters.

Question 69

Case 2-2
PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015.
The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

Question 70

The ____________________ wildcard represents any individual character.

Question 71

A(n) ____________________ query is a query that prompts for input whenever it is used.

Question 72

A(n) ____________________ is a window containing the various properties of the object.

Question 73

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Question 74

Critical Thinking Questions
Case 2-1
PrattLast needs to gather some additional statistics on its managers. A manager at PrattLast has created an initial query that calculates the accounts located in specific cities. The manager is unsure what aggregate functions to use for additional calculations.
Which aggregate function will find the customer with the largest amount paid?

Question 75

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.