Question 1

Which of the following is NOT true regarding the Locked property?
A)The Enabled property is not as strong as a lock.
B)A value of No means that data can be entered.
C)The Locked property determines whether data can be entered into the field on the form.
D)A value of Yes means that the field is locked and data cannot be entered.

Accepted Answer

A

Question 2

Which of the following is NOT true in regard to the Layout view of a form?
A)Layout view shows the form and the data.
B)Some of the form design such as field lengths and fonts can be changed in this view.
C)This is the view you use to change data in the form.
D)This view gives you an easy way to resize fields and check form appearance while you are creating the form.

Accepted Answer

The statement "This is the view you use to change data in the form" is not true. The Layout view is used to design and modify the appearance of a form, but data entry and editing is done in Form view or Datasheet view.

Question 3

The ________ is a pop-up calendar that allows a user to enter a date by clicking a date in the calendar.
A)Calendar Form
B)Pop-up Window
C)Date Pop-up
D)Date Picker

Accepted Answer

The term "date picker" is commonly used to refer to a pop-up calendar that allows users to select dates by clicking on them. Therefore, option D, "Date Picker", is the most appropriate choice. The other options, "calendar form", "pop-up window", and "date pop-up" are either vague or not commonly used terms to describe this feature.

Question 4

Which of the following is NOT true regarding dates on forms?
A)The Access function NOW automatically puts the current date based on your computer's system date in the field.
B)The function DateAdd allows you to add an interval to a date.
C)You can use Date functions and calculations as the default value in a field.
D)Using the DateAdd function is always returns a valid date.

Accepted Answer

The answer of Which of the following is NOT true...

Question 5

The ________ tab is where properties that change the display of a field or form part are listed.
A)Macro
B)Event
C)Data
D)Format

Accepted Answer

The Format tab in Microsoft Access is where users can change the display properties of fields and form parts. This includes changing the font, color, size, and alignment of text, as well as setting data validation rules and display formats such as currency or date/time. The Macro tab is used for creating and editing macros, the Event tab is used for defining events and event procedures, and the Data tab is used for defining data sources and relationships.

Question 6

The ________ tab contains all other properties that are not on one of the other tabs,such as name or datasheet caption.
A)Event
B)Data
C)Format
D)Other

Accepted Answer

The "Other" tab in the Property Sheet contains all properties that are not found on any of the other tabs, such as name or datasheet caption.

Question 7

Which of the following is NOT true in regard to the Design view of a form?
A)Design view shows the form design but not the data.
B)Any aspect of the form design can be changed.
C)This view is used for creation of the form.
D)It is much easier to size and move controls in Design view.

Accepted Answer

It is much easier to size and move controls in Layout view, not Design view.

Question 8

When modifying a box control on a form,which of the following cannot be resized or moved?
A)Width
B)Length
C)Top
D)Left

Accepted Answer

Length is not a property of a box control in most form design environments, whereas Width, Top, and Left are common properties that can be adjusted.

Question 9

If the ________ property is No,the data cannot be entered or copied.
A)locked
B)editing
C)tab
D)enabled

Accepted Answer

The answer of If the ________ property is No,the data...

Question 10

________ forms can be used for operating your database by allowing you to specify parameters,create buttons to print reports,and other operations.
A)Calculated
B)Bound
C)Unbound
D)Linked

Accepted Answer

Unbound forms are designed for custom user interface purposes, allowing users to specify parameters, create buttons to print reports, and run other operations. Bound forms, on the other hand, are connected to a data source and are used to display and manipulate data from a specific table or query. Calculated and linked forms are specific to certain types of data manipulation and are not appropriate for general database operations.

Question 11

Which of the following form sections is NOT included on the form when the form is initially created?
A)Detail section
B)Header
C)Footer
D)Design view allows you to add additional sections

Accepted Answer

The answer of Which of the following form sections is...

Question 12

Which of the following is NOT true regarding bound forms?
A)The field lengths are defined as you progress through the wizard.
B)When you create a form from a table using the wizard,the form is bound to the table you used to run the wizard.
C)The field labels are the captions defined for the fields in the table design.
D)The formatting for the fields is based upon the field definitions in the table design.

Accepted Answer

The field lengths for bound forms are not defined as you progress through the wizard. They are based on the field definitions in the table design.

Question 13

Which of the following is NOT true in regard to the Form view of a form?
A)This view gives you an easy way to resize fields and check form appearance while you are creating the form.
B)This is the view you use to enter or change data.
C)This is the view that employees would use when they are performing their jobs.
D)You cannot change the form design in this view.

Accepted Answer

Form view is primarily used for data entry and viewing, not for resizing fields or checking form appearance, which is typically done in Design view.

Question 14

You can set procedures to determine what happens when a user performs an action such as clicking on a field on the ________ tab.
A)Other
B)Event
C)Data
D)Format

Accepted Answer

The best choice is B because events are actions performed by the user, such as clicking on a field, and setting procedures for those events allows you to control what happens in response to that action. The other options (Other, Data, Format) do not specifically relate to user actions or event procedures.

Question 15

The Default Value,an option on the ________ tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.
A)Other
B)Event
C)Data
D)Format

Accepted Answer

The Default Value option is found on the Data tab in the Property Sheet pane. This option allows you to set a default value that will automatically appear in a new blank record for a particular field in your table.

Question 16

A(n)________ form is directly connected to a data source such as a table or query and can be used to enter,edit,or display data from that data source.
A)calculated
B)bound
C)unbound
D)linked

Accepted Answer

A bound form is directly connected to a data source such as a table or query and can be used to enter, edit, or display data from that data source.

Question 17

A ________ must be created in Design view,but it can later be modified in Layout view.
A)detail section
B)header
C)subform
D)footer

Accepted Answer

The answer of A ________ must be created in Design...

Question 18

The ________ tab contains the properties including the field source and the properties that affect the values that can be entered into a field.
A)All
B)Event
C)Data
D)Format

Accepted Answer

The Data tab in Access contains properties related to the data that can be entered into a field, including the field source, data type, format, input mask, and validation rules. The other tabs (All, Event, Format) do not contain all of these properties.

Question 19

Which of the following is NOT true about the Property Sheet?
A)To display,click Property Sheet on the Design tab of the Ribbon.
B)To display,click Property Sheet on the Format tab of the Ribbon.
C)To display,right-click the value,and then select Properties from the shortcut menu.
D)The Property Sheet is available in Layout view and Design view.

Accepted Answer

The Property Sheet can be accessed from the Design tab of the Ribbon or by right-clicking on a value and selecting Properties. It is available in Layout view and Design view. However, it is not accessed through the Format tab of the Ribbon.

Question 20

Every field on a form has certain characteristics about the field stored in the ________.
A)Property tab
B)property sheet
C)All sheet
D)Formatting tab

Accepted Answer

The Property Sheet is where all the characteristics of each field on a form are stored, including data type, default value, validation rules, and formatting. The other options listed (Property Tab, All Sheet, Formatting Tab) do not accurately describe where this information is stored.

Quiz 10: Workshop 10: Advanced Form Settings and Form Types

Which of the following is NOT true regarding the Locked property?

Which of the following is NOT true in regard to the Layout view of a form?

The ________ is a pop-up calendar that allows a user to enter a date by clicking a date in the calendar.

Which of the following is NOT true regarding dates on forms?

The ________ tab is where properties that change the display of a field or form part are listed.

The ________ tab contains all other properties that are not on one of the other tabs,such as name or datasheet caption.

Which of the following is NOT true in regard to the Design view of a form?

When modifying a box control on a form,which of the following cannot be resized or moved?

If the ________ property is No,the data cannot be entered or copied.

________ forms can be used for operating your database by allowing you to specify parameters,create buttons to print reports,and other operations.

Which of the following form sections is NOT included on the form when the form is initially created?

Which of the following is NOT true regarding bound forms?

Which of the following is NOT true in regard to the Form view of a form?

You can set procedures to determine what happens when a user performs an action such as clicking on a field on the ________ tab.

The Default Value,an option on the ________ tab in the Property Sheet pane,allows you to define a value that will automatically appear in a new blank record.

A(n) ________ form is directly connected to a data source such as a table or query and can be used to enter,edit,or display data from that data source.

A ________ must be created in Design view,but it can later be modified in Layout view.

The ________ tab contains the properties including the field source and the properties that affect the values that can be entered into a field.

Which of the following is NOT true about the Property Sheet?

Every field on a form has certain characteristics about the field stored in the ________.