Question 1

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

Accepted Answer

The button/command in the Tab Order dialog box that allows Access to reorder your tabs is called "Auto Order". Choosing this option will automatically order your tabs based on the position of the controls on your form.

Question 2

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

D

Question 3

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 property that must be enabled is "Limit to List". This ensures that the user can only select an item from the list in the Combo Box and cannot enter any arbitrary value. The other options, "Restrict to List" and "Restrict to Menu" are not valid properties for a Combo Box. "Limit to Menu" also does not make sense in the context of a Combo Box.

Question 4

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 5

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

A lookup field is designed to display a list of values from another table, and the most suitable control for displaying such a list is a combo box. The combo box allows the user to choose an option from the dropdown list or type in a new value that will be added to the lookup table. Option buttons and check boxes are not appropriate for a lookup field, as they are designed for selecting one or multiple values within the same table. A lookup box is not a valid control in Microsoft Access.

Question 6

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 7

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 is important to ensure that data remains reliable and easy to maintain, and to prevent the wrong people from deleting records. However, the file size is not related to who can edit the data in a form.

Question 8

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

Restrictions can be set for a form to limit the user's ability to add, change or delete a record. However, the user should always be able to view a record. Therefore, option B is not true.

Question 9

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 a common and clear way of informing users that a form is read-only. This way, users can quickly and easily recognize that they cannot edit the form. Having a message box appear every time the form is opened can be annoying and disrupt the user experience. It should be avoided unless it's a critical system notification. It's always a good practice to communicate effectively with the user when the user's actions are limited. Therefore, there is a need to inform the user. Making a form read-only is a way to ensure that users cannot alter data they're not allowed to. Hence, the need to make forms read-only when necessary.

Question 10

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 a common convention in most software applications and websites as it helps in easy navigation and prevents the need for using the mouse to move between fields.

Question 11

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 12

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 as a menu of options where the user can select one option from a list. Option buttons and check boxes allow for only one option to be selected at a time, which is not the desired behavior for a Combo Box control. Legacy controls are outdated and no longer widely used.

Question 13

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 indicates that the user cannot delete records in the current form. This is a common design feature in forms that have restricted or read-only access to the underlying data, or that only allow certain users to make changes. The other options (A, B, and D) are not necessarily indicative of records being unable to be deleted, as the Delete command may be hidden, disabled, or otherwise modified in some forms.

Question 14

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 good for repetitive data as they allow users to select from a pre-defined list of options, making data entry more efficient and reliable.

Question 15

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

The Layout view allows you to see the data as it appears in the subform and makes it easier to make edits or adjustments. The Design view is more focused on the technical aspect of the subform and may not provide a clear visual representation of the data. The Form and Report views are not applicable when editing a subform.

Question 16

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 listed (changing tab order, converting a text box to a menu, and making a form read-only) are all valid customizations that can be made to a form.

Question 17

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

If the New command is grayed out, it indicates that it is not currently available and new records cannot be created in the form.

Question 18

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

When data repeats often, creating a Combo Box is a smart choice as it allows users to quickly and easily select from a pre-determined list of options instead of having to type out the same thing repeatedly.

Question 19

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 specify the source of the values displayed in the Combo Box. It can be a table, query, or value list. By setting the Row Source property to the desired table, you can pick the field in the table which will be used to generate the menu.

Question 20

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 data but not make any changes to it. Restrict-only and DataView-only forms are not commonly used terminology in the context of forms. A DataView could refer to a form that displays a subset of data based on specific criteria, but it does not necessarily imply that the form is read-only.

Quiz 8: Advanced Forms and Reports

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

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

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

When might you not want to skip a tab stop?

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

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

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

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?

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

Subforms are often laid out in what type of fashion?

How does a Combo Box control appear to a user?

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

Which of the following is not true about Combo Boxes?

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?

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

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

Creating a Combo Box is perfect when data ________.

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 form that enables users to view but not change data is what type of form?