Access 2

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

a.Datasheet View

b.Layout View

c.Design View

d.Change View

c.Design View

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

a.Large

b.Maximum

c.MAX

d.LGE

c.MAX

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

a.Select Query

b.Design View

c.Query

d.Query Design

d.Query Design

A query that prompts for input whenever it is run is a dialog query.
True
False

False

The ____ operator allows you to search for a range of values in one field.

a.SEARCH

b.IN

c.RANGE

d.BETWEEN

d.BETWEEN

To include all fields in the design grid, double-click the question mark (?) in the field list.
True
False

False

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

a.Same

b.Group By

c.Like

d.Where

b.Group By

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.
True
False

False

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

a.Yes

b.On

c.Off

d.No

a.Yes

Crosstab queries are useful for summarizing data by category or group.
True
False

True

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.
True
False

False

The question mark (?) wildcard represents any collection of characters.
True
False

False

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

a.Where

b.Restrict

c.Having

d.Find

a.Where

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

a.Run

b.Open

c.Datasheet View

d.Design View

b.Open

A summary function is a function that performs some mathematical function against a group of records.
True
False

False

In fixed-width files, each record is on a separate line and the fields are separated by a special character.
True
False

False

When you enter text data in a criterion, you must enclose the text in quotation marks.
True
False

False

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

a.Preview

b.Query

c.Print

d.Print Query

c.Print

To save a query, click the Save button on the ____.

a.HOME tab on the ribbon

b.status bar

c.Quick Access Toolbar

d.CREATE tab on the ribbon

c.Quick Access Toolbar

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

a.Sort

b.List

c.Order

d.Show

a.Sort

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

a.semi-colon (;)

b.exclamation point (!)

c.equal sign (=)

d.colon (:)

d.colon (:)

Wildcards are symbols that represent any character or combination of characters. ____________________
True
False

True

The only calculated fields you can create in Access are those involving addition and subtraction.
True
False

False

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

a.Tables and Related Views

b.Table Object

c.Objects by Table

d.Default

a.Tables and Related Views

To create a parameter query that will prompt users to enter a city name as input, place as the criterion in the City field.
True
False

True

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

a.DATABASE TOOLS

b.FILE

c.CREATE

d.REPORT

c.CREATE

The asterisk (*) wildcard represents any collection of characters.
True
False

True

To order the records in the answer to a query in a particular way, you ____ the records.

a.sort

b.list

c.index

d.arrange

a.sort

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

a.EXTERNAL DATA

b.CREATE

c.DATABASE TOOLS

d.OFFICE EXPORT

a.EXTERNAL DATA

You cannot create a report for a query.
True
False

False

The field or fields on which records are sorted is called the sort key.
True
False

True

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

a.square brackets

b.curly braces { }

c.parentheses ( )

d.single quotes ''

a.square brackets

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a.Expression Builder

b.Build

c.Field Builder

d.Builder box

b.Build

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

a.Statistics

b.Calculations

c.Aggregate

d.Totals

d.Totals

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
True
False

True

To create a crosstab, click the ____ button on the CREATE tab.

a.Crosstab Wizard

b.Chart

c.Query Wizard

d.Statistics

a.Crosstab Wizard

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.
True
False

True

You can include ____ in calculations to indicate which calculation should be done first.

a.brackets

b.curly braces { }

c.slashes //

d.parentheses ( )

d.parentheses ( )

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

a.comparison operators

b.conditions

c.compound values

d.compound conditions

a.comparison operators

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
True
False

True

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a.Resize

b.Enlarge

c.Zoom

d.Magnify

c.Zoom

To show the Navigation Pane if it is hidden, click the ____ Button.

a.Restore

b.Shutter Bar Open/Close

c.Show/Hide

d.Show

b.Shutter Bar Open/Close

The expression for a calculated field can be typed directly into the Field row.
True
False

True

When you sort data in a query, the records in the underlying table are actually rearranged.
True
False

False

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

a.CREATE

b.FILE

c.EXTERNAL DATA

d.DATABASE TOOLS

c.EXTERNAL DATA

Grouping means creating groups of records that share some common characteristic.
True
False

True

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________
True
False

True

To enter a number in a criterion, type the number without any dollar signs or commas.
True
False

True

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.
True
False

True

You can export data from Access to the standard Word format.
True
False

False

Access 2 - Subjecto.com

Access 2

Your page rank:

Total word count: 1323
Pages: 5

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

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

a.Datasheet View

b.Layout View

c.Design View

d.Change View

c.Design View

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

a.Large

b.Maximum

c.MAX

d.LGE

c.MAX

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

a.Select Query

b.Design View

c.Query

d.Query Design

d.Query Design

A query that prompts for input whenever it is run is a dialog query.
True
False

False

The ____ operator allows you to search for a range of values in one field.

a.SEARCH

b.IN

c.RANGE

d.BETWEEN

d.BETWEEN

To include all fields in the design grid, double-click the question mark (?) in the field list.
True
False

False

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

a.Same

b.Group By

c.Like

d.Where

b.Group By

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.
True
False

False

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

a.Yes

b.On

c.Off

d.No

a.Yes

Crosstab queries are useful for summarizing data by category or group.
True
False

True

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.
True
False

False

The question mark (?) wildcard represents any collection of characters.
True
False

False

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

a.Where

b.Restrict

c.Having

d.Find

a.Where

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

a.Run

b.Open

c.Datasheet View

d.Design View

b.Open

A summary function is a function that performs some mathematical function against a group of records.
True
False

False

In fixed-width files, each record is on a separate line and the fields are separated by a special character.
True
False

False

When you enter text data in a criterion, you must enclose the text in quotation marks.
True
False

False

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

a.Preview

b.Query

c.Print

d.Print Query

c.Print

To save a query, click the Save button on the ____.

a.HOME tab on the ribbon

b.status bar

c.Quick Access Toolbar

d.CREATE tab on the ribbon

c.Quick Access Toolbar

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

a.Sort

b.List

c.Order

d.Show

a.Sort

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

a.semi-colon (;)

b.exclamation point (!)

c.equal sign (=)

d.colon (:)

d.colon (:)

Wildcards are symbols that represent any character or combination of characters. ____________________
True
False

True

The only calculated fields you can create in Access are those involving addition and subtraction.
True
False

False

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

a.Tables and Related Views

b.Table Object

c.Objects by Table

d.Default

a.Tables and Related Views

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.
True
False

True

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

a.DATABASE TOOLS

b.FILE

c.CREATE

d.REPORT

c.CREATE

The asterisk (*) wildcard represents any collection of characters.
True
False

True

To order the records in the answer to a query in a particular way, you ____ the records.

a.sort

b.list

c.index

d.arrange

a.sort

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

a.EXTERNAL DATA

b.CREATE

c.DATABASE TOOLS

d.OFFICE EXPORT

a.EXTERNAL DATA

You cannot create a report for a query.
True
False

False

The field or fields on which records are sorted is called the sort key.
True
False

True

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

a.square brackets [ ]

b.curly braces { }

c.parentheses ( )

d.single quotes ”

a.square brackets [ ]

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a.Expression Builder

b.Build

c.Field Builder

d.Builder box

b.Build

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

a.Statistics

b.Calculations

c.Aggregate

d.Totals

d.Totals

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
True
False

True

To create a crosstab, click the ____ button on the CREATE tab.

a.Crosstab Wizard

b.Chart

c.Query Wizard

d.Statistics

a.Crosstab Wizard

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.
True
False

True

You can include ____ in calculations to indicate which calculation should be done first.

a.brackets [ ]

b.curly braces { }

c.slashes //

d.parentheses ( )

d.parentheses ( )

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

a.comparison operators

b.conditions

c.compound values

d.compound conditions

a.comparison operators

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
True
False

True

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

a.Resize

b.Enlarge

c.Zoom

d.Magnify

c.Zoom

To show the Navigation Pane if it is hidden, click the ____ Button.

a.Restore

b.Shutter Bar Open/Close

c.Show/Hide

d.Show

b.Shutter Bar Open/Close

The expression for a calculated field can be typed directly into the Field row.
True
False

True

When you sort data in a query, the records in the underlying table are actually rearranged.
True
False

False

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

a.CREATE

b.FILE

c.EXTERNAL DATA

d.DATABASE TOOLS

c.EXTERNAL DATA

Grouping means creating groups of records that share some common characteristic.
True
False

True

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________
True
False

True

To enter a number in a criterion, type the number without any dollar signs or commas.
True
False

True

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.
True
False

True

You can export data from Access to the standard Word format.
True
False

False

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