Access Tutorial 5

Your page rank:

Total word count: 2115
Pages: 8

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu.

False

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

crosstab

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?
a. 999\-000\-0000
b. 999-000-9999
c. 999\000\0000
d. 000\-999\-9999

999\-000\-0000

When using the IIf function, a condition is tested, and if the condition is false, the first value of the condition is returned by the function.

False

In an input mask, the letter ____ indicates that a letter or digit must be entered, and the entry is required.

A

Crosstab queries may use which of the following aggregate functions?

Var

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

predefined input mask

Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2

To ensure that all telephone numbers are entered in a consistent manner, Janise assigned a(n) ____ to the PrimaryPhone field as illustrated in Figure Case 5-1-2.

input mask

The calculated expression =City & "," & State & " " & ZipCode is an example of ____.

concatenation

Which of the following is an example of a parameter query prompt criterion?

[Type the state:]

A criterion may be negated by using the ____ logical operator.

Not

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional.

False

Marie works for a busy pediatrician’s office. The practice has a sophisticated database for all records and information that pertain to the practice. The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient’s name, date of birth, and the names of parents or guardians. The doctor would like to see the patient’s full name in the format Lastname, Firstname even though they are separate fields in the database. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields. Based on the doctor’s requirements for the report, Marie must create a query on which to base the report.

Because the doctor wants all data entered for parents and guardians regardless of the data in the field, Marie must create a calculated field in the query with a function that tests the Mother, Father, and Guardian fields for a condition that is either true or false. If the condition is true, one result will be displayed, and if the condition is false a different result will be displayed. Which function should Marie use for this calculated field?

IIf

The aggregate function which returns the number of nonnull field values is the ____ function.

Count

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of concatenation.

True

Tables used in a find unmatched query must have a common field.

True

Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2

The State field in Figure Case 5-1-1 illustrates which of the following?

a lookup field

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

IIf

The Registrar at Ravenswood College would like to create a query which displays all students who have not yet registered for fall semester classes. She will use the StudentInformation and TuitionPaid tables to create the query. Which type of query will most likely create the desired results?

find unmatched query

The Like comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*, ?, #) in a query.

True

Carlos has developed a database for his organic farm. The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants.

Carlos would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run. Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs?

parameter query

Access designates all queries in the Navigation Pane with the same icon regardless of the query type.

False

Carlos has developed a database for his organic farm. The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants.

As Carlos plans for the fall planting season, he would like to bundle all of his shipments from the Organic Opportunities supplier into one shipment. He needs to know which products he has previously ordered from Organic Opportunities. Which method will quickly produce the results Carlos needs?

use the AutoFilter option in the Supplier table for the appropriate field

The input mask character ____ indicates that a letter only must be entered, and the entry is required.

L

The format field command freezes a field (column) in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.

False

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

-1

A value of true will be returned if a field is empty when the IsNull function is used.

True

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

DonationsGreaterThan2500: [Donation]>=2500

Yes/No field values are stored in an Access database as a -1 for a checked value and a 0 for an unchecked value.

True

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

Like

An input mask property cannot be changed after the Input Mask Wizard closes.

False

Carlos has developed a database for his organic farm. The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants.

Carlos needs to decide which cooking demonstrations to offer next month. He would like to offer his five most popular demonstrations. Which method would be best for Carlos to use to find this information from his database?

create a top values query based on the field in the CookingDemo table that lists the number of participants

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

In

Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2

The 9999 included in the Input Mask property in Figure Case 5-1-2 indicates that data entry is ____ for that part of the field.

optional

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

make a backup copy of

Rich text formatting available for Long Text fields includes ____.

font options

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

Append Only

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

find duplicates query

A query that selects records in fields that satisfy the criteria is a Select query.

True

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

Like "704*"

A summarized record for each unique field value is displayed in a crosstab query.

True

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

False

A nonnull field is a field that contains any data at all, including a single space.

True

When creating an input mask, the ____ input mask character is used to indicate that the following character will be a literal display of that character.

\

The Access database object named tblProductCatalog is mostly likely an Access form object.

False

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of concatenation.

True

To avoid the display of a security warning when opening a database, place the database ____.

in a trusted folder

The standard naming convention prefix tag for a query used to identify the object type is ____.

qry

Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

Figure Case 5-1-1

Figure Case 5-1-2

The State field in Figure Case 5-1-1 illustrates which of the following?

a lookup field

Marie works for a busy pediatrician’s office. The practice has a sophisticated database for all records and information that pertain to the practice. The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient’s name, date of birth, and the names of parents or guardians. The doctor would like to see the patient’s full name in the format Lastname, Firstname even though they are separate fields in the database. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields. Based on the doctor’s requirements for the report, Marie must create a query on which to base the report.

Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] & ", " [FirstName]. This expression is an example of ____.

concatenation

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending