Question 1

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?
A) Design
B) Layout
C) Form
D) Report

Accepted Answer

When editing a subform, it is better to use the layout view because it allows you to see how the data appears in the subform while still being able to make changes to the design. The design view is better suited for making structural changes to the subform, while the form and report views are not as useful for editing the subform. The Layout view allows you to see the subform with the actual data displayed, making it easier to make edits and adjustments to the layout. The Design view shows the structure of the subform, but not the actual data.

Question 2

How does a Combo Box control appear to a user?
A) Menu of options
B) Option button
C) Check Box
D) Legacy control

Accepted Answer

A Combo Box control appears to a user as a menu of options where they can select one option from a drop-down list. A Combo Box control appears to a user as a menu of options that can be selected from a drop-down list. This allows the user to select a single option from a predefined set of options.

Question 3

What is one way the user can tell that new records cannot be created in a form?
A) The New command is grayed out.
B) The New command is removed.
C) The New command has a line through it.
D) There is no way to tell that new records cannot be created.

Accepted Answer

When the New command is grayed out, it indicates that new records cannot be created in the form. This is a common way to disable the option, as it is noticeable and communicates the limitation clearly to the user. When the New command is grayed out, it indicates that the option for creating new records is not currently available. This is a clear visual cue to the user that they cannot create new records in the form.

Question 4

What is one way the user can tell that records cannot be deleted in a form?
A) The Delete command is not visible.
B) The Delete command has a line through it.
C) The Delete command is grayed out.
D) There is no way to tell if records cannot be deleted.

Accepted Answer

When the Delete command is grayed out, it usually indicates that the user does not have permission to delete records or that the form is set to read-only mode. Therefore, the user cannot delete records in the form. When the Delete command is grayed out, it usually means that the user does not have permission to delete records or the record is necessary for the functionality of the form. The other options (A, B, and D) could also potentially indicate that records cannot be deleted, but they are not definitive indicators.

Question 5

What key is often used in a form to advance from one field to another?
A) Right Arrow key
B) Shift Tab
C) Space bar
D) Tab

Accepted Answer

The Tab key is often used in a form to advance from one field to another. It is the standard input navigation key used in most operating systems and applications. Shift Tab is also a common shortcut to navigate backwards to the previous field. The Right Arrow key and Space bar are not commonly used for input navigation in forms. The Tab key is often used to advance from one field to another in a form. It allows users to easily navigate through different fields without having to use the mouse or trackpad. The other options listed (Right Arrow key, Shift Tab, and Space bar) could be used for other purposes but are not commonly used for advancing through form fields.

Question 6

Which of the following is not true about what restrictions can be set for a form?
A) A user cannot delete a record.
B) A user cannot view a record.
C) A user cannot add a record.
D) A user cannot change a record.

Accepted Answer

The purpose of a form is to allow users to view and manipulate data. If a user cannot view a record, then the form becomes meaningless. Therefore, it is not true that a user cannot view a record. Restrictions can be placed on deleting, adding, and changing records to maintain data integrity and control access. All of the other options are possible restrictions that can be set for a form, but it would not make sense to restrict a user from viewing a record if the purpose of the form is to display information.

Question 7

Which of the following is a recommended way of informing users that a form is read-only?
A) Include a note in the form title.
B) Have a message box appear any time the form is opened.
C) There is no need to inform the user.
D) There is never a need to make a form read-only.

Accepted Answer

Including a note in the form title is the best way to inform users that a form is read-only. This way, users will immediately understand that they can view the content but cannot make any changes. A message box every time the form is opened may be too intrusive and annoying for users. It is always a good practice to inform users when they are not able to interact with a form, as it can prevent confusion and frustration. Option C and D are incorrect as it is important to inform users and there are scenarios where read-only forms are necessary. Including a note in the form title is a clear and straightforward way of informing users that the form is read-only. It eliminates any confusion or frustration that may arise if a user unknowingly tries to make changes to the form. A message box appearing every time the form is opened may become annoying to users and suggest an issue that doesn't exist. It is always essential to inform users if a form is read-only so they can proceed accordingly. Making forms read-only can be a useful feature in instances where you want to ensure that users don't change critical data.

Question 8

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?
A) Row Source
B) Column Source
C) Field Source
D) Record Source

Accepted Answer

The Row Source property is used to select the field in the table that will be used to generate the menu options. This property specifies the source of the data that will be displayed in the combo box. Option B, Column Source, and option C, Field Source, are not valid properties in Access. Option D, Record Source, refers to the source of data for a form or report as a whole, not specifically for a combo box. The Row Source property is used to specify the table or query that provides the values for the menu in a combo box. It can be set to the name of the table or query, or to a SQL statement that selects the necessary field(s) from the table(s).

Question 9

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit?
A) Tab Order
B) Custom Order
C) Auto Order
D) Auto Tabs

Accepted Answer

The correct name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit is Auto Order. This feature automatically arranges the tabs in the proper sequence by analyzing the placement of the controls on the form. It is the best choice because it saves time and effort in manually rearranging the tabs.

Question 10

Which of the following is not true about making a table the source data for a Combo Box?
A) It is quicker for Access to index the data.
B) The data is then in an easy-to-edit location.
C) The user can be forced to choose from only those records in the table.
D) New records can be added or existing records deleted very easily.

Accepted Answer

Making a table the source data for a Combo Box does not inherently make it quicker for Access to index the data. Indexing is a separate process that can be applied to tables to improve search performance, but simply using a table as the source for a Combo Box does not affect indexing speed.

Question 11

When might you not want to skip a tab stop?
A) Calculated field
B) AutoNumber field
C) Combo Box field
D) Any time the field requires no data entry

Accepted Answer

Skipping a tab stop is generally not desired for a Combo Box field because it requires user interaction for selection among predefined options. Unlike fields that require no data entry or automatically generate their content, a Combo Box field often needs the user to make a choice, thus necessitating focus during tab navigation.

Question 12

Creating a Combo Box is perfect when data ________.
A) repeats often
B) is always unique
C) entry requires more than one answer
D) will not be deleted

Accepted Answer

A Combo Box is perfect when data repeats often as it allows users to select from a predefined list of options, making data entry faster and more accurate. A Combo Box is ideal when data repeats often, as it allows users to select from a predefined list of options rather than typing in the same information repeatedly.

Question 13

Which of the following is not true about Combo Boxes?
A) They are not good for repetitive data.
B) They should not be used if the menu would become too long.
C) They can reference data in other tables.
D) They can make data entry more reliable.

Accepted Answer

Combo Boxes can be used for repetitive data and can make data entry more reliable. However, they should not be used if the menu would become too long, and they can reference data in other tables. Therefore, the statement that is not true is option A. Combo Boxes are actually good for repetitive data as they provide a dropdown list of options for the user to choose from, reducing the chances of errors in data entry.

Question 14

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?
A) Limit to List
B) Restrict to List
C) Limit to Menu
D) Restrict to Menu

Accepted Answer

The "Limit to List" property ensures that a user can only select an item from the list provided in the Combo Box. If this property is not enabled, the user can enter any value they want, which could cause issues with data validation or processing. The "Limit to List" property must be enabled in a Combo Box to ensure that the user can only select an item from the list of options provided. This prevents the user from entering invalid data into the field. The other options, "Restrict to List" and "Restrict to Menu", are not valid properties for a Combo Box. "Limit to Menu" is a valid property for a Menu control, but not for a Combo Box.

Question 15

Which of the following are not customizations you can make to a form?
A) Change the tab order
B) Convert a form to a report
C) Convert a text box to a menu
D) Make a form read-only

Accepted Answer

Converting a form to a report is not a customization that can be made to a form. The other options (changing tab order, converting a text box to a menu, and making the form read-only) are all possible customizations for a form. You cannot convert a form to a report as they are two different types of objects in Microsoft Access. The other options are all customizations you can make to a form.

Question 16

Subforms are often laid out in what type of fashion?
A) Grid
B) Tabular
C) Form
D) Nested

Accepted Answer

Subforms are typically laid out in a tabular fashion, with individual records displayed in rows and their fields in columns. This allows for efficient and organized presentation of data.

Question 17

Which of the following is not a reason to restrict who can edit data in a form?
A) Data can become unreliable.
B) Data can become hard to maintain.
C) The wrong people might be able to delete the records.
D) The file will get too large.

Accepted Answer

Restricting who can edit data in a form does not directly affect the size of the file, so option D is not a reason to restrict editing. Options A through C are all valid reasons, as allowing unrestricted editing can lead to unreliable or hard to maintain data, and unauthorized deletions. Restricting who can edit data in a form would not necessarily have any impact on the size of the file. The other options (A, B, and C) are all valid reasons to restrict editing access.

Question 18

A form that enables users to view but not change data is what type of form?
A) Restrict-only
B) DataView-only
C) Read-only
D) DataView

Accepted Answer

A read-only form allows users to view the data without the ability to make any changes. A read-only form allows users to view data without giving them the ability to make any changes, ensuring data integrity and accuracy. Restrict-only forms limit user access to certain fields, while DataView and DataView-only forms are not specific forms, but rather ways of displaying data in a certain format.

Question 19

What type of control is created if you create a form based on a table with a lookup field?
A) Check Box
B) Option button
C) Combo Box
D) Lookup Box

Accepted Answer

When you create a form based on a table with a lookup field, the best control to use is a combo box. A combo box allows the user to select from a list of predefined values while still allowing them to input their own value if needed. This provides a balance between ease of use and data integrity. A form based on a table with a lookup field would create a combo box control. The combo box allows users to select a value from a dropdown list based on the values in the related table.

Question 20

How does Access let you know that a form is set as read-only?
A) A notice will appear on the Status Bar while the form is open.
B) A pop-up message will appear when the form is opened.
C) The form fields will be grayed out.
D) No indication is given that a form is read-only.

Accepted Answer

The answer of How does Access let you know that...

Quiz 7: Advanced Forms and Reports

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

How does a Combo Box control appear to a user?

What is one way the user can tell that new records cannot be created in a form?

What is one way the user can tell that records cannot be deleted in a form?

What key is often used in a form to advance from one field to another?

Which of the following is not true about what restrictions can be set for a form?

Which of the following is a recommended way of informing users that a form is read-only?

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit?

Which of the following is not true about making a table the source data for a Combo Box?

When might you not want to skip a tab stop?

Creating a Combo Box is perfect when data ________.

Which of the following is not true about Combo Boxes?

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

Which of the following are not customizations you can make to a form?

Subforms are often laid out in what type of fashion?

Which of the following is not a reason to restrict who can edit data in a form?

A form that enables users to view but not change data is what type of form?

What type of control is created if you create a form based on a table with a lookup field?

How does Access let you know that a form is set as read-only?