Question 1

A null value is synonymous with a zero value.

Accepted Answer

A null value represents the absence of a value, while a zero value represents a specific numerical value. They are not synonymous.

Question 2

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

Accepted Answer

The answer of When using wildcard characters in a query,________...

Question 3

Access uses the 1900 date system to store dates.Thus,when you enter a date into a Date/Time field,Access identifies it as a date and compares it to the calendar to make sure it is an actual date.

Accepted Answer

Access does use the 1900 date system to store dates and verifies that entered dates are valid.

Question 4

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

Accepted Answer

The precision argument is used in various programming languages and functions, such as the round() function in Python, to specify the number of decimal places to which a number should be rounded. This allows for greater control over the accuracy of calculations and the format of the output.

Question 5

________ operators include And,Or,and Not.

Accepted Answer

The answer of ________ operators include And,Or,and Not....

Question 6

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

Accepted Answer

Date fields can be used in calculated fields without needing to know the date serial number, as most systems handle date conversions automatically.

Question 7

________,such as an asterisk (*)or question mark (?),substitute for other characters when used in a query.

Accepted Answer

The answer of ________,such as an asterisk (*)or question mark...

Question 8

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 9

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

Accepted Answer

The answer of A(n)________ query can be designed to prompt...

Question 10

The Round function returns a number rounded to a specific number of decimal places.This does the same thing as formatting a field to a specific number of decimals.

Accepted Answer

The Round function changes the actual value by rounding it, while formatting only changes how the number is displayed without altering the underlying value.

Question 11

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.

Accepted Answer

The answer of A(n)________ allows you to enter the prompt...

Question 12

In Access,the term ________ is synonymous with "formula."

Accepted Answer

The answer of In Access,the term ________ is synonymous with...

Question 13

You can use the ________ function to find values in a field that match a specific pattern.

Accepted Answer

The answer of You can use the ________ function to...

Question 14

To answer the question,"Which is the most or least expensive product sold at company A," you would use a(n)________ query.

Accepted Answer

The answer of To answer the question,"Which is the most...

Question 15

When using wildcard characters in a query,a(n)________ in the criteria of a field will allow you to use a group of one or more characters enclosed in brackets.

Accepted Answer

The answer of When using wildcard characters in a query,a(n)________...

Question 16

To display specific dates,you can use the DateSerial function,written as DateSerial(year,month,day)to manipulate the day,month,and year of a date.

Accepted Answer

DateSerial(year,month,day) can be used to display specific dates by using the year, month, and day parameters to manipulate the date.

Question 17

The Date and Now functions retrieve a date and/or time according to your computer's system date and time.

Accepted Answer

The Date and Now functions rely on the system date and time of your computer to retrieve the current date and/or time.

Question 18

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

Accepted Answer

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

Question 19

________ include the names of a field,a control on a form or report,or the properties of the fields or controls.

Accepted Answer

The answer of ________ include the names of a field,a...

Question 20

________ are values that do not change,such as strings of text or numbers that are not calculated by an expression.

Accepted Answer

The answer of ________ are values that do not change,such...

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