Deck 1: Access: Creating Advanced Queries and Enhancing Table Design

Question 1

Using a match like the one shown in the above figure is similar to using an exact match except that an exact match includes wildcard characters.

Answer 1

False

Question 2

In the Object Dependencies pane you can click the expand indicator for the collapsible list of dependencies to show or hide different levels of dependencies.

Answer 2

True

Question 3

An easy way to create an input mask is to use the Input Mask Wizard.

Answer 3

True

Question 4

The default character display is left to right but the ! input mask character can be used to reverse that display.

Question 5

Any form or report that uses fields from a query is directly dependent on the query and on any tables that provide data to the query.

Question 6

When you click or select text in many Access text boxes Access displays a list arrow which you can click to display a list box with options.

Question 7

SQL Server and Oracle do not permit spaces in object and field names.

Question 8

The aggregate function Final returns the last field value in a selection of records.

Question 9

When you resize a column to its best fit Access resizes the column so that the widest column heading and the visible field values fit the column width.

Question 10

Property propagation does not occur with queries automatically.

Question 11

Click the Queries option button in the View section of the Crosstab Query Wizard to display the list of queries in the database.

Question 12

The Create tab allows you to switch to Design view.

Question 13

A find unmatched query searches for duplicate values based on the fields you select as you answer the Query Wizard's questions.

Question 14

As shown in the figure above a prompt query prompts you for information when the query runs.

Question 15

If you need to store and display phone numbers zip\postal codes and other fields in a variety of formats it's best to define them as Text fields with an input mask instead of letting users enter field values and the literal display characters.

Question 16

The Top Values property must be an integer.

Question 17

Click the checkbox indicated in the above figure to display an overall totals column in the crosstab query.

Question 18

Users are required to type literal display characters when doing data entry.

Question 19

When you finish all changes to the current record and advance to another record Access detects field validation rule violations.

Question 20

The In comparison operator is roughly equivalent to the use of several And conditions in the design grid.

Question 21

A(n)exact match like the one shown in Figure AC5-1 selects records with a value for the selected field that matches the pattern of the simple condition value.

Question 22

The ____ Mask Wizard is an Access tool that guides you in creating a predefined format for a field.

A)Format
B)Field
C)Input
D)Display

Question 23

Figurative display characters are the special characters that automatically appear in specific positions of a field value.

Question 24

If you convert an Access database to SQL Server your select queries will most likely not work.

Question 25

You can change a select query to a crosstab query in Design view using the Crosstab button in the Database group on the Query Tools Design tab.

Question 26

The aggregate function First returns the first field value in a selection of records.

Question 27

If you want to display all products that have the same description you would use a(n)find unmatched query.

Question 28

A lookup manager lets the user select a value from a list of possible values.

Question 29

An input guide is a predefined format used to enter and display data in a field.

Question 30

Access uses unique icons to represent different types of queries.

Question 31

Displaying just the first 10 records of query results is an example of the use of the First Records property for a query.

Question 32

Which of the following statements is true?

A)Using a numeric range test with a Text field is not allowed.
B)Enclosing numbers in quotation marks for a Test field range test will eliminate an error message.
C)Enclosing numbers in quotation marks for a Test field range test will yield unpredictable results.
D)All of the above

Question 33

The Validation Rule property value will be displayed in a dialog box if the user enters an invalid value.

Question 34

A ____ field lets the user select a value from a list of possible values.

A)roster
B)datasheet
C)lookup
D)manager

Question 35

The ampersand wildcard character represents any single character.

Question 36

If you want to display all customers who have not placed orders you would use a(n)find unmatched query.

Question 37

The Validation Text property value specifies the valid values that users can enter in a field.

Question 38

If you want to display all non-degree students who are not currently enrolled in classes you would use a(n)find duplicates query.

Question 39

____ display characters automatically appear in specific positions of a field value without users having to type them.

A)Absolute
B)Relative
C)Figurative
D)Literal

Question 40

To include literal display characters you need to create a(n)____ mask.

A)display
B)field
C)viewing
D)input

Question 41

The ____ property value will be displayed in a dialog box if the user enters an invalid value.

A)Data-Entry
B)Validation Text
C)Validation Rule
D)Datasheet

Question 42

The input mask character ____ determines whether to store in the database the literal display characters such as the hyphen and parentheses.

A)--
B)++
C)::
D);;

Question 43

The input mask character ____ indicates that only a digit can be entered.

A)0
B)9
C)!
D)#

Question 44

The ____ represents any single character.

A)*
B)?
C)#
D)@

Question 45

The input mask character ____ causes the input mask to display from right to left.

A)!
B)9
C)0
D);

Question 46

The input mask character ____ indicates that a digit or space can be entered.

A)!
B)@
C)0
D)9

Question 47

The ____ represents any string of characters

A)&
B)@
C)*
D)?

Question 48

The ____ comparison operator selects records by matching field values to a specific pattern that includes one or more of these wildcard characters: # * and ?.

A)And
B)As
C)Or
D)Like

Question 49

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should be stored in the database.

A)0
B)1
C)2
D)5

Question 50

Using a pattern match is similar to using an exact match except that a pattern match includes ____ characters.

A)random
B)literal
C)absolute
D)wildcard

Question 51

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should not be stored in the database.

A)0
B)1
C)2
D)5

Question 52

You must use the Input Mask Wizard in ____ view.

A)Datasheet
B)Design
C)Form
D)Database

Question 53

You perform a pattern match using the ____ comparison operator.

A)And
B)Or
C)Like
D)Not

Question 54

A ____ match selects records with a value for the selected field that matches the pattern of the simple condition value.

A)design
B)pattern
C)value
D)select

Question 55

The ____ property value specifies the valid values that users can enter in a field.

A)Data-Entry
B)Validation Text
C)Validation Rule
D)Datasheet

Question 56

When you click the Input Mask text box in the Field Properties pane a ____ button appears to the right of the Input Mask text box.

A)Display
B)Create
C)Build
D)Show

Question 57

Which of the following is a literal display character?

A)^
B)~
C)(
D)All of the above

Question 58

The input mask character ____ is a placeholder character.

A)+
B)_
C)*
D)&

Question 59

A(n)____ mask is a predefined format used to enter and display data in a field.

A)entry
B)display
C)input
D)field

Question 60

The ____ represents any single digit.

A)#
B)*
C)@
D)?

Question 61

Press and hold down the ____ key to select multiple columns.

A)Ctrl
B)Esc
C)F1
D)Shift

Question 62

The ____ property for a query lets you limit the number of records in the query results.

A)Limit
B)Show Records
C)Top Values
D)Restrict

Question 63

A(n)____ match selects records whose value for the selected field matches one of two or more simple condition values.

A)list-of-values
B)exact
C)position
D)pattern

Question 64

As shown in the above figure a ____ query prompts you for information when the query runs.

A)parameter
B)list-of-values
C)pattern
D)logical

Question 65

Of the aggregate functions shown in the figure above the ____ function returns the standard deviation of the field values in a selection of records.

A)StDev
B)Var
C)Sum
D)Count

Question 66

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.

A)As
B)Like
C)In
D)Or

Question 67

The ____ comparison operator lets you define a condition with two or more values.

A)Like
B)In
C)As
D)Or

Question 68

You can change a select query to a crosstab query in Design view using the Crosstab button in the Query Type group on the ____ tab.

A)Crosstab
B)Query Tools Design
C)Selection
D)Wizard

Question 69

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

A)Keep Visible
B)No Scroll
C)Display Columns
D)Freeze

Question 70

What you could accomplish with several Or conditions in the design grid you can do more easily with the ____ comparison operator.

A)Like
B)In
C)As
D)Or

Question 71

The ____ logical operator negates a criterion.

A)Nor
B)Or
C)Not
D)Nand

Question 72

Aggregate functions like those shown in the above figure perform ____ operations on selected records in a database.

A)composite
B)comparative
C)join
D)arithmetic

Question 73

The aggregate function ____ returns the total of the field values in a selection of records.

A)Sum
B)Tot
C)Total
D)Aggr

Question 74

Of the aggregate functions shown in the figure above the ____ function returns the lowest of the field values in a selection of records.

A)Avg
B)First
C)Min
D)Last

Question 75

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.

A)Count
B)Avg
C)Var
D)StDev

Question 76

The Freeze command is available in the ____ group on the Home tab under the More button.

A)File
B)View
C)Records
D)Table

Question 77

Of the aggregate functions shown in the above figure the ____ function returns the highest of the field values in a selection of records.

A)Max
B)StDev
C)Min
D)Avg

Question 78

In the Input Mask Wizard the practice area is called the ____ text box.

A)Sample
B)Try It
C)Practice
D)Experiment

Question 79

A(n)____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.

A)aggregate
B)function
C)crosstab
D)Both A and B

Question 80

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.

A)unrelated
B)unmatched
C)free
D)empty