AL1 C5 C6

Question 1

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

Answer 1

Ctrl + End

Question 2

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.

Answer 2

Layout; Datasheet

Question 3

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

Answer 3

The Date and Time dialog box displays.

Question 4

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

Answer 4

Form Layout Tools Format tab

Question 5

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

Answer 5

the label control objects

Question 6

What are the two components of an Access theme?

Answer 6

a color theme and a font theme

Question 7

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

Answer 7

Forms; Create

Question 8

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

Answer 8

conditional formatting

Question 9

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

Answer 9

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

Question 10

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

Answer 10

Alt + F8

Question 11

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

Answer 11

ascending

Question 12

To create a report with the Report button, begin by

Answer 12

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

Question 13

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

Answer 13

moved to the Prototype label box.

Question 14

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

Answer 14

Available Fields and Selected Fields

Question 15

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

Answer 15

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

Question 16

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

Answer 16

change the priority of the selected field.

Question 17

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

Answer 17

Datasheet

Question 18

Find specific data in a report with options

Answer 18

at the Find dialog box.

Question 19

What is the purpose of grouping data in a report?

Answer 19

to make the report easy to understand

Question 20

Reports are generally designed

Answer 20

to answer specific questions.

Question 21

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

Answer 21

Layout

Question 22

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

Answer 22

View

Question 23

A form is useful for focusing on

Answer 23

a single record at a time.

Question 24

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

Answer 24

field values in text box control objects

Question 25

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

Answer 25

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

Question 26

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

Answer 26

Layout

Question 27

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

Answer 27

It adds a datasheet to the form that is based on

Question 28

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

Answer 28

The Date and Time dialog box displays.

Question 29

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

Answer 29

two views of the same form.

Question 30

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

Answer 30

Add a group and Add a sort

Question 31

When a grouping level is added to a report, Access

Answer 31

automatically sorts that level in ascending order.

Question 32

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.

Answer 32

Arrange

Question 33

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

Answer 33

Text direction

Question 34

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

Answer 34

on a left or right border

Question 35

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

Answer 35

Create

Question 36

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

Answer 36

Form Layout Tools Format

Question 37

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

Answer 37

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

Question 38

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.

Answer 38

report title and column headings

Question 39

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

Answer 39

displaying the Print dialog box.

Question 40

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

Answer 40

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

Question 41

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

Answer 41

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

Question 42

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

Answer 42

a watermark

Question 43

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

Answer 43

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

Question 44

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

Answer 44

steps

Question 45

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.

Answer 45

position the mouse pointer on the left or right border of

Question 46

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

Answer 46

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

Question 47

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

Answer 47

forward one record.

Question 48

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?

Answer 48

A sixth Report Wizard dialog box presents options.

Question 49

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

Answer 49

Print Preview

Question 50

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

Answer 50

superscript

Question 51

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

Answer 51

to control what data appears on the page when printed

Question 52

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

Answer 52

Descending

Question 53

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

Answer 53

a name for the label report

Question 54

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

Answer 54

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

Question 55

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

Answer 55

orange

Question 56

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?

Answer 56

at the bottom of the form

Question 57

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

Answer 57

Records; Home

Question 58

What will print when you click the Quick Print option?

Answer 58

all the records in a form

Question 59

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

Answer 59

Select

Question 60

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

Answer 60

control object

Question 61

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

Answer 61

form

Question 62

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

Answer 62

one

Question 63

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

Answer 63

Design

Question 64

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

Answer 64

the same as

Question 65

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

Answer 65

Form

Question 66

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

Answer 66

Split

Question 67

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

Answer 67

Layout

Question 68

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.

Answer 68

left

Question 69

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

Answer 69

Type a name for the report.

Question 70

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

Answer 70

Sheet feed and Continuous

Question 71

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

Answer 71

Control Padding

Question 72

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

Answer 72

right-click in

Question 73

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

Answer 73

Page Size

Question 74

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

Answer 74

the label size, type, and unit of measure

Question 75

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

Answer 75

Continuous

Question 76

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

Answer 76

four-headed arrow

Question 77

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

Answer 77

Layout

Question 78

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

Answer 78

empty cell

Question 79

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

Answer 79

Form or Layout view

Question 80

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

Answer 80

It displays multiple records.

Question 81

The Report Wizard is on the _____ tab.

Answer 81

Create

Question 82

To sort data in a report, you should first

Answer 82

click in the field containing the data to be sorted.

Question 83

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

Answer 83

on the Record Navigation bar.

Question 84

Where are the Ascending and Descending buttons?

Answer 84

in the Sort & Filter group on the Home tab

Question 85

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

Answer 85

insert a background image.

Question 86

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

Answer 86

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

Question 87

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

Answer 87

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

Question 88

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.

Answer 88

Totals

Question 89

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

Answer 89

Field List task pane

Question 90

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

Answer 90

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

Question 91

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

Answer 91

Control Formatting; Form Layout Tools Format

Question 92

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

Answer 92

A

Question 93

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

Answer 93

Click the Report Design button.

Question 94

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.

Answer 94

synchronous

Question 95

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

Answer 95

the form table.

Question 96

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?

Answer 96

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

Question 97

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

Answer 97

in Print Preview.

Question 98

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

Answer 98

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

Question 99

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

Answer 99

(?) NOT in the Title bar.