Deck 8: Integrating Applications

Question 1

The word "Between" is a comparison operator that you can use in your criterion expressions.

Answer 1

True

Question 2

A table finds data in your database by allowing you to ask a question.

Answer 2

False

Question 3

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Answer 3

False

Question 4

When building a query,you are limited to adding one table to the Query Design window.

Question 5

In the simplest criterion expression,when you only enter the criteria value,Access evaluates this criterion as an "equal to" comparison.

Question 6

When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.

Question 7

You can create a query in Design view or with the Query Wizard.

Question 8

To test a query,run it and then compare the results to your expected results.

Question 9

Making changes to the data shown in Datasheet view of a query changes the actual table data.

Question 10

When you build a query you must tell Access where to find the data.

Question 11

Use the ? wildcard character to match any number of characters.

Question 12

At times no records will display when you run a query.

Question 13

To see the results of a query,you must run it.

Question 14

When creating a query,you are limited to how many fields you can put into the Design grid.

Question 15

Queries you create using the Query Design button automatically open in Design view.

Question 16

It is possible to display the results of a query in sorted order.

Question 17

To create a new query,use the Create tab.

Question 18

The Simple Query Wizard lets you take advantage of all the options available to you when creating a query.

Question 19

Functions are pre-built procedures that perform a specific task.

Question 20

When you use a wildcard,the criterion of your expression must be enclosed in parentheses.

Question 21

Access refers to formulas as criterion.

Question 22

Which of the following indicates which fields have been included in the query?

A)select query
B)summary query
C)Expression Builder
D)Design grid

Question 23

The AND logical operator requires a record to meet at least one of the individual conditions specified in order to be included in the results.

Question 24

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Question 25

Which of the following is true about the Simple Query Wizard?

A)It doesn't allow you to take advantage of all of the options available when creating a query.
B)It lets you take full advantage of all the options available when creating a query.
C)It provides great flexibility when creating queries.
D)Most people create queries using the Simple Query Wizard.

Question 26

Which of the following is used to locate data in a database?

A)select query
B)summary query
C)Expression Builder
D)Design grid

Question 27

The Like comparison operator can help you find records containing data that is similar to,or like,the criterion value.

Question 28

How many fields does Access allow you to add to the Design grid?

A)5 or fewer
B)10 or fewer
C)15 or fewer
D)as many as you like

Question 29

A summary query uses a Total row that is added into the Design grid of the query.

Question 30

How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch who were hired after January 1,2014?

A)1
B)3
C)6
D)9

Question 31

After you create a query,what must you do in order to see the results?

A)select the table to include in the query
B)select the fields to include in the query
C)enter criterion into the query
D)run the query

Question 32

The Count function finds the total value of a field.

Question 33

You can create a query that combines both the AND and OR operators.

Question 34

Which of the following tabs do you use to create a query?

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

Question 35

A calculated field is a field that gets its value from a calculation instead of a value that is entered into the field.

Question 36

Which of the following finds data in your database by allowing you to ask a question?

A)calculated field
B)compound criteria
C)query
D)parameter

Question 37

A parameter query asks you to enter the specific criteria value when you run the query.

Question 38

In what view do query results display?

A)Design view
B)Datasheet view
C)Form view
D)Report view

Question 39

Which of the following is the most common type of query?

A)select query
B)summary query
C)simple query
D)parameter query

Question 40

Compound criteria combine more than one criterion using the AND or OR logical operators and allow you to ask questions using multiple conditions.

Question 41

Which of the following is a valid criterion for the Long Text data type?

A)hello
B)"hello"
C)*hello*
D)#hello#

Question 42

What should you use to write criterion?

A)criterion
B)Like comparison
C)wildcard symbols
D)expression

Question 43

Which of the following should you add to a query to search for records that meet a specific value?

A)criterion
B)Like comparison
C)wildcard symbols
D)expression

Question 44

Which of the following is a valid criterion for the Short Text data type?

A)hello
B)"hello"
C)*hello*
D)#hello#

Question 45

What does the type of criterion you enter,along with the way you enter the criterion,depend on?

A)table size
B)data type of the field
C)parameter text
D)calculated field

Question 46

How does Access evaluate a criterion expression that just includes a criteria value?

A)equal to
B)not equal to
C)equal to or greater than
D)equal to or less than

Question 47

Which of the following keyboard shortcuts opens the Expression Builder dialog box?

A)F2
B)Ctrl+F2
C)Alt+F2
D)Shift+F2

Question 48

Which of the following keyboard shortcuts opens the Save As dialog box?

A)F6
B)F8
C)F10
D)F12

Question 49

Which of the following is a valid criterion for the AutoNumber data type?

A)5
B)$5
C)5t
D)5n

Question 50

When entering a criterion expression,which of the following tools helps suggest a list of possible values?

A)Query Design Wizard
B)parameter query
C)aggregate function
D)IntelliSense

Question 51

Which of the following groups of commands lets you insert and delete fields in the Design grid?

A)Query Wizard
B)Query Design
C)Query Setup
D)Expression Builder

Question 52

In the Design grid,what must you delete in order to delete a field?

A)a column
B)a row
C)a table
D)none of the above

Question 53

Which of the following is a valid criterion for the Number data type?

A)5
B)$5
C)5t
D)5n

Question 54

Which of the following is a valid criterion for the Currency data type?

A)5
B)$5
C)5t
D)5n

Question 55

Which symbol must be used to specify criterion for the Date/ Time data type?

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

Question 56

Which of the following comparison operators means "Contained in this list of values"?

A)< >
B)Between
C)In
D)Like

Question 57

Which of the following can you change in Datasheet view of a query?

A)font type
B)font size
C)column width
D)all of the above

Question 58

What name does Access assign to new queries?

A)Query
B)Query1
C)QueryData1
D)QueryResults1

Question 59

Which of the following comparison operators means "Between these two values"?

A)< >
B)Between
C)In
D)Like

Question 60

Which of the following comparison operators means "Similar to this value"?

A)< >
B)Between
C)In
D)Like

Question 61

Which of the following logical operators requires that a record meet all of the individual conditions specified in order to be included in the results?

A)AND
B)OR
C)NOT
D)NULL

Question 62

Which of the following gets its value from a calculation instead of a value that is entered into a field?

A)function
B)aggregate function
C)formula expression
D)calculated field

Question 63

Which of the following properties directs Access to only display records that don't include duplicated values?

A)Unique Records
B)Unique Values
C)Null Records
D)Null Values

Question 64

When structuring a criteria expression with a parameter that includes one or more wildcards,where can the wildcards be positioned?

A)at the end
B)at the beginning
C)at the beginning and end
D)any of the above

Question 65

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

A)AND
B)OR
C)NOT
D)NULL

Question 66

Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?

A)Contains "love"
B)Like *"love"*
C)Like "* love"
D)Like "* love *"

Question 67

What is true of values entered on the same Criteria row of the Design grid?

A)create an AND condition
B)create an OR condition
C)create a NULL condition
D)create a NOT NULL condition

Question 68

Which of the following keys opens or closes the Property Sheet?

A)F2
B)F4
C)F5
D)F12

Question 69

Which of the following wildcard characters matches any number of characters?

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

Question 70

Which of the following wildcard characters matches any single character in a specific position?

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

Question 71

Which of the following criterion expressions searches for a ShippingDate field that greater than January 1,2014?

A) >1/ 1/ 2014
B) >"1/ 1/ 2014"
C) >#1/ 1/ 2014#
D) >=#1/ 1/ 2014#

Question 72

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?

A)In(10,20)
B) >10< 20
C)Between #10 and 20#
D)Between 10 and 20

Question 73

Which of the following wildcard characters matches any single character numeric digit?

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

Question 74

Which of the following parameters is the most user-friendly?

A)[Enter the Music Genre]
B)[ ]
C)[Genre?]
D){Genre?}

Question 75

Which of the following requires you to enter the specific criteria value when you run the query?

A)simple query
B)summary query
C)parameter query
D)Expression Builder

Question 76

Which of the following criterion will search for songs with the title of "Love for All Seasons","Love This Pain",and "Love Will Find a Way"?

A)In(love)
B)Like "love"
C)"Like Love"
D)="love"

Question 77

Which of the following criterion expressions searches for a State field that is equal to Ca?

A)=Ca
B)="Ca"
C)=(Ca)
D)=#Ca#

Question 78

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?

A)Like "9?????????"
B)Like "9*"
C)Contains "9?????????"
D)Contains #9*#

Question 79

Which of the following will you likely use when entering a parameter query that contains wildcards?

A)Zoom box
B)Expression Builder
C)Zoom box or Expression Builder
D)compound criteria

Question 80

Which of the following symbols must you use when defining a parameter query?

A)( )
B)[ ]
C){ }
D)/ /