Deck 2: Querying a Database

Question 1

To sort resards 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

Answer 1

C

Question 2

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

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

Answer 2

C

Question 3

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

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

Answer 3

A

Question 4

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate salumn.

A) Rob#n
B) Rob%n
C) Rob$n
D) Rob?n

Question 5

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

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

Question 6

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

A) S?
B) S*
C) S#
D) S&

Question 7

To save a query, tap or 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 8

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

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

Question 9

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

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

Question 10

If 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
C) 0
D) $0.00

Question 11

In the acsampanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

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

Question 12

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

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

Question 13

In the acsampanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

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

Question 14

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 15

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due salumn.

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

Question 16

In the acsampanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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

A) sampound sanditions
B) samparison operators
C) sampound values
D) sanditions

Question 21

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

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

Question 22

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 23

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 24

To calculate statistics for only those resards 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 25

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

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

Question 26

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

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

Question 27

To use the Expression Builder to create a calculated field, select the salumn 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 28

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

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

Question 29

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

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

Question 30

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 31

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 32

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

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

Question 33

In the acsampanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.

A) infinity
B) join
C) sannector
D) inner

Question 34

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

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

Question 35

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

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

Question 36

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 37

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

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

Question 38

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 39

The acsampanying figure illustrates using a query to ____ tables; that is, to find resards in two tables that have identical values in matching fields.

A) sambine
B) sancatenate
C) interleave
D) join

Question 40

In the acsampanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

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

Question 41

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

Question 42

The arithmetic symbols for use in query calculations are ____.

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

Question 43

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 44

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

Question 45

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 46

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

Question 47

To find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42, enter each criterion on the same row.

Question 48

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

Question 49

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

Question 50

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 51

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

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

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

Question 56

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

Question 57

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

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

Question 58

In the acsampanying figure, Book Rep Number is the ____ key.

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

Question 59

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

Question 60

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

Question 61

The results of a query display in ____________________ view.

Question 62

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

Question 63

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

Question 64

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

Question 65

Grouping means creating groups of resards that share some sammon characteristic.

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

You cannot create a report for a query.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

When you sort data, duplicates are not included.

Question 78

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

Question 79

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

Question 80

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