Deck 3: Querying a Database

Question 1

Less than ( ), and NOT (not equal to) are examples of _____.

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

Answer 1

B

Question 2

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

Answer 2

B

Question 3

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

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

Answer 3

B

Question 4

To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.

A) Gr..
B) Gr?
C) Gr*
D) Gr&

Question 5

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

A) =2,000
B) 2,000
C) =$2,000
D) 2000

Question 6

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 7

In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).

A) CTRL + DELETE
B) CTRL + Y
C) DELETE
D) CTRL+ALT

Question 8

To use a parameter query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

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

Question 9

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 10

In the accompanying figure, the criterion for Current Due is 0. The query results for this query will display ____ in the Current Due field.

A) 0.00
B) $0
C) 0
D) $0.00

Question 11

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

A) Franc?s
B) Franc*s
C) Franc#s
D) Franc%s

Question 12

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 13

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) Run
D) Open

Question 14

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

A) Quick Access Toolbar
B) Home tab on the Ribbon
C) Create tab on the Ribbon
D) status bar

Question 15

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC7
6)

A) Sort
B) Show
C) or
D) Criteria

Question 16

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $1,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.

A) > $1000
B) > 1000
C) > 1,000
D) > $1,000

Question 17

In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.

A) Add Table
B) Show Table
C) Select Table
D) Field List

Question 18

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

A) query grid
B) design grid
C) criteria grid
D) column grid

Question 19

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

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

Question 20

In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

A) Delete Table
B) Hide Table
C) Erase Table
D) Remove Table

Question 21

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

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

Question 22

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 23

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

A) Properties
B) Join Properties
C) Property Sheet
D) Modify Properties

Question 24

A(n) ____ join is the default join in Access.

A) left outer
B) right outer
C) outer
D) inner

Question 25

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) Criteria
C) Order
D) Sort

Question 26

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 27

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 28

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 29

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) New Report
B) Create
C) Query Report
D) Save as Report

Question 30

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

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

Question 31

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 32

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

A) combine
B) concatenate
C) interleave
D) join

Question 33

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 34

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 35

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) External Data
B) Database Tools
C) Create
D) Office Export

Question 36

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 37

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

Question 38

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 39

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 40

To quit Access, click the ____ button on the right side of the Access title bar.

A) Quit
B) Close
C) Stop
D) Exit

Question 41

In the accompanying figure, Business Analyst Number is the ____ key.

A) major
B) minor
C) primary sort
D) secondary sort

Question 42

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

Question 43

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

Question 44

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

Question 45

To find all clients whose names begin with Gr, enter Gr* in the Criteria row of the design grid.

Question 46

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

Question 47

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

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

Question 48

To find all clients whose amount paid is greater than $1,000.00 and whose business analyst is analyst 11, enter each criterion on different lines.

Question 49

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 50

To find all clients whose amount paid is greater than $1,000.00 or whose business analyst is analyst 11, enter each criterion on the same line.

Question 51

The asterisk (*) wildcard represents any individual character.

Question 52

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

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

Question 53

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

Question 54

In the accompanying figure, Amount Paid is the ____ key.

A) major
B) primary sort
C) minor
D) secondary sort

Question 55

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

Question 56

The arithmetic symbols for use in query calculations are ____.

A) asterisk (*)
B) ampersand (&)
C) slash (/)
D) question mark (?)

Question 57

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

Question 58

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 59

The question mark (?) wildcard represents any individual character.

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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 67

Crosstab queries are useful for summarizing data.

Question 68

You cannot create a form for a query.

Question 69

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

Question 70

When you sort data, duplicates normally are included.

Question 71

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

Question 72

An inner join is the default join in Access.

Question 73

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

Question 74

An aggregate function is a function that performs some mathematical function against a group of records.

Question 75

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

Question 76

You can export to Excel but you cannot export data to a text file.

Question 77

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

Question 78

The results of a query display in ____________________ view.

Question 79

If a Security Warning appears when you open an Access database, click the option ____________________ button.

Question 80

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