Deck 4: Access: Querying a Database

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

To find all clients whose amount paid is greater than $20,000.00 or whose recruiter is recruiter 21, enter each criterion on the same line.

Question 5

To find all clients whose amount paid is greater than $20,000.00 and whose recruiter is recruiter 21, enter each criterion on the same line.

Question 6

Only the fields that appear in the design grid are included in the results of the query.

Question 7

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

Question 8

To run a saved query, right-click the query in the Navigation Pane and click Open on the shortcut menu.

Question 9

When you sort data, duplicates normally are included.

Question 10

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 11

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 12

To save a query, the query design must appear on the screen.

Question 13

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

Question 14

An inner join is the default join in Access.

Question 15

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

Question 16

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 17

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

Question 18

You create a parameter by enclosing a value in a criterion in curly braces ({}).

Question 19

To remove a table from a query, right-click the field list and then click Drop Table on the shortcut menu.

Question 20

To search for a range of values in one field, use the RANGE operator.

Question 21

A field name used in a calculation always must be enclosed in square brackets.

Question 22

To print a query without first opening it, select the query in the Navigation Pane and then click the Office Button, point to Print on the Office Button menu, and then click ____ on the Print submenu

A)Quick Print
B)Print Query
C)Preview Query
D)Run and Print

Question 23

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

Question 24

You can click either the View button or the ____ button on the Ribbon to execute a query.

A)Run
B)Execute
C)Select
D)Results

Question 25

A field that can be computed from other fields is called a calculated field.

Question 26

To use the Simply Query wizard to create a query, click the ____ tab on the Ribbon and then click the Query Wizard button.

A)Design
B)Home
C)Database Tools
D)Create

Question 27

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

Question 28

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

Question 29

Parameter queries are useful for summarizing data.

Question 30

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

A)Customize
B)Options
C)Security
D)Warning

Question 31

To organize the Navigation Pane by type of object rather than table, click Organize by Object on the Navigation Pane menu.

Question 32

Figure 2-1 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)Remove Table
D)Erase Table

Question 33

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 34

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

Question 35

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

Question 36

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 37

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

Question 38

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

Question 39

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

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

Question 40

Figure 2-1 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)Field List
C)Select Table
D)Show Table

Question 41

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 42

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

A)Use
B)Manipulate
C)Run
D)Open

Question 43

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

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

Question 44

Figure 2-1 In the accompanying figure, you can enter FD89 in the ____ row of the Client Number field to find all clients whose client number is FD89.

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

Question 45

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 46

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

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

Question 47

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

A)T?m
B)T#m
C)T$m
D)T&m

Question 48

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)merge
D)join

Question 49

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

A)> 10000
B)> $10000
C)> 10,000
D)> $10,000

Question 50

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

A)=20,000
B)20,000
C)=$20,000
D)20000

Question 51

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 52

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

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

Question 53

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 54

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

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

Question 55

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 56

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)Zoom
C)Magnify
D)Resize

Question 57

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

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

Question 58

Figure 2-1 In the accompanying figure, you can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.

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

Question 59

Figure 2-1 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 60

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 61

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

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

Question 62

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

Question 63

If there are no restrictions involved in the query, nor any special order or calculations, you can use the ____________________ wizard.

Question 64

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

Question 65

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

A)AVG
B)Average
C)VAR
D)Median

Question 66

Figure 2-4 The View button menu appears in the accompanying figure. To change the design of a query, click the ____________________ button on the menu.

Question 67

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

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

Question 68

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

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

Question 69

The ____________________ wildcard represents any collection of characters.

Question 70

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 71

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 72

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

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

Question 73

The ____________________ wildcard represents any individual character.

Question 74

A(n)____________________ is a condition that the records to be included in a query must satisfy.

Question 75

To find all clients whose names begin with Be, enter ____________________ as the criterion for the Client Name field.

Question 76

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 77

Figure 2-4 The View button menu appears in the accompanying figure. To see the results of a query, click the ____________________ button on the menu.

Question 78

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

Question 79

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)Property Sheet
B)Caption
C)Query
D)Format

Question 80

To include the Total row in the design grid, click the _____ button on the Design tab.

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