Deck 6: Managing Data With Data Tools

Question 1

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

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

Answer 1

D

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

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

Question 8

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 9

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

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

Question 10

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 11

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 12

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

Question 13

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 14

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

Question 15

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

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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 23

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 24

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 25

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 26

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 27

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 28

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 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

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 31

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 32

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

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

Question 33

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 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

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

Question 42

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 43

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 44

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 45

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

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

Question 46

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 47

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 48

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

Question 49

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

Question 50

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 51

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 52

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 53

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

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

Question 54

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 55

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 56

The keyboard shortcut for Undo is _____.

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

Question 57

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 58

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 59

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 60

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 61

Each item on a form is called a _____.

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

Question 62

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 63

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 64

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 65

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 66

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

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

Question 67

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 68

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 69

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 70

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 71

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 72

A report with _____ is a good candidate for a multicolumn report.

A) a header and a footer
B) many fields
C) wide margins
D) only a few fields

Question 73

In a multicolumn report,you can set the column layout as "Across,then Down" or as _____.

A) "Across,then Up"
B) "Down,then Up"
C) "Down,then Across"
D) "Left,then Right"

Question 74

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

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

Question 75

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

Question 76

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 77

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

Question 78

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 79

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

Question 80

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