Deck 6: Managing Data With Data Tools

Question 1

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

A) Control
B) Form
C) Button
D) Field

Answer 1

A

Question 2

A(n) _____ is a common control to place within an option group.

A) option button
B) text box
C) command button
D) toggle button

Answer 2

A

Question 3

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

Answer 3

False - label
False - Label
False - LABEL

Question 4

When you add a field to a form in Form Layout view, Access creates a text box but not a label.

Question 5

The _____ determines the underlying table or query for a form.

A) record source
B) Attachment property
C) combo box
D) Enabled property

Question 6

You can add a line to a report to indicate a subtotal.

Question 7

A combo box is a combination of a text box and command button.

Question 8

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

Question 9

To add a subform to a form in Form Design view, you use the Subform/Subreport control.

Question 10

A(n) _____ is an image that fills the entire form, appearing "behind" the other controls.

A) logo
B) icon
C) background image
D) control image

Question 11

One way to group objects in the Navigation Pane is by object type.

Question 12

To run a macro from a form, add a check box control to the form.

Question 13

Which of the following controls would you use to display a Yes/No field on a form?

A) combo box
B) command button
C) check box
D) label

Question 14

To right-align the text in a text box, you use the Align Right button on the Home tab.

Question 15

You can select one or more option buttons at the same time within an option group.

Question 16

In a calculated control, expressions must start with what character?

A) : colon
B) [ left square bracket
C) ( left parenthesis
D) '= equal sign

Question 17

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

Question 18

Which control allows you to type an entry or choose an entry from a list?

A) combo box
B) list box
C) label
D) text box

Question 19

To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.

A) Home
B) Form Design Tools Design
C) Form Design Tools Format
D) Form Design Tools Arrange

Question 20

A check box control usually displays a "yes" or "no" answer for a field.

Question 21

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

A) another form
B) a list of values that you enter
C) a different table
D) a spreadsheet

Question 22

Access creates fields with _____ properties as combo boxes on new forms.

A) Scroll Bar
B) Control Box
C) List
D) Lookup

Question 23

Which of the following form controls would you use to display a border around other controls?

A) box
B) rectangle
C) tab control
D) label

Question 24

Which of the following are actions you can set for a command button when you use the Command Button Wizard? Select all the options that apply.

A) Add new record
B) Print record
C) Save record
D) Format record

Question 25

Which control works best to display three choices-1, 2, or 3-for a Rating field?

A) toggle button
B) text box
C) tab control
D) option group

Question 26

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

A) check box
B) option button
C) command button
D) option group

Question 27

To add a background image to a report in Report Layout view, you use the _____ button.

A) Insert Image
B) Logo
C) Insert Picture
D) Background Image

Question 28

If you create a blank form, you must set the _____ property to display data on the form.

A) Control Data
B) Record Source
C) Row Values
D) Hyperlink Address

Question 29

To close a report in Report Design view while keeping the database open, you _____.

A) click the Close button on the Page Setup tab
B) click the Close button on the Access title bar
C) right-click the report tab and then click Close
D) right-click the status bar and then click Close

Question 30

Where does a background image appear in a report?

A) behind the other controls
B) in front of the other controls
C) to the right of the other controls
D) to the left of the other controls

Question 31

Which of the following controls would you add to a form to print the current record?

A) toggle button
B) command button
C) check box
D) option button

Question 32

To set a command button to be a hyperlink in Form Design view, you change the button's _____ property.

A) On Click
B) Web Link
C) Hyperlink Address
D) Enabled

Question 33

A _____ allows you to work with records related to the record in the main form.

A) subform
B) hyperlink
C) background form
D) related form

Question 34

Which of the following are controls you can add to a form in Form Layout view? Select all the options that apply.

A) toolbar
B) text box
C) combo box
D) label

Question 35

Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.

A) Theme
B) Created Date
C) Object Type
D) Tables and Related Views

Question 36

If you change data in its original location and it is linked to an Access database, you must also update the data in the Access database.

Question 37

What could you use to display the amount of a 25% discount on a form?

A) a Total row
B) a command button
C) a calculated control
D) a logo

Question 38

To have form users select one of three options, add a(n) _____ to the form.

A) text box
B) toggle button
C) option group
D) tab control

Question 39

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _____.

A) retrieve the values from a website
B) set the combo box to list random values
C) enter the values for the combo box
D) retrieve the values from a report

Question 40

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

A) Insert Image
B) Logo
C) Online Pictures
D) Background Image

Question 41

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

A) Spreadsheet
B) Tabular
C) Layout
D) Group

Question 42

What do you change when you drag the right border of a form in Form Design view?

A) the width of all the form controls
B) the margins of the form
C) the layout of the form
D) the width of the form

Question 43

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

A) tab order
B) sort order
C) focus grouping
D) form layout

Question 44

Which of the following form controls can you format by applying a style to it?

A) label
B) image
C) button
D) text box

Question 45

The lower pane of a split form displays a(n) datasheet view.

Question 46

Which of the following options for creating a form can you access on the Create tab? Select all the options that apply.

A) Form Design
B) Switchboard Form
C) Split Form
D) Form Wizard

Question 47

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

Question 48

Which of the following controls can you add to a form to clarify or organize form data? Select all the options that apply.

A) line
B) text box
C) rectangle
D) label

Question 49

If you _____ in the Form Wizard, you can create a form with a subform.

A) select fields from a single table
B) select fields from related tables
C) sort the records based on more than one field
D) select the tabular form layout

Question 50

Tab order refers to the order you added tabbed pages to a tab control.

Question 51

Which of the following options can you set for a text box in a control layout? Select all the options that apply.

A) Margins
B) Padding
C) Anchoring
D) Page numbering

Question 52

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

A) Picture
B) Logo
C) Graphics
D) Image

Question 53

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

A) report
B) control layout
C) theme
D) form

Question 54

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

A) Top/Left
B) Detail
C) Custom Order
D) Auto Order

Question 55

A form ____ is the general way that the data and controls are arranged on the form.

A) group
B) control
C) layout
D) view

Question 56

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

A) navigation form
B) tab control
C) subform
D) split form

Question 57

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

Question 58

Which of the following layouts can you use to arrange form controls?

A) circular
B) stacked
C) horizontal
D) padded

Question 59

_____ means to connect data in an external file to an Access database.

A) Linking
B) Exporting
C) Encrypting
D) Merging

Question 60

Which of the following is a valid entry for the Tab Stop property of a form control?

A) 1
B) First
C) Auto
D) Yes

Question 61

To change the column layout in a report in Report Design view, you use the _____.

A) clicking the Stacked button on the Arrange tab
B) clicking the Control Margins button on the Arrange tab
C) dragging it to a blank area of the report
D) clicking the Remove Layout button on the Arrange tab

Question 62

Each item on a form is called a _____.

A) property
B) layout
C) control
D) text box

Question 63

If you move a text box in Form Design view, you _____.+

A) move the other text boxes in the column
B) move the label associated with that text box
C) must reset the margins of the form
D) change the tab order of the text box

Question 64

How do you select a row in a control layout in Report Layout view?

A) Click the row selector.
B) Click to the left of the row.
C) Drag to select the controls in the row.
D) Press and hold the SHIFT key, and then click a control in the row.

Question 65

A control layout in an Access report is a ____.

A) sorted group of records under a group header
B) group of controls formatted the same way
C) template you attach to a report
D) connected set of report controls

Question 66

The keyboard shortcut for Undo is _____.

A) CTRL+Y
B) CTRL+U
C) CTRL+W
D) CTRL+Z

Question 67

To select more than one control in Form Design view, you _____ and then click each control.

A) press and hold the ALT key
B) press the ENTER key
C) press the INSERT key
D) press and hold the SHIFT key

Question 68

When you select a control in Form Design view and then press an arrow key, you _____ the control.

A) resize
B) anchor
C) move
D) lock

Question 69

To resize the form header in Form Layout view, you use the _____ property.

A) Visible
B) Height
C) Special Effect
D) Keep Together

Question 70

In _____ view, you can make some design changes to a report while you are displaying the data.

A) Layout
B) Design
C) Report
D) Blank Report

Question 71

How can you change the shape of a button from a rounded rectangle to an oval?

A) Drag the edges of the button in Form Design view.
B) Apply a style to the button.
C) Use the Change Shape button.
D) Use the Alternate Outline button.

Question 72

In Table Datasheet view, you can press CTRL+A to select all the table's records.

Question 73

To repeat an action in Design view or Layout view, use the _____ button.

A) Repeat
B) Redo
C) Undo
D) Copy

Question 74

You can use the arrow keys to move a selected control in Report Design view.

Question 75

When you click the first value in a column in Report Layout view, what are you actually selecting? ​

A) the control containing the value
B) the label displaying the column heading
C) the record containing the value
D) the column for the underlying table

Question 76

How can you select more than one control at a time in Form Design view? Select all the options that apply.

A) Drag a selection box around the controls.
B) Click the ruler above or to the left of the controls.
C) Click a control then SHIFT+click other controls.
D) Right-drag the controls.

Question 77

Where do you specify the number of columns for a report?

A) Print Preview toolbar
B) Form Design property sheet
C) Page Setup dialog box
D) Page Layout tab

Question 78

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

A) clicking the Stacked button on the Arrange tab
B) clicking the Control Margins button on the Arrange tab
C) dragging it to a blank area of the report
D) clicking the Remove Layout button on the Arrange tab

Question 79

Press CTRL+S to select all the records in Table Datasheet view.

Question 80

To reverse the last action you took in a database, click the _____ button.

A) Reverse
B) Toggle
C) Redo
D) Undo