Deck 8: Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Question 1

Changes to a record can be undone by using the Undo button or by pressing Esc just after the change is made while you are still in ________ mode.

A) Navigation
B) Edit
C) Update
D) Repair

Answer 1

B

Question 2

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) Report Wizard
B) Form Designer
C) Form Wizard
D) Report Designer

Answer 2

C

Question 3

Within each record in a main form,you can use a combination of the arrow keys and the ________ keys to move from field to field.

A) Esc, Home, Ctrl, Enter
B) Tab, Enter, Ctrl, End
C) Alt, Home, Enter, End
D) Tab, Home, Ctrl, End

Answer 3

D

Question 4

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

Question 5

Because the action is permanent,you CANNOT use the ________ button after you confirm a deletion.

A) Undo
B) Esc
C) Tab
D) Edit

Question 6

You must be viewing a form in ________ view to make changes to the data in a form.

A) Design
B) Datasheet
C) Form
D) Report

Question 7

If a table is not part of a relationship,________ can be deleted from a single table without additional steps.

A) forms
B) records
C) queries
D) data

Question 8

A ________ is a form created from one table,but has both a Form view and a Datasheet view in the same window.

A) report
B) subform
C) split form
D) normal form

Question 9

When you open a(n)________ in Access it opens in a new window with a tab.

A) object
B) form
C) query
D) report

Question 10

You are in ________ mode when you can see the blinking insertion point in a field.

A) insert
B) edit
C) navigation
D) overview

Question 11

When you create a form from two tables,the first table you select is the ________ form.

A) principle
B) secondary
C) subsequent
D) main

Question 12

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

A) Normal
B) Form
C) Datasheet
D) Design

Question 13

When you have a form with a ________,you have two Navigation bars.

A) subform
B) theme
C) report
D) query

Question 14

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

A) bound
B) label
C) calculated
D) unbound

Question 15

To find data in for or a datasheet,you can use the ________ command.

A) Navigate
B) Scroll
C) Search
D) Find

Question 16

In ________ mode,you can move from record to record and field to field using keystrokes.

A) navigation
B) edit
C) overview
D) insert

Question 17

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

A) bound control
B) label
C) text box
D) unbound control

Question 18

When records are added to a form,they are actually added to the ________ it is stored in.

A) query
B) datasheet
C) form
D) table

Question 19

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

A) unbound control
B) calculated control
C) label
D) text box

Question 20

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

A) text box
B) control
C) element
D) label

Question 21

To add a subtotal to the Group,Sort,and Total pane,you must first be in ________ view.

A) Design
B) Layout
C) Print Preview
D) Report

Question 22

You can tell when you are in navigation mode,because the text of a field is selected and highlighted.

Question 23

The ________ theme is the default for Access reports.

A) Austin
B) Epic
C) Access
D) Office

Question 24

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

A) Special formatting
B) Value formatting
C) Conditional formatting
D) Field formatting

Question 25

To remove a conditional formatting rule,click the Format tab in Layout view,select the field that has the conditional formatting applied,click Conditional Formatting in the Control Formatting group,select the rule you wish to remove,and then click ________.

A) Delete Rule
B) Remove Rule
C) Delete Formatting
D) Remove Formatting

Question 26

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

A) themes
B) totals
C) subtotals
D) subreports

Question 27

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

A) text box
B) label
C) control
D) subform

Question 28

Groups are added to a section of the report called the ________.

A) group header
B) group footer
C) group window
D) group area

Question 29

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

A) group
B) query
C) report
D) form

Question 30

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

A) template
B) package
C) design
D) theme

Question 31

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) Report
B) Layout
C) Design
D) Print Preview

Question 32

Because it is smaller than the original document,an Adobe ________ file is easy to send through e-mail.

A) PDF
B) XML
C) EXE
D) DOC

Question 33

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 ________ form.

A) main
B) split
C) divided
D) sub

Question 34

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

A) Report
B) Design
C) Print Preview
D) Layout

Question 35

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

A) single
B) main
C) multiple
D) secondary

Question 36

________ not only lets you see how the report will look when it is printed,it also provides you with options to make design changes to the report before you send it to the printer.

A) Design view
B) Report view
C) Layout view
D) Print Preview

Question 37

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

A) themes
B) forms
C) page breaks
D) queries

Question 38

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

A) delete
B) select
C) add
D) format

Question 39

A ________ is a formatted printout of data.

A) form
B) datasheet
C) report
D) query

Question 40

Working with forms is convenient,because you can see all the records at one time.

Question 41

Page breaks display in the Report view.

Question 42

Reports can ONLY be created from a table.

Question 43

The view that offers more options for adding and editing controls on a report,including options not available in any of the other views is the Design view.

Question 44

If a data text box on a report displays ########,the field is not wide enough to display all the date.

Question 45

To add a theme to a form,you MUST first change to Layout view.

Question 46

In a split form,you cannot highlight a different record in the form part and the datasheet part at the same time.

Question 47

When you add pictures to a form,a different picture CANNOT be added for each record.

Question 48

When records are deleted from a form,they are actually deleted from the query it is stored in.

Question 49

A label CANNOT be added unless you also add a text box.

Question 50

When you create a report from one table,it is a single table report.

Question 51

When you add a label to a footer,you must manually expand it to fit the text.

Question 52

To make a form more visually appealing,you can add pictures and images.

Question 53

Controls are used on reports,but are NOT used on forms.

Question 54

If you CANNOT see the entire form on the screen,you need to reduce the form size.

Question 55

A bound control is a control that does NOT have a source of data such as the title of the form.

Question 56

When you create a form using two tables with a one-to-many relationship between the tables,Access will automatically use the common field between the tables to create the form.

Question 57

You should add fields to the report wizard in the order in which you want the fields to appear in the report.

Question 58

A split form displays data from two different tables,with the information from the main table at the top of the window,and the information from the secondary form in the bottom of the window.

Question 59

In a report,you can change the appearance of a control by adding borders or fill color.

Question 60

Once you have created a form,you must change to the Layout view or the Design view to make changes to the form.

Question 61

You CANNOT select a(n)________ other than Office while using the Report Wizard.

Question 62

When records are deleted from a form,they are actually deleted from the ________ it is stored in.

Question 63

When you create a form using two related tables,the main form will display the first table one record at a time,while the ________ will display as a datasheet below the main form record.

Question 64

The ________ is the section of the report to which groups are added.

Question 65

You can sort up to ________ fields in either ascending or descending order in a report.

Question 66

You can apply a(n)________ to a single object or to all matching objects.

Question 67

If you need to change the sorting and grouping options of your report,you can do this from the Layout view or the Design view.

Question 68

________ in a report created using the Report wizard are in the order that the fields are added to the report.

Question 69

Sally has created a report where the totals display as a bold red font with a light red background when dollar values go below $0.This is an example of ________.

Question 70

When you create a form from two tables that have a one-to-many relationship,the second table you select becomes the ________.

Question 71

When using a form,you can print one ________ at a time.

Question 72

If you need to have calculations performed on a group in a report,they are added to the ________ section.

Question 73

A(n)________ control is a control that does NOT have a source of data such as the title of the form.

Question 74

The default theme used by Access when you create a report using the Report Wizard is the ________ theme.

Question 75

A form created from one table that has both a Form view and a Datasheet view is called a(n)________.

Question 76

To see what the report will look like when it is printed,you should change to the ________ view.

Question 77

When you are in ________ mode,the blinking insertion point is in the field.

Question 78

________ view is only for viewing and changing data in a form.

Question 79

You can create a custom ________ by putting together a combination of fonts and colors.

Question 80

When you save a report as an Adobe PDF file,the PDF file is usually larger than the original document.