Question 1

Which control provides an easy way to initiate a command or run a macro?
A) Check box
B) Toggle button
C) Command button
D) Image control

Accepted Answer

A command button is specifically designed to initiate a command or run a macro. Check boxes and toggle buttons usually represent options that can be selected or deselected, while image controls are simply a way to display an image.

Question 2

Which control is used to provide consistent descriptive text as you navigate from record to record?
A) Text box
B) Combo box
C) List box
D) Label

Accepted Answer

Labels are used to provide consistent descriptive text that remains constant as the user navigates from record to record. Text boxes, combo boxes, and list boxes are used to display dynamic data that can change depending on the record being viewed.

Question 3

____ View lets you make some design changes to a form while you are browsing the data.
A) Layout
B) Design
C) Browse
D) Data

Accepted Answer

Layout view allows you to make design changes to a form while viewing the data, including changing the position and size of controls, adding or removing fields, and adjusting the overall layout of the form. Design view, on the other hand, is used for more extensive design work, such as adding new controls or modifying the underlying data source of the form. Browse view is simply a way to navigate through the data in a form or table, while data view is used to edit the individual data values in a form or table.

Question 4

When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.
A) label indices
B) sizing handles
C) combo boxes
D) command squares

Accepted Answer

Sizing handles are small squares at the corners of the selection box which can be used to resize the image or control in Design View. Label indices, combo boxes, and command squares do not have this functionality.

Question 5

Which control, when it appears pressed, displays "yes" information?
A) Bound image control
B) Combo box
C) Tab control
D) Toggle button

Accepted Answer

A toggle button typically displays a "yes" or "no" information when pressed, as it toggles between the two states.

Question 6

Which of the following is NOT a bound control?
A) Text box
B) Combo box
C) List box
D) Label

Accepted Answer

A label control in Microsoft Access is an unbound control, as it is used to display descriptive text or a message that does not change based on the user's input or actions. Text boxes, combo boxes, and list boxes are all bound controls that display or allow the user to enter data from a table or query.

Question 7

Which control is used to create a three-dimensional aspect to a form?
A) Command button
B) Toggle button
C) Rectangle control
D) Tab control

Accepted Answer

The answer of Which control is used to create a...

Question 8

Which control displays a list of possible data entries from which the user can choose?
A) Label
B) Text box
C) List box
D) Tab control

Accepted Answer

A list box is specifically designed to display a list of possible data entries for the user to choose from. Labels are used to display text, text boxes are used for user input, and tab controls are used to organize content into separate tabs.

Question 9

You can press ____ to move the focus through the controls of the form.
A) [Page Down]
B) [Tab]
C) [F5]
D) [F12]

Accepted Answer

The [Tab] key is used to move the focus through the controls of the form, allowing the user to easily navigate and interact with each element. The other options ([Page Down], [F5], [F12]) are not typically used for this purpose.

Question 10

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.
A) second
B) third
C) fourth
D) fifth

Accepted Answer

The answer of  In the accompanying figure, the ____...

Question 11

In the accompanying figure, the ____ tool will create a form from scratch in Form Layout View.
A) first
B) second
C) third
D) fourth

Accepted Answer

The answer of  In the accompanying figure, the ____...

Question 12

____ refers to the space between the outer edge of the control and the data displayed inside the control.
A) Spacing
B) Reference
C) Padding
D) Margin

Accepted Answer

The answer of ____ refers to the space between the...

Question 13

____ records are those on the many side of a relationship that do not have a match on the one side.
A) indexed
B) split
C) unlicensed
D) orphan

Accepted Answer

Orphan records are those that do not have a match on the one side of a relationship. This can happen, for example, when a record in a child table refers to a non-existent record in a parent table. These orphan records can cause issues with data integrity and need to be handled appropriately.

Question 14

In the accompanying figure, the ____ tool is used to navigate or move between different areas of the database.
A) first
B) second
C) third
D) fifth

Accepted Answer

The answer of  In the accompanying figure, the ____...

Question 15

The Align button in the Sizing & Ordering group is available on the ____ tab.
A) ARRANGE
B) OPTIONS
C) HOME
D) FORMAT

Accepted Answer

The Align button in the Sizing & Ordering group is available on the ARRANGE tab in PowerPoint.

Question 16

Expressions must start with what character?
A) [ left square bracket
B) = equal sign
C) ( left parenthesis
D) : colon

Accepted Answer

The answer of Expressions must start with what character?
A) [...

Question 17

Which control is both a list box and a text box control?
A) Bound image control
B) Unbound image control
C) Combo box
D) Option group

Accepted Answer

A combo box is a control that allows the user to select an item from a drop-down list, or to enter their own value in a text box within the control. It combines the functionality of a list box and a text box control. The other options listed, bound and unbound image controls and option groups, do not have both list box and text box functionality.

Question 18

Which of the following would most likely be used to display a Yes/No field on a form?
A) Check box
B) Command button
C) Combo box
D) Label

Accepted Answer

A check box is commonly used to display a Yes/No field on a form. When checked, it represents a "Yes" response and when unchecked, it represents a "No" response.

Question 19

Referential integrity prevents the creation of ____ records.
A) indexed
B) split
C) unlicensed
D) orphan

Accepted Answer

Referential integrity ensures that records in a database are linked to related records in other tables. If a record in a related table is deleted, the referential integrity rule prevents the creation of orphan records in the original table. Therefore, the correct choice is D - orphan.

Question 20

When referencing field names within an expression, surround the field name with ____.
A) [square brackets]
B) {curly brackets}
C) (parentheses)
D) "quotation marks"

Accepted Answer

Square brackets are the correct syntax for referencing field names within an expression in most programming languages and software applications, including Microsoft Access and Excel. Using any other punctuation could result in errors or confusion.

Quiz 3: Using Forms

Which control provides an easy way to initiate a command or run a macro?

Which control is used to provide consistent descriptive text as you navigate from record to record?

____ View lets you make some design changes to a form while you are browsing the data.

When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.

Which control, when it appears pressed, displays "yes" information?

Which of the following is NOT a bound control?

Which control is used to create a three-dimensional aspect to a form?

Which control displays a list of possible data entries from which the user can choose?

You can press ____ to move the focus through the controls of the form.

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

In the accompanying figure, the ____ tool will create a form from scratch in Form Layout View.

____ refers to the space between the outer edge of the control and the data displayed inside the control.

____ records are those on the many side of a relationship that do not have a match on the one side.

In the accompanying figure, the ____ tool is used to navigate or move between different areas of the database.

The Align button in the Sizing & Ordering group is available on the ____ tab.

Expressions must start with what character?

Which control is both a list box and a text box control?

Which of the following would most likely be used to display a Yes/No field on a form?

Referential integrity prevents the creation of ____ records.

When referencing field names within an expression, surround the field name with ____.