Deck 9: Using Advanced Form Features

Question 1

Tab order refers to the order in which you move between the ____ in a form.

A) records
B) subforms
C) tabs
D) fields

Answer 1

D

Question 2

If you add a new field between two existing fields, Access recognizes the new field and places it as the last tab stop in the form.

Answer 2

True

Question 3

Themes add borders and colors to forms.

Answer 3

True

Question 4

Aligning controls in a form is a complicated process.

Question 5

Most people use tables to enter and retrieve data.

Question 6

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

Question 7

A form field has three parts.

Question 8

Case AC 9-1 Sandy is the owner of a bakery specializing in healthy baked goods. As a new service for her customers, Sandy has decided to provide a public, interactive customer kiosk within her store that will allow all customers to gain information about her products. Sandy will use an Access database and present various forms on the kiosk window from which customers can select information. Due to your extensive knowledge in Access database form creation, Sandy has asked for your help in developing the forms. If all the forms in Sandy's database share the same ____, her customers will have an easier time using the forms.

A) font
B) font size
C) title
D) design

Question 9

Case AC 9-1 Sandy is the owner of a bakery specializing in healthy baked goods. As a new service for her customers, Sandy has decided to provide a public, interactive customer kiosk within her store that will allow all customers to gain information about her products. Sandy will use an Access database and present various forms on the kiosk window from which customers can select information. Due to your extensive knowledge in Access database form creation, Sandy has asked for your help in developing the forms. As you begin designing Sandy's kiosk forms, what is an initial design feature to consider before deciding on a theme?

A) field organization
B) error prevention
C) form layout
D) all of the above

Question 10

If the values in the fields are changed, the calculated control recalculates and displays the new values.

Question 11

Record operation options let you add a command button with a task.

Question 12

If you make a change to a theme, all of the forms in the database will be updated with the new appearance.

Question 13

Themes are available in the Features gallery on the Ribbon.

Question 14

You can use a combo wizard to add a combo box to a form.

Question 15

A consistent design can be created with the use of properties .

Question 16

Pressing the right arrow key moves you from one field to another in a form.

Question 17

Record navigation refers to moving within the records in a form.

Question 18

Consistency in form design will ____.

A) reduce the chance of errors
B) increase data accuracy
C) simplify the data entry
D) all of the above

Question 19

A ____ can be clicked to move within a form.

A) calculated control button
B) command button
C) control button
D) command tab

Question 20

A(n) combo box makes it easy to add information into a new record.

Question 21

The Property Sheet ____ displays all of the properties for a selected object.

A) field
B) window
C) link
D) pane

Question 22

A ____ can be used to perform calculations on the values in other fields.

A) link
B) combo box
C) tab
D) calculated control

Question 23

A logo is automatically placed in the ____.

A) lower-left corner
B) upper-left corner
C) upper-right corner
D) lower-right corner

Question 24

____________________ are preset designs that include borders, background colors, shading, and graphic effects.

Question 25

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

A) increase the accuracy of the information
B) increase security
C) increase color combination brightness
D) can link to other subforms for more options

Question 26

When resizing a logo, you place the mouse pointer over the lower-right corner of the logo and then when the mouse pointer becomes a ____ arrow, click and drag down and to the right to increase the size of the logo.

A) double-sided horizontal
B) four-sided horizontal
C) double-sided diagonal
D) four-sided diagonal

Question 27

____ add efficiency to the data entry process.

A) Control boxes
B) Colors
C) Combo boxes
D) Calculated controls

Question 28

FIGURE AC 9-12 In Figure AC 9-12 above, Item 1 points to ____.

A) Record Navigation options
B) Field Navigation options
C) Tab Navigation options
D) Form Navigation options

Question 29

____ buttons aid in record navigation and record operation.

A) Control
B) Combo
C) Command
D) Calculate

Question 30

If you want to hide the dots and gridlines on your form in Design view, ____-click in the section where they are, and then click Grid from the shortcut menu.

A) left
B) right
C) double
D) triple

Question 31

A ____ can add consistency to a form.

A) logo
B) control box
C) command button
D) calculated control

Question 32

One way to make forms easier to use is to ____.

A) use lots of colors
B) use only black and white colors
C) include command buttons
D) include many graphics and icons

Question 33

With a combo box, you simply click the combo box ____ and select an option from the list.

A) arrow
B) button
C) number
D) field

Question 34

The tab order can be changed in Design view by selecting the ____ button in the Tools group of the Design tab.

A) Change Order
B) Tab Order
C) Reorder
D) Reset

Question 35

FIGURE AC 9-12 In Figure AC 9-12 above, the ____ wizard is displaying.

A) Command
B) Command Button
C) Control
D) Control Button

Question 36

When moving a logo, you select it, place the mouse pointer over the logo and when you see the pointer change to a(n) ____-headed arrow, press and hold the mouse button, then drag it.

A) one
B) two
C) three
D) four

Question 37

Case AC 9-2 The Phantastic Photo Human Resources department requested an easier, consistent way to enter new employee data. The AAA Database Design consulting firm was hired to provide a new system based on Access database forms. The AAA team provided a prototype of the system, and then handed it back to Phantastic Photo to finish themselves. A consistent place for the logo still needs to be determined. A ____ border appearing next to the logo is preventing it from being resized.

A) dashed
B) dotted
C) solid
D) thick

Question 38

Even though Access offers its own navigation buttons in the document window, ____ buttons make navigating easier.

A) control
B) combo
C) command
D) calculate

Question 39

Case AC 9-2 The Phantastic Photo Human Resources department requested an easier, consistent way to enter new employee data. The AAA Database Design consulting firm was hired to provide a new system based on Access database forms. The AAA team provided a prototype of the system, and then handed it back to Phantastic Photo to finish themselves. A consistent place for the logo still needs to be determined. To delete the border around the small logo, you select it and press the ____.

A) CTRL and the Delete keys
B) SHIFT and Delete keys
C) Delete key
D) ALT and Delete keys

Question 40

Going to the next record or to the previous record is an example of ____.

A) record navigation
B) record operation
C) form navigation
D) form operation

Question 42

Discuss how to size and align a control.

Question 43

A(n) ____________________ is a graphic or picture that can be placed in a form.

Question 44

A(n) ____________________ button is a button that users can click to perform common tasks.

Question 45

The feature that allows you to see how your form would look with a theme applied is called ____________________.

Question 46

A(n) ____________________ displays a list of values and lets you select one from the list.