Access part 2

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

#5/7/2021#

Which of the following are views you can use to display a query? Select all the options that apply.

-Design view -Datasheet view

In Query Design view, how can you add a field from the field list to a column in the design grid? Select all the options that apply.

-Double-click the field in the field list. -Drag the field from the field list to a column in the design grid.

Which of the following are ways to run a query? Select all the options that apply.

-Double-click the query in the Navigation Pane. -Click the Run button in Query Design view. -Click the View button in Query Design view.

Which of the following options are available as you filter a datasheet? Select all the options that apply.

-Filter By Form -Filter By Selection

Which of the following statements describe a filter? Select all the options that apply.

-In a datasheet, a filter displays only those records that match criteria you specify. -A filter displays a temporary subset of records in the current datasheet. -A filter is not as powerful as a query.

Which of the following are form views? Select all the options that apply.

-Layout -Design -Form

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options that apply.

-Sum -Average -Count

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

-Which of the following statements are true about subdatasheets? Select all the options that apply. -You can click the expand button to view the records in a subdatasheet. -You can navigate and update a subdatasheet.

Which of the following statements describe Query Design view? Select all the options that apply.

-Which of the following statements describe Query Design view? Select all the options that apply. -The query design grid provides a way to sort records. -Query Design view lets you modify an existing query.

Which of the following formatting enhancements do themes apply to reports? Select all the options that apply.

-background color -font color -font

What information does the Form Wizard request as it creates a form? Select all the options that apply.

-fields -layout -title

Which of the following options can you set when creating a report with the Report Wizard?

-grouping field -sort order -orientation

Which of the following changes can you make to a report in Print Preview? Select all the options that apply.

-switch the report orientation -change the margins

Connor wants to display records for orders placed before January 1, 2020. Which of the following criteria should he use in the OrderDate field in Query Design view?

<#1/1/2020#

Which of the following are examples of correct criteria syntax? Select all the options that apply.

>= #1/1/2021# < "Anderson" <= 33.50

What happens when you run a query from Query Design view?

Access displays a datasheet containing the query results.

How can you display the title of a report in green?

Change the font color of the label in the Report Header.

Which of the following formatting changes can you make to a datasheet?

Change the font size.

How can you list the records in a query datasheet in A-Z order by CustomerName?

Click a value in the CustomerName field, and then click the Ascending button.

Jocelyn is working with a datasheet that displays client information, including the client's state. She wants to display only clients from Ohio (OH). After clicking the State field, how can she use Filter By Selection to display only clients from Ohio (OH)?

Click any value in the State field, click the Selection button, and then click Equals "OH".

Jack wants to find the number of records containing "Unpaid" in the Invoice field. Which of the following aggregate functions should he use in Query Design view?

Count

How do you display the results of a query listed in the Navigation Pane?

Double-click the query.

When you are creating a calculated field in a query and you do not know all parts of the expression, you can use the _____ to provide options for the expression.

Expression Builder

To import data from Excel to Access, you would begin by clicking the ____.

External Data tab

A report is an easy-to-use data entry and navigation screen.

False

Access adds # signs around text criteria in Date/Time fields.

False

Before closing a report in Print Preview, you must remove any conditional formatting from the report.

False

By default, the objects you create in a database are formatted with the Normal theme.

False

Clicking the expand indicator in a datasheet displays related records from other tables in the database.

False

Hiding a column in Table Datasheet view removes the field from Table Design view.

False

In Form Design view, you can make design changes while displaying the data.

False

In Report Layout view, you can select the control containing the report title and then change the font color.

False

In Report Layout view, you use the Format Painter to change the theme of a report.

False

In a datasheet, you can find data, but not replace it.

False

Sorting a table datasheet temporarily displays only those records that match given criteria.

False

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

False

Switch to Form Design view when you want to modify a form design while displaying the form data.

False

The Alternate Background Color command changes the background color of alternate records in a selected section.

False

The edits you make in a query datasheet do not affect the data in the underlying table.

False

To delete a field from a query, drag the field out of its field list.

False

Use Query Design view to display the results of a query.

False

When you click the Font Color arrow, the gallery displays a row of standard colors and a palette of colors that depend on the object's layout.

False

When you import Excel data into an existing Access table, you relate the data to the table.

False

When you sort on two fields in Query Design view, the sorted fields must appear next to each other in the query grid.

False

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

False

You can navigate form records using the same keyboard shortcuts as you use to navigate report records.

False

You switch to Report Layout view to display the entire report as it will appear when printed.

False

You use a subdatasheet to modify a field's properties.

False

You use the Filter By Selection feature to sort and filter records at the same time.

False

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

Filter By Selection

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

Which view can you use to add a new record to a table?

Form view

To temporarily remove the display of a selected field in Table Datasheet view, right-click the field and then click _____.

Hide Fields

In Form view, how can you navigate to the previous record in the form?

In Form view, how can you navigate to the previous record in the form?

To add a picture to the Form Header section, click the _____ button on the Design tab when modifying the form.

Logo

When you create a form containing data from two tables that have a one-to-many relationship, what type of form are you creating?

Main form with a subform

Which Access feature asks you a series of questions and then creates a report based on your answers?

Report Wizard

Which Access tool guides you through the steps of creating a report?

Report Wizard

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

Show Table button

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

The Bonus column no longer appears in the datasheet, but is still part of the Employees table.

To apply the last filter you selected to a datasheet, you click the _____ button.

Toggle Filter

When you add the _____ row to a query datasheet, you can select an aggregate function for a field.

Total

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

True

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

True

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

True

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

True

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

True

To rearrange the columns of a table without changing the order of the fields in the table structure, move a field in Table Datasheet view.

True

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

True

When you use the Report Wizard to create a report, you can base the report on a table or a query.

True

As you create a report, when might you want to work in Report Layout view?

When you want to view the data as you change the report.

Click the CustomerName column heading.

Widen the columns.

What are you doing when you enter data into a subdatasheet?

You are entering records in the related table.

What happens when you apply a theme to a form?

You can choose whether to apply the change to that form or to all forms and reports.

How do you display the records in a subdatasheet?

You click the expand button in the datasheet.

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

common field

A _____ is an item on a form that you can manipulate to modify the form's appearance.

control

You use Query Design view to add _____ to determine which records are shown in the resulting datasheet.

criteria

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

drag it to a new location

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

field selector

A _____ is a set of restrictions you place on records in an open datasheet or form to temporarily display a subset of records.

filter

You can use the Find command to find and then change data in a datasheet or a _____.

form

When you use the Or logical operator with query criteria, the number of records returned by the query is _____ the number of records when using the And logical operator with the same criteria.

greater than

Which process is most like copying and pasting?

importing

Eric wants a query to select records with a HireDate field value greater than 12/31/2015 and a Position value of "Manager." Where should he place the conditions in the query design grid?

in the same Criteria row

Using the Report Wizard, you can select the _____ for the report.

layout

Query Design view presents the fields you can use for a query in small windows called field _____.

lists

David is using the Form Wizard to create a form based on two tables that have a one-to-many relationship. What type of form is he probably creating?

main form with a subform

When you remove a control layout from a form or report, Access ____.

no longer groups the controls together

When using the Form Wizard, you can select fields from tables and _____ in the database.

queries

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

query design grid

A _____ is a saved object within the database, whereas a _____ is temporary.

query; filter

You can use a wizard to create a _____, a formatted printout or display of the contents in tables or queries.

report

To close a report in Print Preview and keep Access running, you _____.

right-click the report tab, and then click Close on the shortcut menu

To delete a record in Table Datasheet view, you first click the _____ and then click the Delete button.

row selector

If you sort a query first on the values in the Department field and then on the values in the LastName field, the LastName field is called the _____ sort field.

secondary

In Table Datasheet view, a(n) _____ shows related records from other tables in the datasheet.

subdatasheet

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

the positions offered by each employer

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

to the right of the City field