Question 1

A control that has a field in a table as a data source is called a(n)________ control.
A)label
B)bound
C)unbound
D)calculated

Accepted Answer

A bound control is a control that has a field in a table as a data source.

Question 2

In a form, ________ view is a more advanced view that allows you to change the properties or structure of the form.
A)Datasheet
B)Normal
C)Form
D)Design

Accepted Answer

Design view is the advanced view that allows you to modify the properties or structure of a form.

Question 3

The ________ theme is the default for Access reports.
A)Access
B)Epic
C)Office
D)Austin

Accepted Answer

The "Office" theme is the default theme for Access reports, providing a consistent look with other Microsoft Office applications.

Question 4

An unbound control that can be the name of a field or any other text you manually enter is called a(n)________.
A)label
B)text box
C)calculated control
D)unbound control

Accepted Answer

A label is an unbound control that can display text, such as the name of a field or any other text you manually enter.

Question 5

Before you can move or resize a control, you MUST ________ it.
A)delete
B)format
C)add
D)select

Accepted Answer

Before moving or resizing a control, you must select it to ensure that the specific control is the one being modified.

Question 6

To filter data or copy parts of the report to the Clipboard, you should change to the ________ view.
A)Report
B)Layout
C)Design
D)Print Preview

Accepted Answer

The Report view is used to filter data or copy parts of the report to the Clipboard.

Question 7

________ allows you to format fields depending on conditions you specify.
A)Special formatting
B)Field formatting
C)Conditional formatting
D)Value formatting

Accepted Answer

Conditional formatting allows you to apply specific formatting to fields based on certain conditions or criteria you set.

Question 8

Silvia is modifying her report design while the data is displayed on her monitor. This view, which makes changes immediately visible, is called the ________ view.
A)Print Preview
B)Report
C)Design
D)Layout

Accepted Answer

The Layout view allows users to modify the design of a report while simultaneously viewing the data, making changes immediately visible.

Question 9

A control whose data source is a calculated expression that you create is called a(n)________ control.
A)bound
B)calculated
C)unbound
D)text box

Accepted Answer

A control whose data source is a calculated expression that you create is called a calculated control. This type of control is used to display the result of a calculation.

Question 10

A(n)________ table report must use tables that have a common field.
A)secondary
B)main
C)single
D)multiple

Accepted Answer

A multiple table report requires tables that have a common field to join them together and display related data from each table.

Question 11

Because there are no ________ shown in Report View, you must change to the Print Preview view to see them.
A)queries
B)page breaks
C)forms
D)themes

Accepted Answer

Page breaks are not visible in Report View and require switching to Print Preview to be seen.

Question 12

A built-in combination of color and font is called a(n)________.
A)template
B)design
C)package
D)theme

Accepted Answer

A theme is a built-in combination of color and font used to maintain a consistent look and feel in documents or presentations.

Question 13

The part of a form or report that you use to enter, edit, or display data is called a(n)________.
A)text box
B)element
C)label
D)control

Accepted Answer

A control is an element on a form or report that you use to enter, edit, or display data.

Question 14

Similar to the Query Wizard, the ________ walks you through a step-by-step process to create a form from one or more tables in your database.
A)Form Wizard
B)Report Designer
C)Form Designer
D)Report Wizard

Accepted Answer

The Form Wizard is a tool in database software that guides users through the process of creating a form, similar to how the Query Wizard helps create queries.

Question 15

A bound control that represents the actual value of a field is called a(n)________.
A)bound control
B)label
C)unbound control
D)text box

Accepted Answer

A text box is a bound control that displays and allows the user to edit the actual value of a field in a database.

Question 16

A form that is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window is called a(n)________ form.
A)sub
B)divided
C)split
D)main

Accepted Answer

A split form displays each record individually at the top and as part of the whole table datasheet at the bottom, allowing for both detailed and overview views simultaneously.

Question 17

When ________ or groups are added to a report, it is broken into smaller sections.
A)totals
B)themes
C)subreports
D)subtotals

Accepted Answer

Subtotals break a report into smaller sections by summarizing data for specific groups within the report.

Question 18

To add additional fields or labels to a form, you can add a(n)________.
A)control
B)text box
C)label
D)subform

Accepted Answer

The answer of To add additional fields or labels to...

Question 19

A collection of records along with introductory and summary information about the records is called a(n)________.
A)query
B)form
C)report
D)group

Accepted Answer

The answer of A collection of records along with introductory...

Question 20

A ________ is a formatted printout of data.
A)form
B)datasheet
C)report
D)query

Accepted Answer

A report is specifically designed to present data in a formatted printout. Forms are used for data entry, datasheets are used to view and manipulate data, and queries are used to retrieve specific data from a database.

Quiz 6: Access

A control that has a field in a table as a data source is called a(n) ________ control.

In a form, ________ view is a more advanced view that allows you to change the properties or structure of the form.

The ________ theme is the default for Access reports.

An unbound control that can be the name of a field or any other text you manually enter is called a(n) ________.

Before you can move or resize a control, you MUST ________ it.

To filter data or copy parts of the report to the Clipboard, you should change to the ________ view.

________ allows you to format fields depending on conditions you specify.

Silvia is modifying her report design while the data is displayed on her monitor. This view, which makes changes immediately visible, is called the ________ view.

A control whose data source is a calculated expression that you create is called a(n) ________ control.

A(n) ________ table report must use tables that have a common field.

Because there are no ________ shown in Report View, you must change to the Print Preview view to see them.

A built-in combination of color and font is called a(n) ________.

The part of a form or report that you use to enter, edit, or display data is called a(n) ________.

Similar to the Query Wizard, the ________ walks you through a step-by-step process to create a form from one or more tables in your database.

A bound control that represents the actual value of a field is called a(n) ________.

A form that is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window is called a(n) ________ form.

When ________ or groups are added to a report, it is broken into smaller sections.

To add additional fields or labels to a form, you can add a(n) ________.

A collection of records along with introductory and summary information about the records is called a(n) ________.

A ________ is a formatted printout of data.