Question 1

The DateAdd function is used ________.

Accepted Answer

A) to determine the difference between two dates 
B) to add a specific time from the system time 
C) to add a specific day from a date 
D) to add or subtract a specific time interval from a date 
A) to determine the difference between two dates 
B) to add a specific time from the system time 
C) to add a specific day from a date 
D) to add or subtract a specific time interval from a date

Question 2

The most important functionality of a database is to create useful information.

Accepted Answer

A) True 
 B)False

Question 3

The DatePart function contains ________ arguments.

Accepted Answer

A) 3 
B) 4 
C) 5 
D) 6 
A) 3 
B) 4 
C) 5 
D) 6

Question 4

You can use the IIf function anywhere you can use expressions.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ symbol is used in conjunction with the Concatenate function when you want to create a single field by combining data in multiple fields.

Accepted Answer

A) # 
B) $ 
C) & 
D) % 
A) # 
B) $ 
C) & 
D) %

Question 6

To test for one of two conditions,you would use a nested IIf function.

Accepted Answer

A) True 
 B)False

Question 7

If you want to compare the number of golfers you had this summer as compared to last summer and each tee time contains a Scheduled Date,you can use the ________ function to extract the year from the Scheduled Date in order to group your records in the query.

Accepted Answer

A) DateSort 
B) DatePart 
C) DateSerial 
D) DateAdd 
A) DateSort 
B) DatePart 
C) DateSerial 
D) DateAdd

Question 8

Many times wildcard characters are combined with the Like operator to ensure that your query is returning all the data you need.

Accepted Answer

A) True 
 B)False

Question 9

________ functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

Accepted Answer

The answer of ________ functions can be used to determine...

Question 10

You can use the Like function to find values in a field that match a specified pattern.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT true when using Date Interval settings?

Accepted Answer

A) If you enter the wrong interval,you can create many problems within your data. 
B) DateDiff for the "yyyy" in Access calculates the year without regard to the day. 
C) If you can calculate the same result entering a function that is half the length,you increase the possibility of creating errors while typing in your function. 
D) Date()+10 would result in the same output as using the DateAdd function to add 10 to the current date. 
A) If you enter the wrong interval,you can create many problems within your data. 
B) DateDiff for the "yyyy" in Access calculates the year without regard to the day. 
C) If you can calculate the same result entering a function that is half the length,you increase the possibility of creating errors while typing in your function. 
D) Date()+10 would result in the same output as using the DateAdd function to add 10 to the current date.

Question 12

The ________ function returns a number rounded to a specific number of decimal places.

Accepted Answer

The answer of The ________ function returns a number rounded...

Question 13

Once you have quality information and make a decision based on that information,you now have ________ about your organization.

Accepted Answer

The answer of Once you have quality information and make...

Question 14

Which of the following is NOT a wildcard character that can be combined with the Like function?

Accepted Answer

A) [charlist] or [!charlist] 
B) # 
C) & 
D) * or % 
A) [charlist] or [!charlist] 
B) # 
C) & 
D) * or %

Question 15

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

Accepted Answer

The answer of The most important functionality of a database...

Question 16

Match between columns
                        Premises: ? or _
* or %
#
[charlist]
[!charlist]

Accepted Answer

The Answer of Any single character and Any single character is...

Question 17

Which of the following arguments of the DateAdd function is NOT correct?

Accepted Answer

A) Time contains a time in 24-hour format that represents the interval of time you want to add or subtract. 
B) Interval contains a string expression that represents the interval of time you want to add or subtract. 
C) Number refers to the numeric expression that indicates the number of intervals you want to add.It can be positive (to calculate dates in the future)or negative (to calculate dates in the past). 
D) Date is the date to which the interval is added. 
A) Time contains a time in 24-hour format that represents the interval of time you want to add or subtract. 
B) Interval contains a string expression that represents the interval of time you want to add or subtract. 
C) Number refers to the numeric expression that indicates the number of intervals you want to add.It can be positive (to calculate dates in the future)or negative (to calculate dates in the past). 
D) Date is the date to which the interval is added.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

If you wanted to return the values of carpenter,cart manager,cart maintenance engineer,cosmetics specialist,courtesy representative,concierge,or any other title that starts with the letter c you would type ________ in the criteria of a JobTitle field.

Accepted Answer

A) c? 
B) c* 
C) [!C] 
D) c# 
A) c? 
B) c* 
C) [!C] 
D) c#

Question 20

You need to know the date serial number to use a date field in a calculated field.

Accepted Answer

A) True 
 B)False

The DateAdd function is used ________.

The most important functionality of a database is to create useful information.

The DatePart function contains ________ arguments.

You can use the IIf function anywhere you can use expressions.

A(n)________ symbol is used in conjunction with the Concatenate function when you want to create a single field by combining data in multiple fields.

To test for one of two conditions,you would use a nested IIf function.

If you want to compare the number of golfers you had this summer as compared to last summer and each tee time contains a Scheduled Date,you can use the ________ function to extract the year from the Scheduled Date in order to group your records in the query.

Many times wildcard characters are combined with the Like operator to ensure that your query is returning all the data you need.

________ functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

You can use the Like function to find values in a field that match a specified pattern.

Which of the following is NOT true when using Date Interval settings?

The ________ function returns a number rounded to a specific number of decimal places.

Once you have quality information and make a decision based on that information,you now have ________ about your organization.

Which of the following is NOT a wildcard character that can be combined with the Like function?

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

Which of the following arguments of the DateAdd function is NOT correct?

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

If you wanted to return the values of carpenter,cart manager,cart maintenance engineer,cosmetics specialist,courtesy representative,concierge,or any other title that starts with the letter c you would type ________ in the criteria of a JobTitle field.

You need to know the date serial number to use a date field in a calculated field.

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

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

The DateAdd function is used ________.

The most important functionality of a database is to create useful information.

The DatePart function contains ________ arguments.

You can use the IIf function anywhere you can use expressions.

A(n)________ symbol is used in conjunction with the Concatenate function when you want to create a single field by combining data in multiple fields.

To test for one of two conditions,you would use a nested IIf function.

If you want to compare the number of golfers you had this summer as compared to last summer and each tee time contains a Scheduled Date,you can use the ________ function to extract the year from the Scheduled Date in order to group your records in the query.

Many times wildcard characters are combined with the Like operator to ensure that your query is returning all the data you need.

________ functions can be used to determine if a specific condition is true or false and introduces decision making into a database.

You can use the Like function to find values in a field that match a specified pattern.

Which of the following is NOT true when using Date Interval settings?

The ________ function returns a number rounded to a specific number of decimal places.

Once you have quality information and make a decision based on that information,you now have ________ about your organization.

Which of the following is NOT a wildcard character that can be combined with the Like function?

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

Which of the following arguments of the DateAdd function is NOT correct?

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

If you wanted to return the values of carpenter,cart manager,cart maintenance engineer,cosmetics specialist,courtesy representative,concierge,or any other title that starts with the letter c you would type ________ in the criteria of a JobTitle field.

You need to know the date serial number to use a date field in a calculated field.

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