Deck 7: Creating Advanced Forms

Question 1

In a stacked form layout,all of the fields have the same width.

Answer 1

True

Question 2

After you create a form,you can edit the form in Layout view or Design view.

Answer 2

True

Question 3

The Form Wizard steps you through the process of quickly creating a form.

Answer 3

True

Question 4

Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

Question 5

When modifying a form,Design view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

Question 6

To organize controls vertically on a form,use a tabular layout.

Question 7

A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

Question 8

Some form controls are unbound,which means that they are not linked to a data source.

Question 9

A stepped report layout displays the fields in a horizontal,justified layout.

Question 10

A text box that gets its value from an expression is a calculated control.

Question 11

A bound form contains a link to the data source.

Question 12

When working with forms,Form view allows you to make changes to the form.

Question 13

Like forms,reports allow you to modify the underlying data source.

Question 14

The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

Question 15

It is a good design practice to add a title to a form.

Question 16

In Access,fields,labels,and buttons are called objects.

Question 17

When a new blank form is created,there are no controls initially placed on the form.

Question 18

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

Question 19

When adding fields to a form,press Ctrl+F8 to show or hide the Field List.

Question 20

A check box is a database object that allows you to write and attach code to different objects and controls in your database.

Question 21

What does Access call a form that doesn't have a connection to a data source?

A) bound form
B) connected form
C) unbound form
D) disconnected form

Question 22

It is possible to click and drag a field into the report window to add it into the control layout.

Question 23

The Conditional Formatting Rules Manager only displays rules for one field at a time.

Question 24

When creating a form using the Form Wizard,which of the following layout options would you use to display the fields in a table (row and column)format?

A) Columnar
B) Tabular
C) Datasheet
D) Justified

Question 25

An ascending sort for a date field is "from oldest to newest."

Question 26

You can have a maximum of one conditional formatting rule in a report.

Question 27

On the Design tab,selecting the Title button adds a title into the header section of the report.

Question 28

Which of the following allows you to view data in two different ways at the same time,with the top section showing one record in a columnar mode and the bottom section displaying in Datasheet view?

A) bound form
B) connected form
C) unbound form
D) split form

Question 29

When working with forms,which of the following views would you use if you want to alter the design of a form and see the effects of the changes in real time?

A) Form view
B) Design view
C) Layout view
D) Datasheet view

Question 30

What does Access call a form that is directly connected to a table or query,the source of the data?

A) bound form
B) connected form
C) unbound form
D) split form

Question 31

When working with multiple conditional formatting rules,Access stops evaluating when a match is found.

Question 32

When modifying a form,which of the following views is best when you want to resize a field or label,change colors or text alignment,or apply different formats?

A) Form view
B) Design view
C) Layout view
D) Datasheet view

Question 33

In Access,what are the fields,labels,and buttons called?

A) objects
B) controls
C) commands
D) layouts

Question 34

Access allows you to sort on multiple fields only if each field is sorted in ascending order.

Question 35

When creating a form using the Form Wizard,which of the following layout options would you use to display just one record at a time?

A) Columnar
B) Tabular
C) Datasheet
D) Justified

Question 36

When viewing a report,Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

Question 37

When working with forms,which of the following views would you use if you want to enter and view data?

A) Form view
B) Design view
C) Layout view
D) Datasheet view

Question 38

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

Question 39

When defining multiple conditional formatting rules,the order in which the rules are listed is not important.

Question 40

When working with forms,which of the following views would you use if you want to view the completed structure of the form so you can modify any aspect of the form?

A) Form view
B) Design view
C) Layout view
D) Datasheet view

Question 41

Which of the following can you use to print the current form,close the current form,navigate to the next record,or open another form?

A) text box
B) label
C) command button
D) check box

Question 42

Which of the following report layouts displays fields in a horizontal layout?

A) columnar
B) tabular
C) justified
D) stepped

Question 43

To select multiple controls at once,what must you press and hold down while selecting controls?

A) F3
B) Alt
C) Ctrl
D) Shift

Question 44

Which of the following report layouts displays fields in one column?

A) columnar
B) tabular
C) justified
D) stepped

Question 45

Which of the following can you use to select the desired settings to limit actions available in a form?

A) Conditional Formatting Rules Manager
B) control layouts
C) Property Sheet
D) Command Button Wizard

Question 46

Which of the following can you add to a form to automate user tasks?

A) text box
B) label
C) command button
D) check box

Question 47

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

A) text box
B) label
C) command button
D) check box

Question 48

What is a text box that gets its value from a field in a table?

A) bound control
B) unbound control
C) calculated control
D) stacked control

Question 49

Which of the following should you use to restrict a form to only allow data entry when you don't want the user to be able to view data already in the database?

A) Allow Edits property
B) Allow Deletions property
C) Data Entry property
D) Tabular control layout

Question 50

Which of the following control layouts organizes data vertically?

A) tabular layout
B) datasheet layout
C) stacked layout
D) vertical layout

Question 51

Which of the following views lets you see how the report will look in print and also allows you to make modifications to the print settings?

A) Report view
B) Print Preview view
C) Design view
D) Layout view

Question 52

What is a text box that gets its value from an expression?

A) bound control
B) unbound control
C) calculated control
D) stacked control

Question 53

Which of the following views divides a report into the following three sections: Page Header,the Detail,and the Page Footer?

A) Report view
B) Print Preview view
C) Design view
D) Layout view

Question 54

Which of the following is used to display or accept data for a field with a Yes/ No data type?

A) text box
B) label
C) command button
D) check boxes

Question 55

If you are displaying a form in Design view,what can you press to display the form in Form view?

A) F3
B) F5
C) F7
D) F8

Question 56

When adding fields to a form,which of the following keyboard shortcuts lets you show or hide the Field List?

A) Shift+F8
B) Ctrl+F8
C) Alt+F8
D) Shift+F9

Question 57

Which of the following creates a button and attaches all of the necessary functionality to the button?

A) Conditional Formatting Rules Manager
B) control layouts
C) Property Sheet
D) Command Button Wizard

Question 58

Which of the following report layouts displays fields in a row and column format?

A) columnar
B) tabular
C) justified
D) stepped

Question 59

What is the main advantage of using one of Access's control layouts when designing a form?

A) Control layouts provide structure.
B) Control layouts let you easily insert all of the fields in your data source into your form.
C) Control layouts provide visual appeal with varied themes.
D) Control layouts are compatible with other software applications.

Question 60

Which of the following views is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time?

A) Report view
B) Print Preview view
C) Design view
D) Layout view

Question 61

Which of the following grouping options would you want to use to group records by the first character of a field?

A) By entire value
B) By partial value
C) Custom
D) Ascending or descending sort

Question 62

Which of the following would you want to use in a report to include all properties from the same city together in a real estate database?

A) sorting
B) conditional formatting
C) a split form
D) grouping

Question 63

Which of the following allows you to format only values that meet a specified condition?

A) Rules Manager
B) conditional formatting
C) split form
D) Report Wizard

Question 64

In a report,which of the following controls gets its value from an expression?

A) bound control
B) unbound control
C) calculated control
D) stacked control

Question 65

Which of the following should you use to create a report if you are short on time?

A) Report view
B) Report Wizard
C) Form Wizard
D) Command Button Wizard

Question 66

Which of the following buttons adds two controls into the header section,an Auto_Header control which contains the title and an Auto_Logo control which can contain a logo?

A) Date and Time button
B) Logo button
C) Page Numbers button
D) Title button

Question 67

Which of the following indicates that a control has been selected?

A) an orange border
B) a green border
C) a red border
D) a red dashed border

Question 68

For number fields,what is the default sort order?

A) newest to oldest
B) oldest to newest
C) largest to smallest
D) smallest to largest

Question 69

Which of the following layouts places labels above the data values?

A) tabular layout
B) stacked layout
C) justified layout
D) grouped layout

Question 70

Which of the following layouts places labels to the left of the data control?

A) tabular layout
B) stacked layout
C) justified layout
D) grouped layout

Question 71

Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?

A) By entire value
B) By partial value
C) Custom
D) Ascending or descending sort

Question 72

Which of the following is true about blank reports?

A) They use the tabular layout.
B) They use the stacked layout.
C) They don't contain any controls.
D) The header area contains a default title.

Question 73

Which of the following options in the Group,Sort,and Total pane calculates overall totals for all records?

A) Select the field and type of calculation
B) Show grand totals
C) Show group totals as percent of grand total
D) Show in header or footer section

Question 74

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

A) Report view
B) Print Preview view
C) Design view
D) Layout view

Question 75

Which of the following options in the Group,Sort,and Total pane determines which section displays the totals?

A) Select the field and type of calculation
B) Show grand totals
C) Show group totals as percent of grand total
D) Show in header or footer section

Question 76

Which of the following grouping options would you want to use to group records based on the entire value in a selected field?

A) By entire value
B) By partial value
C) Custom
D) Ascending or descending sort

Question 77

Where are a report's title,the current date,and page numbers typically placed in a report?

A) Detail area
B) Page Header area
C) Page Footer area
D) Page Header and Page Footer areas

Question 78

Which of the following can be added to a report independent of grouping or sorting being used?

A) unbound form
B) bound form
C) totals
D) control layout

Question 79

Which of the following is useful when you want to organize and summarize you data?

A) sorting
B) conditional formatting
C) a split form
D) grouping

Question 80

For date fields,what is the default sort order?

A) newest to oldest
B) oldest to newest
C) largest to smallest
D) smallest to largest