Question 1

Bound controls exist only to clarify or enhance the appearance of the form.

Accepted Answer

Bound controls are controls that are bound to a field in a table or query and provide a way for users to view, enter, or edit data. They serve a functional purpose in addition to enhancing the appearance of the form.

Question 2

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Accepted Answer

increase

Question 3

Which of the following is not an option that the Data Labels can produce?
A) series name
B) category name
C) value of the data point
D) legend name

Accepted Answer

Data labels can display the series name, category name, and value of the data point, but not the legend name.

Question 4

A tab control is an unbound control.

Accepted Answer

A tab control is a type of control that can be bound to a control source, but it is not automatically bound when it is created. Therefore, it is considered an unbound control until it is explicitly bound to a control source.

Question 5

A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

Accepted Answer

This statement describes the presence of record navigation buttons and information about the current record number and total number of records, which are typically found on datasheets.

Question 6

You can quickly create a miniature chart called a(n) ______________ that serves as a visual indicator of data trends directly within a cell.

Accepted Answer

The answer of You can quickly create a miniature chart...

Question 7

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?
A) Data
B) Legend
C) Titles
D) Gridlines

Accepted Answer

Choosing a new layout on the Chart Tools Design tab affects the visual elements of the chart like legend, titles, and gridlines, but it does not change the underlying data.

Question 8

Text annotations are ____ that you can add to further describe the data in your chart.
A) arrows
B) titles
C) labels
D) notes

Accepted Answer

The answer of Text annotations are ____ that you can...

Question 9

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel creates a query using the Name, Day of the Week, and Subdivision fields.He wants to sort the records by day of the week, beginning with Monday and ending with Sunday.He decides to number each day of the week: 1=Monday, 2=Tuesday, and so forth. 
a. Will his idea work? 
b. Why or why not? 
c. Should he plan to sort in ascending or descending order?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 10

Forms can be used to enter and edit data.

Accepted Answer

Forms are designed to allow users to input and edit data in a structured and easy-to-use format.

Question 11

The record selector button is to the right of a record in a datasheet.

Accepted Answer

The answer of The record selector button is to the...

Question 12

In Query Design View, record selectors are thin gray bars above the field names.

Accepted Answer

The answer of In Query Design View, record selectors are...

Question 13

Daniel Arno owns a lawn and landscape business.He has some very particular clients who want their lawns manicured on a specific day of the week.He has other clients who allow him to use his own judgement as to when their lawns need cutting.To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision, and fee.Daniel creates a table called Customers.For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Daniel wants to build a query that will show each customer name, day of the week (if specific), and subdivision.What criterion should he use to quickly find his customers whose day of the week varies?

Accepted Answer

The answer of Daniel Arno owns a lawn and landscape...

Question 14

When the mouse pointer hovers over any chart object, the name of the selected object appears on screen as a(n) ____________________.

Accepted Answer

The answer of When the mouse pointer hovers over any...

Question 15

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.
A) nested
B) combination
C) complex
D) exploded

Accepted Answer

The answer of You can apply a chart type to...

Question 16

On a form, text box controls display data from an underlying record source.

Accepted Answer

The answer of On a form, text box controls display...

Question 17

In a pie chart, slices that are pulled away are said to be ____.
A) identified
B) exploded
C) opened
D) extracted

Accepted Answer

The answer of In a pie chart, slices that are...

Question 18

Major ____ represent the values at the value axis tick marks.
A) Categories
B) Axis lines
C) Arrows
D) Gridlines

Accepted Answer

The answer of Major ____ represent the values at the...

Question 19

In forms created by using the Form Wizard, labels are generally in the first column, to the left of the text boxes they describe.

Accepted Answer

The answer of In forms created by using the Form...

Question 20

Each item on the form is called a control.

Accepted Answer

The answer of Each item on the form is called...

Quiz 2: Getting Started With Access 2.0

Bound controls exist only to clarify or enhance the appearance of the form.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Which of the following is not an option that the Data Labels can produce?

A tab control is an unbound control.

A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

You can quickly create a miniature chart called a(n) ______________ that serves as a visual indicator of data trends directly within a cell.

Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools Design tab?

Text annotations are ____ that you can add to further describe the data in your chart.