COM S 113 - Final Exam (Access Ch. 5)

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Reports cannot be based on parameter queries.

False

Hour

"h"

Month

"m"

Minute

"n"

Day of the Week

"w"

Year

"yyyy"

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

0

=DatePart("m", #01/16/1959#)

1

How many arguments does the IIf function have?

3

Date function

A function that calculates and displays the current date.

IsNull function

A function that checks whether a field has no value when you need to see if a field was skipped in data entry

IIf function

A function that evaluates an expression and displays one value when the expression is true and another value when the expression is false.

DatePart function

A function that examines a date and displays a portion of the date.

Round function

A function that returns a number rounded to a specific number of decimal places.

Parameter query

A query where the user provides the criterion at run time.

Data Validation

A set of constraints or rules that help control data and accuracy of data entered into a field.

Input mask

A setting that restricts the data being input into a field by specifying the exact format of the date entry and guarantees consistent formatting of data in a field.

Lookup Wizard

A tool that helps you create a menu of predefined values by asking you questions and using your answers to create the options list.

Lookup field

A way to provide the user with a predefined list of values to choose from in a menu.

Default Value

A way to specify what value that is automatically entered into a field when a new record is added to a table.

What sort of validation rule would you add to a Salary field with a Number data type?

At the very least, a validation rule of >=0 would make sense since people cannot make a negative salary. If there is a maximum salary for the company (say, $150,000), you may want to consider Between 0 and 150000 to ensure it falls in the correct range.

What data type allows you to change the Required field property?

AutoNumber

How does the precision argument change the way the Round function behaves?

By changing the precision of the Round function, you will change how the function rounds a number. For example, if the precision is left blank or set to zero, it will round to the nearest whole number. However, rounding the same number and changing the precision to 1 will round to the nearest tenth rather than to the nearest whole number.

How would you direct the DatePart function to display only the year of a field named BirthDate?

DatePart("yyyy", BirthDate)

A null value means that the value is zero for any type of a field

False

A parameter query is not a type of select query.

False

If you used a lookup field for a field named State, the book recommends that you have fifty menu options available to anyone doing data entry.

False

To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

False

To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.

False

In a parameter query, if you do not specify a comparison operator, Access will assume equal to.

True

The string of characters !\(999")"000\-0000;0;_ represents which of the following?

Input mask

What function evaluates whether a value has been entered into a field?

IsNull

Do you feel a LastName field would be a good candidate for a lookup field? Why or why not?

LastName would generally be a poor field to convert to a lookup field, given the large number of possible last names. If you had a customer with a new last name, they would first need to be added to the data source for the lookup before they could be added to a table.

A field with a limited number of values is well suited for what type of field?

Lookup field

What enables users to choose from a list of options while entering data?

Lookup field

You want to use the IIf function to display Yes for all applicants with a value of 700 or more in their CreditScore field, and No for all other applicants. What would be the value of the expression, truepart, and falsepart for this function?

The expression is CreditScore >= 700. The truepart is "Yes". The falsepart is "No".

In the Round function, the precision cannot be a negative number.

True

How does the person performing data entry benefit if you add an input mask to a field?

The input mask will make the format of the data a little more obvious. It can help avoid confusion and will lead to more consistent and faster data entry.

Access allows for the creation of custom input masks.

True

An input mask is used to consistently format data.

True

Between [Enter Start Date] AND [Enter End Date] is a valid statement to use in a parameter query.

True

How will the parameter query request display when the query is run?

Pop-up message

Give an example of a query you might want to convert to a parameter query.

Specifics will vary here, but any query that has a criteria that is being adjusted would be a good choice to be converted to a parameter query. For example, in class we have seen an example of a query where we want to see the results based on specific type of animals.

Storing the options used in a lookup field in a separate table makes adding options easier.

True

Tables are a good source for data in a lookup field.

True

The DatePart function always returns a number.

True

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

True

Input Mask Wizard

Used to generate data restrictions for a field and help create consistent formatting of data in a field

Under what condition would you set a default values for a field?

You would set a default value if a field value appears commonly for a field. For example, if most of your customers are in the state of Florida, you could set a default value of FL for a State field.

You can restrict the data type that will be accepted in a parameter query by ...........................

choosing a data type for each parameter


Kaugnay na mga set ng pag-aaral

Exam 4: Foodborne Illness (Week 11-13)

View Set

3.4 Functionalism & The Whole is Greater than the Sum of Its Parts

View Set

Chapter 15: Hyperlipidemia and Hypertension ATI

View Set

Call of the Wild, Chapter 4 Study Guide

View Set

Ch. 2 Biological and Environmental Foundations

View Set

Digestive System (through esophagus)

View Set

Chapter 11: Nursing Management: Patients With Chronic Obstructive Pulmonary Disease and Asthma

View Set