True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A hyperlink field can contain only links to Web pages.
|
|
|
2.
|
You can use the OLE Object data type or the Attachment data type to store a
picture.
|
|
|
3.
|
In Datasheet view, an Attachment field appears as a paper clip rather than the
field name.
|
|
|
4.
|
When entering data in a field that has an input mask, Access will insert the
appropriate special characters in the proper positions.
|
|
|
5.
|
When you enter data in a memo field, Access automatically expands the row and
column to display all the data in the field.
|
|
|
6.
|
Rows in a datasheet may be different sizes.
|
|
|
7.
|
Only pictures that have been created in Microsoft Drawing can be inserted into
OLE fields in Access.
|
|
|
8.
|
Any row and column spacing changes made to a datasheet are saved automatically
when you close the table.
|
|
|
9.
|
When data, such as a picture, is inserted into an OLE field, Access does not
immediately display the picture.
|
|
|
10.
|
To select more than one control at a time on a form, press and hold down the ALT
key as you select additional controls.
|
|
|
11.
|
Access only allows you to change the font and font size for a label on a
form.
|
|
|
12.
|
You cannot change the size of the property sheet.
|
|
|
13.
|
Once the tab order for fields is determined, it cannot be changed.
|
|
|
14.
|
A form that contains a subform includes navigation buttons for both the form and
subform.
|
|
|
15.
|
To move from the last field in the main form to the first field in the subform,
press the CTRL+SHIFT+TAB keys.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
16.
|
The _____ data type is used for a field that contains text that is variable in
length and that can potentially be very lengthy.
a. | Variable | c. | VarChar | b. | Attachment | d. | Memo |
|
|
|
17.
|
If a Security Warning appears when you open a database, click the ____ button to
display the Microsoft Office Security Options dialog box.
a. | Customize | c. | Security | b. | Options | d. | Warning |
|
|
|
18.
|
To use the Input Mask Wizard, select the Input Mask property and then select the
_____ button.
a. | Wizard | c. | Input Mask | b. | Build | d. | Expression |
|
|
|
19.
|
To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap),
right-click the field, click _____, click Convert, and then double-click Picture.
a. | Object | c. | Convert Object | b. | Picture Object | d. | Bitmap Image
Object |
|
|
|
20.
|
To insert data into an Attachment field, use the _____ on the Attachment’s
field’s shortcut menu.
a. | Insert Attachments | c. | Manage Objects | b. | Insert Objects | d. | Manage
Attachments |
|
|
|
21.
|
To enter data into a Hyperlink field, right-click the Hyperlink field, click
Hyperlink on the shortcut menu, and then click _____ on the Hyperlink submenu.
a. | Insert Hyperlink | c. | Edit Hyperlink | b. | Inset Object | d. | Attach
Hyperlink |
|
|
|
22.
|
To undo changes to the row height, right-click the row selector, click Row
Height on the shortcut menu, and then click the _____ check box in the Row Height dialog box.
a. | Default | c. | Standard Height | b. | Undo | d. | Reverse |
|
|
|
23.
|
To undo changes to the column width, right-click the field selector, click
Column Width on the shortcut menu, and then click the _____ check box in the Column Width dialog
box.
a. | Default | c. | Reverse | b. | Standard Width | d. | Undo |
|
|
|
24.
|
To view attachments in a field, right-click the field, and then click _____ on
the shortcut menu.
a. | View Attachments | c. | Manage Attachments | b. | Open | d. | View |
|
|
|
25.
|
A form that is contained with another form is called a(n) _____.
a. | subform | c. | dependent form | b. | inner form | d. | hyperform |
|
|
|
26.
|
To create a form in Design view, select the table for the form, click Create on
the Ribbon, and then click _____ on the Create tab.
a. | Design View | c. | Blank Form | b. | Form Design | d. | New Form |
|
|
|
27.
|
To display a field list, click the ____ button on the Design tab.
a. | Show Table | c. | Field List | b. | Display Fields | d. | Add Existing
Fields |
|
|
|
28.
|
To ensure that a collection of controls is aligned properly with each other,
select all of the affected controls, and then use the appropriate alignment button on the _____
tab.
a. | Create | c. | Home | b. | Design | d. | Arrange |
|
|
|
29.
|
To change the background color of a form, you can use the _____ button on the
Design tab.
a. | Background | c. | Fill/Back Color | b. | Back Color | d. | Format |
|
|
|
30.
|
To use the shortcut menu to change the background color of a form, right-click
the form and select the _____ command on the shortcut menu.
a. | Background | c. | Back Color | b. | Format | d. | Fill/Back Color |
|
|
|
31.
|
To add a title to a form, click the _____ button on the Design tab.
a. | Form Title | c. | Title | b. | Name | d. | Text Box |
|
|
|
32.
|
To place a subform on a form, use the Subform/Subreport tool on the _____
tab.
a. | Design | c. | Home | b. | Create | d. | Arrange |
|
|
|
33.
|
To resize columns in a subform, right-click the subform in the Navigation Pane,
and click ____ on the shortcut menu.
a. | Open | c. | Change Columns | b. | Modify | d. | Resize |
|
|
|
34.
|
To switch from Design view to Form view to display the form, click the _____
button.
a. | Display | c. | Window | b. | Open | d. | View |
|
|
|
35.
|
To change the size mode for a picture, click the control, click the Property
Sheet button on the Design tab, and then click the _____ property box.
a. | Picture | c. | Cropping | b. | Size Mode | d. | Alignment |
|
|
|
36.
|
To change the font color of a label, select the label, and click the _____ arrow
on the Design tab to display a color palette.
a. | Color | c. | Font Color | b. | Label Color | d. | Text Color |
|
|
|
37.
|
To change the Tab Stop property for a control, select the control, click the
_____ button on the Design tab, and change the value of the Tab Stop property from Yes to No.
a. | Tab | c. | Arrangement | b. | Order | d. | Property Sheet |
|
|
|
38.
|
To change the tab order in which fields are encountered on a form, click the Tab
Order button on the _____ tab.
a. | Home | c. | Create | b. | Arrange | d. | Design |
|
|
|
39.
|
To display an attachment, right-click the Attachments field, and click the _____
command on the shortcut menu.
a. | Open Attachments | c. | Display Attachments | b. | Manage Attachments | d. | Edit
Attachments |
|
|
|
40.
|
To view object dependencies, click the object of interest in the Navigation
Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.
a. | Home | c. | Database Tools | b. | Create | d. | Design |
|
|
|
41.
|
To create a simple form with a datasheet, select the table that is the
“one” part of a one-to-many relationship in the Navigation Pane, click Create on the
Ribbon, and then click the ____ button on the Create tab.
a. | Simple Form | c. | Form Design | b. | Datasheet Form | d. | Form |
|
|
|
42.
|
The condition, _____, entered in the Criteria row of a memo field on a query
window would retrieve all records where the memo field had any mention of Healthcare
Management.
a. | *Healthcare Management | c. | *Healthcare Management* | b. | ?Healthcare
Management | d. | ?Healthcare
Management? |
|
Completion
Complete each
statement.
|
|
|
43.
|
To insert data into an OLE field, you use the ____________________ command on
the OLE field’s shortcut menu.
|
|
|
44.
|
To insert data into an Attachment field, use the ____________________ command on
the Attachment field’s shortcut menu.
|
|
|
45.
|
To insert data into a Hyperlink field, use the ____________________ command on
the Hyperlink field’s shortcut menu.
|
|
|
46.
|
If one recruiter services many clients, the relationship between clients and
recruiters is called a(n) ____________________ relationship.
|
|
|
47.
|
The form in which the subform is contained is called the
____________________.
|
|
|
48.
|
To add a title to a form, click the ____________________ button on the Design
tab.
|
|
|
49.
|
The best size mode to use for photographs is ____________________ size
mode.
|
|
|
50.
|
To give a label an etched appearance, change the ________________________
property for the label.
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | Form | f. | Object Dependencies | b. | CTRL+TAB | g. | TAB | c. | Add Existing
Fields | h. | Property
Sheet | d. | SHIFT | i. | CTRL+SHIFT+TAB | e. | INSERT | j. | Form Design |
|
|
|
51.
|
Key or key combination that will insert a blank row in a table.
|
|
|
52.
|
Button on the Create tab that creates a simple form with a datasheet.
|
|
|
53.
|
Key or key combination that will select multiple controls.
|
|
|
54.
|
Button on the Database Tools tab that will display dependencies between
database objects.
|
|
|
55.
|
Key or key combination that will move from the last field in the main form to
the first field in the subform.
|
|
|
56.
|
Button on the Design tab that displays a field list.
|
|
|
57.
|
Button on the Design tab that allows you to change the special effect for a
label.
|
|
|
58.
|
Key or key combination that will move from the subform back to the last field
in the main form.
|
|
|
59.
|
Button on the Create tab that creates a new form in Design view.
|
|
|
60.
|
Key or key combination that will move from the last field in the subform to the
first field in the next record’s main form.
|