CS 235 Exam 4

In order to specify a numeric digit, a database designer can enter an input mask containing the ________ character.

#

In order to specify a character, a database designer can enter an input mask containing the ________ character.

?

Which of the following is not a situation when you would use a make table query?

A table with the structure defined but no data needs to be populated with information from other tables.

Which of the following is a situation when you would use a delete query?

All customers who have been inactive for two years should be deleted.

Which of the following is an example of an aggregate function?

Average

You are working on an Access form and want to apply programming logic to a field in the form. This can be done in ________.

Design View

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

Print Preview

Which of the following statements would be a good reason to create a lookup field in a table?

The field has only two possible choices.

Which of the following statements would NOT be appropriate validation text?

Value for this field is of the wrong data type.

A(n) ________ query adds, updates, and deletes information inside a database.

action

One example of an action query is a(n) ________ query.

make table

In order to find null values in the database, a database designer can create a ________.

missing data report

A(n) ________ query can prompt a user for a criterion when the query is run.

parameter

If the text in the criteria row of a query appears in this form: [Enter First Name] it indicates that this is a(n) ________ query.

parameter

If a user needs to show a series in a PivotChart and would like to see how much each of them contributes to the whole, they would select a(n) ________ chart.

pie

If a make table query is run and the destination table already exists, Access will ________.

prompt the user whether to delete the existing table

PivotTables can be based on

queries and tables

PivotTables can be based on ________.

queries and tables

In order to get an input mask to accept entry from left to right, a database designer must ________.

start the input mask with an !

After a calculated field has been created in a PivotTable, it can not be

stored

Which of the following would be a situation when you would use a parameter query?

A query needs to be created so it prompts users for criterion for the query.

Which of the following would not be a situation when you would use a parameter query?

A query needs to be created to update the price of products in a certain class.

Which of the following is a situation when you would use a make table query?

All fax machines are being discontinued, so all records n the Product table that are fax machines should be copied to a new table in anticipation of removing them from the main table.

Which of the following is an example of when you would use an append query?

An applicants table needs to have all applicants who have failed a drug test moved in to the existing "Failed Applicants" table.

Which of the following is not an example of when you would use an append query?

Any records that are in both the NJ Customers and NY Customers table should be deleted from both tables.

Which of the following statements is TRUE when comparing forms and reports?

Creating forms and reports begins by sketching an outline of the form or report.

A(n) ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

Datasheet form

The Report ________ section of a report is used for report totals and other summary information.

Footer

All of the following are form creation tools EXCEPT:

Form Layout

To sort the order of records in a form, you need to open the form in

Form View

What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance?

Layout

If you need to sort the records contained in a report, you can do so from the ________ of the report.

Layout View

Which of the following is true about lookup fields?

Lookup fields do allow the user to enter values not found on the list by default, but it can be switched to block users from doing so.

To create a missing data query and find multiple fields that are missing data, each field must be checked for blank values and joined by a(n) ________ condition.

OR

All of the following are sections of an Access Form EXCEPT:

Page Header Section

You need to create a report from an Access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?

Page numbers would included on the page footer section and the grand total would be included on the report footer section.

________ queries always require input from the user.

Parameter

Calculations can not be created in a(n) ________.

PivotChart

One example of data mining is a(n) ________, where users can sort, filter, and dynamically reorder data.

PivotTable

The table or query that supplies underlying data to a form or report is called the:

Record source

All of the following are sections in an Access report EXCEPT

Report Calculated section

Jill must create a report for an Access database, but is unfamiliar with creating reports in Access. Which Report tool should Jill use?

Report Wizard

Which of the following statements is true in reference to comparing the sections in Access forms and the sections in Access reports?

Reports have more sections than forms, but working with report sections is similar to working with form sections.

If you wanted to set up a rule to tell the database that the value in the field SaleDate must come before the DeliveryDate, you would set the condition in the data macro for this form to ________.

SaleDate < DeliveryDate

You can use Form view to ________ the data in a report, for example, to organize fields in order from A to Z.

Sort

Which of the following statements accurately describes a split form?

Split forms combine two different views of the same record source

The ________ displays form fields in vertical column, and displays one record at a time.

Stacked Layout

Aggregate reports can use all of the following functions except ________.

Subtraction

Which of the following statement is true in reference to the report Detail section?

The Detail section repeats for every record in the record source.

Which of the following statements about aggregate reports is true?

They can help detect data entry errors.

Steve is working in a database that holds patient data for a medical center. A patient's identification number serves as a primary key in the Patient table. A patient's identification number serves as a foreign key in the Doctor table. Steve wants to create a Form that displays Doctor table records with foreign key values that match the primary key value in the Patient table. How should Steve proceed?

Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a subform to his form.

Of the following, the worst choice for a lookup field is ________.

Web site URL

In order to create a parameter query, text in the criteria row must be surrounded by the ________ characters.

[ ]

An input mask can not display the # sign, unless you enter a ________ character before the # to display it as a literal.

\

All of the following are examples of when you would use a find duplicates query except ________.

a foreign key value may be repeated in a table

A PivotTable cannot be based on ________.

a form

The category of queries that allows automation of additions, changes, and removal of records from a database is ________.

action

The form Layout view can be used for all of the following EXCEPT

adding a calculated field.

Database ________ is a career in which a person manages, secures, upgrades, and backs up databases.

administration

In order to copy records from another table and add them to another table, a(n) ________ query can be used.

append

Since there is no "move" query, a database administrator could simulate moving records to an existing table by using a(n) ________.

append query followed by a delete query

When a make table query is run, field properties ________.

are inherited from the selected fields

A ________ control, like a text box, is linked to data sources while a ________ control, like a label, is used to describe data and create aesthetically pleasing forms.

bound, unbound

If a user wanted to add a field to calculate how many of each individual product should be ordered by taking the desired number of in-stock items and subtracting the current inventory , a(n) ________ must be added to a PivotTable.

calculated detail field

In order to sum the results of aggregate functions, a(n) ________ must be added to a PivotTable.

calculated total field

One example of a situation that calls for an update query is when a user wants to ________.

change values for records that meet a certain criteria

Any field whose values will be used to identify PivotTable data appearing the top of the screen (with values appearing as headings from left to right), is referred to as a(n) ________ field.

column

Adding a ________ is the way to add a list of available field choices to a form.

combo box

Each object you place on a form is called a(n) ________.

control

A query that will summarize information and allow users to create something similar to a PivotTable is a(n) ________ query.

crosstab

A Web site suggesting books you might be interested in based on what you have purchased is demonstrating an example of

data mining

A Web site suggesting books you might be interested in based on what you have purchased is demonstrating an example of ________.

data mining

A query that will allow the selection and removal of records from a database is a(n) ________ query.

delete

If you set the option to Allow Edits to Yes, the option to Allow Additions to No, and the option to Allow Deletions to Yes, users will be able to ________.

delete and update, but not add records

In order to sum individual field values in a PivotTable, a calculated ________ field can be added.

detail

Any field used to exclude PivotTable data dynamically is referred to as a(n) ________ field.

filter

A query that will find repeated values in a database is a(n) ________ query.

find duplicates

In order to find products in the Product table that have never been ordered in the Orders table, a database administrator can create a(n) ________ query.

find unmatched

In order to find records that are in one table but not in another, a database administrator can create a(n) ________ query.

find unmatched

Restricting edits in a form cannot block users from ________ records.

finding

The options to restrict edits for a form can be found on the ________ property sheet.

form

The number of column fields in a PivotTable ________ the number of row fields.

has no impact on

If a database designer wishes to specify the exact format of a field (for example, a social security number), which field property must be set?

input mask

If a user needs to show a series of values and wants to create a PivotChart that graphs their values over time, they would create a(n) ________ chart.

line

If a database designer wants to ensure reliable data entry by providing a user a list of choices for a field, they would specify the ________ field property.

lookup field

A query that will apply criteria to a table and store the results in a new table is a(n) ________ query.

make table

If a database designer creates an input mask on a form rather than a table, the input mask will apply to ________.

that specific form only

In a one-to-many relationship, ________.

the parent is the one table

All of the following are advantages of action queries except ________.

they can not cause data corruption

One example of a situation where you would use an update query is ________.

to change the Delinquent field to "Yes" for customers who owe more than $1,000 and have not made a payment in two months

One example of a situation where you would not use an update query is ________.

to move all graduating students out of the Current Students table

Tab order's Auto Order function will set the tabs to go in a ________ order.

top to bottom, and then left to right

You use a(n) ________ control to display text or decorative elements on a form.

unbound

A PivotTable can contain ________ row fields.

unlimited

If a user needs to change data values based on a condition, they should use a(n) ________ query.

update

All of the following are examples of table events except ________.

view

All of the following are events that can cause a data macro to execute except ________.

when an input mask rule is violated