Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

etm 1030 > AL1 C5 C6 > Flashcards

AL1 C5 C6 Flashcards

1
Q

When navigating in a form, press _____ to display the last record.

A

Ctrl + End

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

For a split form, the top half of the work area displays the form in _____ view while the bottom half displays the form in _____ view.

A

Layout; Datasheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What happens when you click the Date and Time button in the Header/Footer group on the Form Layout Tools Design tab?

A

The Date and Time dialog box displays.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

To display buttons and options for applying formatting to a form, click the

A

Form Layout Tools Format tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When Access creates a form from a table, the cells in the first column in the Detail section of the form contain

A

the label control objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the two components of an Access theme?

A

a color theme and a font theme

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Create a form using the Form button in the _____ group on the _____ tab.

A

Forms; Create

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Use the _____ feature to apply formatting to data that meets a specific criterion.

A

conditional formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Clicking the Ascending button in the Sort & Filter group on the Home tab will sort data in a form as follows:

A

text in alphabetic order from A to Z, numbers from lowest to highest, and dates from earliest to latest.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the keyboard shortcut to display the Field List task pane?

A

Alt + F8

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The default sort order at the third Report Wizard dialog box is

A

ascending

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

To create a report with the Report button, begin by

A

clicking the table or query in the Navigation pane that will be the source of the report data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

When fields are specified for the mailing label at the third Label Wizard dialog box, the fields are

A

moved to the Prototype label box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What two list boxes appear in the first Report Wizard dialog box?

A

Available Fields and Selected Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following is not one of the steps in creating a report using the Report Wizard?

A

Click the table or query that will be the source of the report in the Navigation pane.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

At the second Report Wizard dialog box, the up- and down-pointing arrows are used to

A

change the priority of the selected field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which of the following is not one of the four views available for Access reports?

A

Datasheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Find specific data in a report with options

A

at the Find dialog box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is the purpose of grouping data in a report?

A

to make the report easy to understand

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Reports are generally designed

A

to answer specific questions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

To add an existing field to a form, display the form in _____ view and then click the Add Existing Fields button.

A

Layout

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Forms can be created using several methods but not by using the _____ button.

A

View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A form is useful for focusing on

A

a single record at a time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

When Access creates a form from a table, what does the second column of cells contain?

A

field values in text box control objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Which of the following correctly states how you can enter text in Layout view?

A

You can enter data in a label control object but not in a text box control object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

When you open a form in _____ view, the Form Layout Tools Design tab is active.

A

Layout

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

When a form is created with a table that has a one-to-many relationship with another table, what does Access do?

A

It adds a datasheet to the form that is based on

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What happens when you click the Date and Time button in the Header/Footer group on the Form Layout Tools Design tab?

A

The Date and Time dialog box displays.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Clicking the Split Form option at the More Forms button drop-down list creates

A

two views of the same form.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Which two buttons appear at the bottom of the Group, Sort, and Total pane?

A

Add a group and Add a sort

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

When a grouping level is added to a report, Access

A

automatically sorts that level in ascending order.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Options for inserting and selecting rows, splitting cells, moving data up and down, and controlling margins are available on the Report Layout Tools ribbon with the _____ tab selected.

A

Arrange

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Which of the following is not one of the options in the Text appearance section of the second Label Wizard dialog box?

A

Text direction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

To change the width of a control object in a report by dragging, begin by positioning the mouse pointer _____ of the object.

A

on a left or right border

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

The Report, Report Wizard, and Labels buttons are all located on the _____ tab.

A

Create

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

The options on the Report Layout Tools Format tab are the same as those on the _____ tab.

A

Form Layout Tools Format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

When creating a report using the Report Wizard, the first piece of information you must supply is

A

the name of the table or query that contains the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

If you insert a check mark in the Print Data Only check box in the Page Size group, the _____ will not print on the report.

A

report title and column headings

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

To print a specific record in a form, begin by selecting the record and then

A

displaying the Print dialog box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

If a form is created based on a table that has multiple one-to-many relationships, what will Access do?

A

It will not display any datasheets based on the related tables.

41
Q

How do you select all the objects in the Detail section of a form but not in the Form Header section?

A

Click an object in the Detail section and then click the table move handle.

42
Q

The Header/Footer group on the Form Layout Tools Design tab contains buttons for inserting each of the following except

A

a watermark

43
Q

If you delete a form from your computer’s hard drive, can the form be retrieved? If so, how?

A

Yes, the form can be retrieved from the Recycle Bin.

44
Q

Access offers a Form Wizard that provides _____ for creating a form.

A

steps

45
Q

To change the width of a control object by dragging, select the object and then _____ the object until the pointer displays as a left-and-right-pointing arrow.

A

position the mouse pointer on the left or right border of

46
Q

What happens when you position the mouse pointer over a theme at the Themes button drop-down gallery?

A

The live preview feature displays the form with the theme formatting applied.

47
Q

When navigating in a form, pressing the Page Down key will move

A

forward one record.

48
Q

When the Report Wizard is used to create a report with fields from more than one table, how is the process different from when the wizard is used to create a report from only one table?

A

A sixth Report Wizard dialog box presents options.

49
Q

Use _____ to display an Access report as it will appear when printed.

A

Print Preview

50
Q

Which of the following text appearance options cannot be changed at the second Label Wizard dialog box?

A

superscript

51
Q

What is the main reason for creating a report in a database?

A

to control what data appears on the page when printed

52
Q

Click the _____ button in the Sort & Filter group on the Home tab to sort text in alphabetical order from Z to A.

A

Descending

53
Q

What do you specify at the last Label Wizard dialog box?

A

a name for the label report

54
Q

Can a report be created from a query? If so, how?

A

Yes, in the same manner as creating a report from a table.

55
Q

When a control object in a report is selected, it displays with a(n) _____ border.

A

orange

56
Q

When a form is created with a table that has a one-to-many relationship, where does Access place the datasheet for the related table?

A

at the bottom of the form

57
Q

Delete a form by clicking the Delete button in the _____ group on the _____ tab.

A

Records; Home

58
Q

What will print when you click the Quick Print option?

A

all the records in a form

59
Q

By default, the _____ button in the Controls group on the Form Layout Tools Design tab is active.

A

Select

60
Q

A form is made up of cells arranged in rows and columns, and each cell can contain one

A

control object

61
Q

A _____ is an object used to enter and edit data in a table or query.

A

form

62
Q

Each cell in a form can contain _____ control object(s).

A

one

63
Q

To view and modify the structure of a form, use the _____ view.

A

Design

64
Q

The themes available in Access are _____ the themes available in Word, Excel, and PowerPoint.

A

the same as

65
Q

Use the _____ view to enter and manage records in a form.

A

Form

66
Q

Which of the following is not one of the layout options available at the second Form Wizard dialog box?

A

Split

67
Q

A report created with the Report button is displayed in _____ view.

A

Layout

68
Q

At the second Report Wizard dialog box, remove an option as a grouping level by selecting a specific field and then clicking the button with the _____-pointing arrow.

A

left

69
Q

In creating a report using the Report Wizard, which of the following steps is performed at the final dialog box?

A

Type a name for the report.

70
Q

What are the two options in the Label Type section of the first Label Wizard dialog box?

A

Sheet feed and Continuous

71
Q

Use the _____ button to increase or decrease spacing between cells.

A

Control Padding

72
Q

To select a row of cells in a form, _____ a cell and then click Select Entire Row at the shortcut menu.

A

right-click in

73
Q

When viewing a report in Print Preview, you can change the margins with the Margins button located in the _____ group.

A

Page Size

74
Q

What information are you asked to supply at the first Label Wizard dialog box?

A

the label size, type, and unit of measure

75
Q

Which of the following is not an option in the Layout section of the fourth Report Wizard dialog box?

A

Continuous

76
Q

When moving a column in a report by dragging, the mouse pointer should display with a(n) _____ attached.

A

four-headed arrow

77
Q

When a form is created using the Form button, it will open in _____ view.

A

Layout

78
Q

When you split a cell, a(n) _____ is created to the right of the control object.

A

empty cell

79
Q

The Record navigation bar displays when a form is open in which view(s)?

A

Form or Layout view

80
Q

How is a form created with the Multiple Items option from the More Forms button different from a form created with the Form button?

A

It displays multiple records.

81
Q

The Report Wizard is on the _____ tab.

A

Create

82
Q

To sort data in a report, you should first

A

click in the field containing the data to be sorted.

83
Q

To add a new record to a form, click the New (blank) record button, which is

A

on the Record Navigation bar.

84
Q

Where are the Ascending and Descending buttons?

A

in the Sort & Filter group on the Home tab

85
Q

You can use options in the Font group to do each of the following except

A

insert a background image.

86
Q

What happens when you click the Group & Sort button in the Grouping & Totals group on the Report Layout Tools Design tab?

A

The Group, Sort, and Total pane displays at the bottom of the work area.

87
Q

At the fourth Report Wizard dialog box, the default settings specify that the report will be printed in

A

portrait orientation with field widths adjusted so all the fields fit on a page.

88
Q

Use the _____ button in the Grouping & Totals group to perform calculations, such as finding the sum, average, maximum value, or minimum value of the numbers in a column.

A

Totals

89
Q

Use the _____ to insert fields from a table or query to a form.

A

Field List task pane

90
Q

When inserting a text box control object in a form, what do you do after clicking the Text Box button?

A

Click in the location in the form where the object should display.

91
Q

The Conditional Formatting button is in the _____ group on the _____ tab.

A

Control Formatting; Form Layout Tools Format

92
Q

Select all the control objects in a report by pressing Ctrl +

A

A

93
Q

Which of the following is not one of the steps in creating a report?

A

Click the Report Design button.

94
Q

When you create a split form, the two views are considered _____ because movements or changes made in one view will be reflected in the other view.

A

synchronous

95
Q

The control objects in the Detail section of a form in Layout view are contained in cells within

A

the form table.

96
Q

With your report in Layout view and no grouping levels added, what happens when you click the Add a sort button in the Group, Sort, and Total pane?

A

A sorting row is added to the pane and a list of available fields is displayed.

97
Q

The buttons on the Report Layout Tools Page Setup tab are also available

A

in Print Preview.

98
Q

How do you delete a grouping or sorting level in the Group, Sort, and Total pane?

A

Click the Delete button at the right side of the level row.

99
Q

Display a report in Print Preview by clicking the Print Preview button

A

(?)
NOT in the Title bar.

etm 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions