Access chapter 1,2, and 3

Which of the following controls can serve as hyperlink controls? Select all the options that apply.

\-logo

\-command button

\-label

Which of the following is a best practice when you are creating a table containing employee names? 

Separate the first and last names into two fields.

Use the _____ to exit Access.

Close button

When you use the _____, Access asks you for the information it needs to create a query.

Simple Query Wizard

The upper pane of _____ view shows field names and data types.

Table Design

A group of related fields, such as all the demographic information for one customer, is called a _____.

record

You can create an Access report by selecting fields from one or more tables or _____.

queries

Of all the database objects, a table provides the most formatting, layout, and summary options.

false

You might delete an employee record if the employee no longer works for the company.

true

Use the New (blank) record button to move the focus to the first record in a table.

false

Table Design view shows how each table relates to other tables in the database.

false

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

\- Move the focus to the next record.

\-Move the focus to the first record.

\-Create a new blank record.

You can export a query from one Access database to another.

true

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Save the table.

The first step in the Form Wizard is to _____.

select the fields to include in the form

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

false

In which object can you rename a field?

table

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

false

To display the data in a table, you open the table in Table Design view.

false

Press ESC to remove editing changes you made to the previous record.

false

Which two properties are required for every field?

 Field Name and Data Type

You can create a mail merge in Word using name and address data stored in Access.

true

Which of the following are Access objects? 

\-forms

\-queries

\-reports

Which of the following is the fastest way to open an Access database?

Double-click the database icon.

Which of the following is a difference between Table Design view and Table Datasheet view?

Table Design view does not display data.

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

\-down arrow key

\-tab key

\-next record button

To back up a database, you use the _____ command.

\-back up database

Which of the following are features of Access reports? Select all the options that apply.

\-calculations on groups of records

\-footers

\-headers

What should you do when you are finished working a database?

 Close the database.

_____ view is a spreadsheet-like view of the data in a table.

datasheet

In what part of the Access window do you rename a form?

navigation pane

Which data type is used for sequential integers controlled by Access?

auntonumber

Besides reducing file size, what other benefit does compacting an Access database provide?

 repairing the database

In a datasheet, which mode do you use for changing the value of a field?

edit mode

\
Which data type stores only one of two values?

 Yes/No

Which Access object contains all of the data in the database?

table

The _____ refers to the data you would edit if you started typing.

focus

Each row in a table datasheet displays a _____.

records

Which of the following are tasks you perform when creating tables? Select all the options that apply.

\-define the fields in the table

\-selected a data type for each field

\-name the table

After you create a table, you must save the entire database so you do not lose the new table.

false

When can you rename a table?

 after you close the table

_____ is the default name for a new table in an Access database.

 Table1

Before you close a database, you must save any changes you made to the data.

false

To navigate to a record in a table, switch to Table Design view.

false

\
When you _____ a database, you reduce the size of the database by up to 75 percent.

 compact and repair

Because it can be dangerous to leave action queries in the Navigation Pane, you can _____ an action query you want to run again.

hide

Which of the following are properties you can set for a field? Select all the options that apply.

\-field size

\-default value

\-field name

To reverse the last action you took in a database, click the _____ button.

undo

To rename a field in Table Datasheet view, you change the text in the _____.

column heading

When you enter a record in a table, you are working in navigation mode.

false

\
When you add a field to a table in Table Design view, entering the field name is optional.

false

Using Microsoft Excel, you can open and edit Access data you export as a RTF file.

false

A parameter query displays a dialog box that prompts you for field criteria.

true

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

 Referential integrity

To move a field in Table Datasheet view, you select the column and then _____.

drag it to a new location

You can use the _____ to copy data from Excel to Access.

Import Spreadsheet Wizard

When you import Excel data, you create a link to the data in the Access database.

false

An aggregate function is _____.

a function that calculates a statistic such as a subtotal or average

Mail fields are codes that Word replaces with field values when processing a mail merge.

false

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

tables

Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.

\-identifaction number

\-customer ID

\-customer number

To export query data to Excel, you _____.

click the External Data tab, and then click the Excel button in the Export group

To relate two fields in a one-to-many relationship, you connect them using a _____.

common field

To list values in a Number field in order from lowest to highest, you use the _____ button.

asending

If a report contains financial data that you want to analyze, you can export the report as a(n) _____ file.

 Excel

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

true

The goal of building one-to-many relationships between tables is to minimize _____ data.

 redundant

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

parameter

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

row headings

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

startup

The linking field on the “many” side of a one-to-many relationship is called the foreign key field.

True

Which of the following are techniques for copying Access data to other Office apps? Select all the options that apply.

\- copy and paste (Office Clipboard)

\-drag and drop

\-exporting

Which field is always on the "one" side of a one-to-many relationship between two tables?

primary key field

What should you do before applying a new filter to a datasheet?

Clear all previous filters.

To filter for comparative data, use the _____ feature.

Filter By Form

To remove filter criteria from the Filter by Form grid, you _____.

click the Advanced button, and then click Clear All Filters

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

from highest to lowest Price

If you want to export records to another Access database, create a Top Values query.

false

Which of the following statements are true about field properties? Select all the options that apply.

\-The properties can be used to change the way data is displayed.

\-Some properties are required, and some are optional.

\-Modifying the properties helps ensure database accuracy.

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

false

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

\-byte

\-long integer

\-single

To move a field in Query Design view, you drag the field by its field selector.

true

Which of the following can you change when formatting a table?

background color

Why would you use Expression Builder to set a calculated field's property in Table Design view?

To make sure you use the correct syntax in an expression

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Find and Replace

You can modify the lookup settings for a field in Table Datasheet view.

false

To add, delete, or change fields in a query, you use Query Design view.

true

The easiest way to filter the records for an exact match is to use the _____ feature.

Filter By Selection

You can use a report to enter a record into the database.

false

Before you close a query datasheet, you must save your changes to the data.

false

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

 > 0

Use the Default field property to specify that an entry is required for the field.

false

What button do you use on the Query Tools Design tab to add a field list to a query?

Show Table button

What can you add to a query datasheet to display statistics for a group of records?

Total row

Which of the following fields are good candidates for a multivalue lookup field? Select all the options that apply.

\-preferred features

\-project team

\-task assigned to

What might you need to do after increasing the font size in a table datasheet?

Widen the columns.

Which Short Text field property should you use to indicate users must enter a value in the field?

required

To move a field in the query design grid, click its_____, and then drag it left or right.

 field selector

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

split form

A Make-Table query is a type of _____ query that creates a new table of data.

action