BCIS Exam 2 ACCESS

The IIf function requires ________ parameters.

3

What happens when you click a hyperlink field value while in Datasheet view?

Access launches the program required to display the file or Web page

Why should you backup your database before running an action query?

Action queries are irreversible

Where do the column headings display in a crosstab query?

Along the top of a crosstab query

Which of the following is NOT a correct way to Add a calculated control to a form or report?

Create a formula in a bound control

What summarizes a data source into a grid of rows and columns?

Crosstab query

Which type of query calculates data using a sum, average, or other function and groups the results by two sets of values?

Crosstab query

Which data validation method enables you to execute programming tasks whenever data in a table is changed?

Data macro

Which view gives a designer a higher level of control when creating forms and/or reports?

Design view

Which of the following enables you to create mathematical functions in Access?

Expression builder

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

FALSE

A page footer appears at the bottom of the last page of a form or repor

FALSE

A required field can be left blank when entering a record.

FALSE

After you export an Access table to an RTF file, the file cannot be edited in Word.

FALSE

An append query deletes records from one or more tables and adds them to an existing table

FALSE

An append query is used to update or change data automatically based on criteria that you specify.

FALSE

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

FALSE

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases

FALSE

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

FALSE

If the destination table exists and you run the make table query, Access automatically deletes the source table

FALSE

If the destination table exists and you run the make table query, Access automatically deletes the source table.

FALSE

If you make a mistake when entering a hyperlink, you can edit the link by clicking and correcting it.

FALSE

Linking and importing produce the same result in Access.

FALSE

Once a hyperlink has been added to a table, it cannot be edited.

FALSE

Sections can be used in reports but not in forms.

FALSE

Subforms have to be created using the Form Wizard.

FALSE

The Tab order of a form cannot be changed.

FALSE

The user provides the criterion at run time when using a lookup list.

FALSE

Unbound controls are controls that are tied to specific fields.

FALSE

When creating a parameter query, you are limited to a single parameter in the Criteria row for a given field.

FALSE

When running an append query, the data types of the source fields do not have to match the data types of the destination fields.

FALSE

When using an input mask, data is still not necessarily consistent

FALSE

You can use Undo when running an update or delete query

FALSE

Validation rules are entered in the ________ pane.

Field Properties

Which of the following appears once at the top of each page in a form or report?

Form or Report Page Header

________ affects the display of the date without affecting the underlying value.

Formatting

Which of the following function checks to see if a field has no value?

IsNull

Where does a Group Footer appear?

Just below the Detail section

Which of the following displays when you insert a text box?

Label control

Which two views make it easy to edit the design of a form?

Layout view and Design view

What are two options for adding emphasis to your form or report?

Line or rectangle control

A field with a number of repeated values may be better suited as what kind of field?

Lookup field

When two functions are not sufficient to evaluate an expression, you may need to use a(n):

Nested function.

The expression IIf(IsNull([ClosedDate]),"Open","Closed") displays ________.

Open when the ClosedDate field has no value and Closed otherwise

You CANNOT export Access data to a(n) ________.

PowerPoint presentation

To prevent any changes to a form, select the No option for Allow Additions, Allow Deletions, and Allow Edits in the ________

Property Sheet

How do you switch on or off sections of a report or form?

Right-click a blank area

What must you do once a text box has been converted to a combo box?

Set a source for the combo box

A calculated control contains an expression that generates a calculated result.

TRUE

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

TRUE

A parameter query is similar to creating most other query types.

TRUE

Action queries display different icons than select queries in the Navigation Pane.

TRUE

After exporting a file, if the document is too wide to display all the text, it will display on two pages

TRUE

An append query is used to add records to an existing table

TRUE

An attachment appears as a paperclip in a table.

TRUE

An input mask forces users to conform to a specific data-entry format for a given field.

TRUE

Backing up the database prior to running an update query is the best precaution

TRUE

Backing up the database prior to running an update query is the best precaution.

TRUE

Before exporting a table to another database, the new database has to be created.

TRUE

Bound, unbound, and calculated controls are not found on the Controls group on the Design tab.

TRUE

Columnar forms and reports do not export to Word properly.

TRUE

For phone numbers, the input mask helps ensure consistency in data entry

TRUE

If a validation rule is not met, you CANNOT continue until the data value meets the rule

TRUE

If no caption has been set for a field, the label will default to the field name.

TRUE

It is recommended to preview results before running a delete query.

TRUE

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

TRUE

One reason an append query can fail is because of duplicate primary keys in the source and destination tables

TRUE

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

TRUE

The detail section of a form or report displays in between the headers and footers sections

TRUE

The find unmatched query only works if two tables share a common field

TRUE

To add emphasis to a form or report, use the Line control or the Rectangle control.

TRUE

Unbound controls do not require data entry so a tab stop can be removed.

TRUE

When a field is designated as required, it CANNOT be left blank

TRUE

When a field is designated as required, it CANNOT be left blank.

TRUE

When a form has been created as read-only, it should be renamed to indicate it is read-only.

TRUE

When adding a file to an attachment field, the file is actually copied into the database itself.

TRUE

When choosing fields from two different tables using the Form Wizard, Access automatically assumes you want a form with a subform

TRUE

When there is more than one parameter in a query, Access asks for the information starting from the left and moving to the right.

TRUE

You can use Date() in the default value property to insert the current date when a new record is added.

TRUE

You would use a find duplicates query to find the same values in a table.

TRUE

What happens when you export a form with a subform to Excel?

The form exports but the subform does not.

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

The size of the database remains the same

A(n) ________ is the location of a Web site or Web page on the Internet.

URL

What data validation method is designed to restrict the data values entered into a field?

Validation rule

Which application allows you to view XPS documents if the XPS viewer has not been installed?

Your browser

A(n) ________ query can be used for adding records to an existing table

append

The process of creating a make table query is very similar to which other type of query?

append query

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

combo

A(n) ________ helps to reduce editing time when there is a common value in a field

default value

You would use a(n) ________ query to remove the records of former employees from a table

delete

Calculated controls begin with a(n):

equal sign (=)

A(n) ________ forces users to conform to a specific data entry format for a given field

input mask

When you ________ an external table, you connect to the table without actually importing the table's data.

link

The data validation method that causes fields to be limited to predefined list of values is a:

lookup list

A(n) ________ accepts two or more options in a lookup field

multiple-value field

When editing a hyperlink, it is enclosed in ________, which Access uses to activate the link when clicked.

pound signs (#)

A(n) ________ sets the property of a field to force data entry

required

A field that cannot be left blank when you create a new record is a:

required field

To test an update query before running it, you can

switch to Datasheet view.

You would use a(n) ________ query to make changes to the retail price field for records meeting a specified criteria.

update