Exam 6: Workshop 6: Pattern Matching and Functions in Queries

When using wildcard characters in a query,a charlist in the criteria of a field will allow you to use a group of one or more characters enclosed in parentheses.

(True/False)

4.9/5

(32)

Question 21

The most important functionality of a database is to create ________.

(Multiple Choice)

4.8/5

(27)

Question 22

A dependent expression is an expression that relies on the outcome of another expression.

(True/False)

4.8/5

(38)

Question 23

Match the following Date functions to their definition:

Date function

Determine the difference between two dates

Now function

Returns the current system date

DateDiff function

Used to manipulate the day,month,and year

Correct Answer:

Verified

Date function

Now function

DateDiff function

DateAdd function

DateSerial function

(Matching)

4.9/5

(34)

Question 24

Which of the following is not true regarding expressions?

(Multiple Choice)

4.7/5

(34)

Question 25

Which of the following parameter data types is NOT one that is particularly important to specify when using parameters?

(Multiple Choice)

4.9/5

(37)

Question 26

When using wildcard characters in a query,________ in the criteria of an AreaCode field would return 500,501,502...509.

(Short Answer)

4.7/5

(32)

Question 27

Which of the following is NOT true regarding the Round function?

(Multiple Choice)

4.8/5

(29)

Question 28

________ is used to indicate that a value is unknown,and it is treated differently than other values because it has no value.

(Short Answer)

4.9/5

(41)

Question 29

A(n)________ query can be designed to prompt users for criteria without having to make changes in Design view.

(Short Answer)

4.8/5

(32)

Question 30

Logical operators are also known as ________ operators.

(Short Answer)

4.8/5

(42)

Question 31

Calculated fields can be used in other expressions within your query by enclosing the calculated field name in ________.

(Multiple Choice)

4.9/5

(39)

Question 32

You can use a Top Values query when you need to find records that contain the top or bottom values in a field.

(True/False)

4.7/5

(39)

Question 33

The ________ argument allows you to determine how many decimal places you want to round your numbers.

(Short Answer)

5.0/5

(33)

Question 34

Which of the following is NOT a DateAdd function argument?

(Multiple Choice)

4.7/5

(33)

Question 35

Specifying parameter data types is particularly important when you have text,numeric,currency,or date/time data.

(True/False)

4.9/5

(37)

Question 36

A null value is synonymous with a zero value.

(True/False)

4.8/5

(34)

Question 37

The ________ function is used to determine the difference between two dates.

(Short Answer)

4.8/5

(33)

Question 38

A(n)________ allows you to enter the prompt you want the user to see when the query is run,and enclose the prompt within square brackets.

(Short Answer)

4.9/5

(38)

Question 39

The ________ function is very flexible because you can manipulate each part individually or together in any combination that meets your needs.

(Short Answer)

4.8/5

(39)

Question 40

When using wildcard characters in a query,a charlist in the criteria of a field will allow you to use a group of one or more characters enclosed in parentheses.

The most important functionality of a database is to create ________.

A dependent expression is an expression that relies on the outcome of another expression.

Which of the following is not true regarding expressions?

Which of the following parameter data types is NOT one that is particularly important to specify when using parameters?

When using wildcard characters in a query,________ in the criteria of an AreaCode field would return 500,501,502...509.

Which of the following is NOT true regarding the Round function?

________ is used to indicate that a value is unknown,and it is treated differently than other values because it has no value.

A(n)________ query can be designed to prompt users for criteria without having to make changes in Design view.

Logical operators are also known as ________ operators.

Calculated fields can be used in other expressions within your query by enclosing the calculated field name in ________.

You can use a Top Values query when you need to find records that contain the top or bottom values in a field.

The ________ argument allows you to determine how many decimal places you want to round your numbers.

Which of the following is NOT a DateAdd function argument?

Specifying parameter data types is particularly important when you have text,numeric,currency,or date/time data.

A null value is synonymous with a zero value.

The ________ function is used to determine the difference between two dates.

A(n)________ allows you to enter the prompt you want the user to see when the query is run,and enclose the prompt within square brackets.

The ________ function is very flexible because you can manipulate each part individually or together in any combination that meets your needs.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters