Deck 6: Multitable Forms

Question 1

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
B) Form Design
C) Blank Form
D) New Form

Answer 1

B

Question 2

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

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

Answer 2

D

Question 3

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
B) Undo
C) Standard Height
D) Reverse

Answer 3

C

Question 4

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

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

Question 5

To save a form and assign it a name, click the Save button on the _____.

A) Design tab
B) Quick Access Toolbar
C) Home tab
D) Create tab

Question 6

In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, right-click the record selector, and click _____ to change the row spacing.

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

Question 7

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, right-click the field selector, and click _____ to change the column size.

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

Question 8

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
B) Insert Object
C) Edit Hyperlink
D) Attach Hyperlink

Question 9

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 10

To view attachments in a field, right-click the field, and then click _____ on the shortcut menu.

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

Question 11

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
B) Attachment
C) VarChar
D) Memo

Question 12

A form that is contained within another form is called a(n) _____.

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

Question 13

In the accompanying figure, the Comment 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 14

To enter a picture stored on a USB drive into an OLE field, right-click the OLE field, click Insert Object and then click the _____ option button.

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

Question 15

To modify the design of a table, 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 16

In the accompanying 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) record selector

Question 17

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
B) Design
C) Home
D) Arrange

Question 18

To undo changes to the column width, right-click the field selector, click Field Width on the shortcut menu, and then click the _____ check box in the dialog box.

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

Question 19

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

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

Question 20

To display a field list in Design view, click the ____ button on the Design tab.

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

Question 21

To add a Form Header section to a form, right-click anywhere on the form background and click _____ on the shortcut menu.

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

Question 22

To change the background color of a form, you can use the _____ button on the Design tab.

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

Question 23

To resize columns in a subform, right-click the subform in the Navigation Pane, and click ____ on the shortcut menu.

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

Question 24

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
B) Format
C) Back Color
D) Fill/Back Color

Question 25

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

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

Question 26

To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu.

A) Open Attachments
B) Manage Attachments
C) Display Attachments
D) Edit Attachments

Question 27

To change the special effect of a label, select the label, click the _____ button on the Design tab, and then click the Special Effect property box arrow.

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

Question 28

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
B) Datasheet Form
C) Form Design
D) Form

Question 29

To switch from Design view to Form view to display the form, click the _____ button.

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

Question 30

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

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

Question 31

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

A) Design
B) Create
C) Home
D) Arrange

Question 32

To create a multitable form based on the "many" table, 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 33

The condition, _____, entered in the Criteria row of a memo field in a query window would retrieve all records where the memo field had any mention of Information.

A) *Information
B) ?Information
C) *Information*
D) ?Information?

Question 34

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
B) Size Mode
C) Cropping
D) Alignment

Question 35

To change the tab order in which fields are encountered on a form, click the Tab Order button on the _____ tab.

A) Home
B) Arrange
C) Create
D) Design

Question 36

To change the font color of a label, select the label, and click the _____ arrow on the Format tab to display a color palette.

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

Question 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
B) Order
C) Arrangement
D) Property Sheet

Question 38

To add a title to a form, click the _____ button on the Design tab.

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

Question 39

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
B) Create
C) Database Tools
D) Design

Question 40

To create a form with a datasheet in Layout view, 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

Modified Multiple Choice A field with the Hyperlink data type can contain links to _____.

A) Web pages
B) Access queries
C) Office documents
D) Access tables

Question 42

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

Question 43

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

Question 44

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

Question 45

A hyperlink field can contain only links to Web pages.

Question 46

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

A) OLE
B) Text
C) Memo
D) Attachment

Question 47

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

Question 48

Modified Multiple Choice A Yes/No data type is appropriate if the only possible values are _____.

A) Yes or No
B) True or False
C) Right or Left
D) On or Off

Question 49

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

Question 50

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 51

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

Question 52

Rows in a datasheet may be different sizes.

Question 53

You can use the ruler to select multiple controls.

Question 54

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

Question 55

When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field.

Question 56

Modified Multiple Choice A field with the Attachment data type can contain _____.

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

Question 57

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

Question 58

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

Question 59

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 buttons on the Align tab.

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

Figure 5-3 In the accompanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

Question 62

Figure 5-3 In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________ which is the bar containing the field name.

Question 63

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

Question 64

Figure 5-3 In the accompanying figure, the paper clip indicates that the field is a(n) ____________________ field.

Question 65

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

Question 66

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 67

In the accompanying 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 correctly.

Question 68

In the accompanying 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 69

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

Question 70

In the accompanying 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 71

In the accompanying 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 72

You cannot change the size of the property sheet.

Question 73

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

Question 74

In the accompanying 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 75

Figure 5-3 In the accompanying figure, the data type of ___________________ is used for the Comment field because the field can contain text that is variable in length.

Question 76

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

Question 77

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

Question 78

To change the size of a row, you use a record's record selector , which is the small box at the beginning of each record.

Question 79

Figure 5-3 The accompanying figure shows the Business Analyst 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 80

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