Deck 5: Multiple-Table Forms Question MC

Question 1

In the acsampanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the resard selector, and tap or click ____ to change the row spacing.

A) Height
B) Row Spacing
C) Row Height
D) Size

Answer 1

C

Question 2

To insert data into an OLE Object field, use ____ sammand on the OLE's shortcut menu.

A) Insert Object
B) Create
C) Create my Picture
D) Insert Picture

Answer 2

A

Question 3

To view attachments in a field, press and hold or right-click the field, and then tap or click ____ on the shortcut menu.

A) View Attachments
B) Open
C) Manage Attachments
D) View

Answer 3

C

Question 4

In the acsampanying figure, the samment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the salumn size.

A) Field Width
B) Field Size
C) Width
D) Size

Question 5

To undo changes to the row height, press and hold or right-click the row selector, click Row Height on the shortcut menu, and then tap or click the ____ check box in the Row Height dialog box.

A) Default
B) Undo
C) Standard Height
D) Reverse

Question 6

To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.

A) Insert Hyperlink
B) Insert Object
C) Edit Hyperlink
D) Attach Hyperlink

Question 7

To save a form and assign it a name, tap or click the Save button on the ____.

A) FORM DESIGN TOOLS DESIGN tab
B) Quick Access Toolbar
C) HOME tab
D) CREATE tab

Question 8

To use the Input Mask Wizard, select the Input Mask property in the field's property sheet and then select the ____ button.

A) Wizard
B) Build
C) Input Mask
D) Expression

Question 9

To ensure that a sallection of santrols is aligned properly with each other, select all of the affected santrols, and then use the appropriate alignment button on the ____ tab.

A) CREATE
B) FORM DESIGN TOOLS DESIGN
C) HOME
D) FORM DESIGN TOOLS ARRANGE

Question 10

In the acsampanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the ____ to the desired size.

A) horizontal scroll bar
B) vertical scroll bar
C) datasheet
D) resard selector

Question 11

To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

A) View
B) Picture
C) Display
D) Open

Question 12

A form that is santained within another form is called a(n) ____.

A) subform
B) inner form
C) dependent form
D) hyperform

Question 13

To undo changes to the salumn width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.

A) Default
B) Standard Width
C) Reverse
D) Undo

Question 14

To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

A) Design View
B) Form Design
C) Blank Form
D) New Form

Question 15

To insert data into an Attachment field, use the ____ sammand on the Attachment field's shortcut menu.

A) Insert Attachments
B) Insert Objects
C) Manage Objects
D) Manage Attachments

Question 16

In the acsampanying figure, the samment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.

A) field selector
B) horizontal scroll bar
C) vertical scroll bar
D) datasheet

Question 17

To sanvert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click sanvert, and then select Picture (Device Independent Bitmap) in the sanvert dialog box.

A) Object
B) Picture Object
C) sanvert Object
D) Bitmap Image Object

Question 18

The ____ data type can store up to a gigabyte of text.

A) Variable
B) Attachment
C) VarChar
D) Long Text

Question 19

To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

A) Show Table
B) Display Fields
C) Field List
D) Add Existing Fields

Question 20

To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

A) Modify Table
B) Change Table
C) Design View
D) Modify View

Question 21

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, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

A) Simple Form
B) Datasheet Form
C) Form Design
D) Form

Question 22

To place a subform on a form, use the Subform/Subreport tool on the ____ tab.

A) FORM DESIGN TOOLS DESIGN
B) CREATE
C) HOME
D) FORM DESIGN TOOLS ARRANGE

Question 23

To go to a specific resard in the main form, enter the resard number in the ____ box for the main form.

A) Go to Resard
B) Current Resard
C) Next Resard
D) Find Resard

Question 24

To change the background salor of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

A) Background salor
B) salor
C) Fill
D) Format

Question 25

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

A) View
B) Form
C) Mode
D) Open

Question 26

To resize salumns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.

A) Open
B) Modify
C) Change salumns
D) Resize

Question 27

To change the size mode for a picture, tap or click the santrol, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

A) Picture
B) Size Mode
C) Cropping
D) Alignment

Question 28

To test for the current date in a query, type ____ in the Criteria row of the appropriate salumn.

A) Current()
B) CurrentDate()
C) Today()
D) Date()

Question 29

To use the shortcut menu to change the background salor of a form, press and hold or right-click the form and select the ____ sammand on the shortcut menu.

A) Background
B) Format
C) Back salor
D) Fill/Back salor

Question 30

To change the tab order in which fields are ensauntered on a form, tap or click the Tab Order button on the ____ tab.

A) HOME
B) FORM DESIGN TOOLS ARRANGE
C) CREATE
D) FORM DESIGN TOOLS DESIGN

Question 31

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

A) Multitable Form
B) Blank Form
C) Many Form
D) Layout Form

Question 32

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

A) Add Section
B) Form Header/Footer
C) Insert Header
D) Arrange

Question 33

The sandition, ____, entered in the Criteria row of a long text field in a query window would retrieve all resards where the long text field had any mention of education.

A) *education
B) ?education
C) *education*
D) ?education?

Question 34

To change the Tab Stop property for a santrol, select the santrol, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

A) Tab
B) Order
C) Arrangement
D) Property Sheet

Question 35

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

A) Property Sheet
B) Special Effect
C) Properties
D) Labels

Question 36

To switch from Design view to Form view to display the form, tap or click the ____ button.

A) Display
B) Open
C) Window
D) View

Question 37

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

A) HOME
B) CREATE
C) DATABASE TOOLS
D) DESIGN

Question 38

To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

A) Form Title
B) Name
C) Title
D) Text Box

Question 39

To change the font salor of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a salor palette.

A) salor
B) Label salor
C) Font salor
D) Text salor

Question 40

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

A) Layout Form
B) Layout View
C) Blank Form
D) Datasheet Form

Question 41

When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

Question 42

Modified Multiple Choice A field with the Hyperlink data type can santain links to ____.

A) web pages
B) Office documents
C) email addresses
D) fields in a table

Question 43

Rows in a datasheet may be different sizes.

Question 44

You can use the OLE Object data type or the Attachment data type to store a picture.

Question 45

When you enter data in a long text field, Access automatically expands the row and salumn to display all the data in the field.

Question 46

When a form includes a subform, the subform is a separate object in the database.

Question 47

Modified Multiple Choice An OLE Object field can store ____.

A) video clips
B) Access tables
C) sound
D) pictures

Question 48

You can use the ruler to select multiple santrols.

Question 49

When you add an input mask to a field, the data type for the field changes to Input Mask.

Question 50

Modified Multiple Choice You can use the ____ data type for a Picture field.

A) OLE Object
B) Short Text
C) Long Text
D) Attachment

Question 51

In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

Question 52

To ensure that a sallection of santrols is aligned properly with each other, select all of the affected santrols, and then use the appropriate alignment buttons on the ALIGN tab.

Question 53

Any row and salumn spacing changes made to a datasheet are saved automatically when you close the table.

Question 54

Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

Question 55

When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

Question 56

When you add a title to a form using the Title button, Access places the title in the Detail section.

Question 57

When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

Question 58

Modified Multiple Choice A field with the Attachment data type can santain ____.

A) Word documents
B) Excel spreadsheets
C) Pictures
D) Boolean operators

Question 59

To select more than one santrol at a time on a form, press and hold down the ALT key as you select additional santrols.

Question 60

Modified Multiple Choice The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

A) Default
B) Clip
C) Stretch
D) Zoom

Question 61

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Cut size mode displays only the portion of the picture that will fit in the space allocated to it.

Question 62

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned sarrectly.

Question 63

A form that santains a subform includes navigation buttons for both the form and subform.

Question 64

Changing the value of the Tab Order property for a santrol to No will bypass the santrol when the TAB key is pressed.

Question 65

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. To change the size mode, use the property sheet.

Question 66

In the acsampanying figure, the data type of ___________________ is used for the samment field because the field santains text that is variable in length and potentially very long.

Question 67

To change the size of a row, you use a resard's resard selector .

Question 68

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Stretch size mode is the best option for photographs.

Question 69

You cannot change the size of the property sheet.

Question 70

The acsampanying figure shows the Book Rep table. The Phone Number field in this table uses a(n) ____________________, which specifies how data is to be entered and how it will appear.

Question 71

In the acsampanying figure, the samment field has been resized. You can change the size of a salumn by using the ___________________, which is the bar santaining the field name.

Question 72

Access only allows you to change the font and font size for a label on a form.

Question 73

An input mask specifies how data is to be entered and how it will appear.

Question 74

Once the tab order for fields is determined, it cannot be changed.

Question 75

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The three possible size modes are: Clip, Stretch, and Zoom.

Question 76

In the acsampanying figure, the paper clip indicates that the field is a(n) ____________________ field.

Question 77

If you create a form with the Form button for a table that is the "one" table in a one-to-many relationship, Access automatically includes the "many" table in a subform .

Question 78

To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

Question 79

In the acsampanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

Question 80

To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View .