-Which of the following can you add to a form to automate user tasks? text box l
ID: 3719895 • Letter: #
Question
-Which of the following can you add to a form to automate user tasks?
text box
label
command button
check box
-Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?
By entire value
By partial value
Custom
Ascending or descending sort
-When using multiple conditional formatting rules, which of the following statements is true?
The order of the rules is unimportant.
The order of the rules is important.
Access continues to evaluate rules after a match is found.
all of the above
-Which of the following is true about blank reports?
They use the tabular layout.
They use the stacked layout.
They don't contain any controls.
The header area contains a default title.
-Which of the following grouping options would you want to use to group records based on the entire value in a selected field?
By entire value
By partial value
Custom
Ascending or descending sort
-What is a text box that gets its value from a field in a table?
bound control
unbound control
calculated control
stacked control
-Which of the following indicates that a control has been selected?
an orange border
a green border
a red border
a red dashed border
-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?
Allow Edits property
Allow Deletions property
Data Entry property
Tabular control layout
-When adding totals to a report, which of the following calculation options totals up the values in a particular field?
Sum
Count Values
Max
Standard Deviation
-In addition to selecting the rule type and conditions, what else must you select when building a rule?
command buttons
bound controls
a control layout
desired formatting
-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?
text box
label
command button
check box
-Some form controls are unbound, which means that they are not linked to a data source.
True
False
-Which of the following creates a button and attaches all of the necessary functionality to the button?
Conditional Formatting Rules Manager
control layouts
Property Sheet
Command Button Wizard
-An ascending sort for a date field is 'from oldest to newest.'
True
False
-It is possible to click and drag a field into the report window to add it into the control layout.
True
False
-When a new blank form is created, there are no controls initially placed on the form.
True
False
-The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.
True
False
-When adding totals to a report, which of the following calculation options counts up the number of records that meet a certain condition?
Sum
Count Values
Max
Standard Deviation
Explanation / Answer
Answered first four questions:
- Which of the following can you add to a form to automate user tasks?
command button: Because this will allow user to just click it or use tab to press it and execute the selected command
- Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?
Custom: You need to count the number of characters to order, this will be custom
- When using multiple conditional formatting rules, which of the following statements is true?
The order of the rules is important. - Because this will impact your final result, may be you want to filteer some data before applying formatting to it
Access continues to evaluate rules after a match is found. - Yes because formatting is applied to the entire selected set
-Which of the following is true about blank reports?
They use the tabular layout.
They don't contain any controls.
The header area contains a default title.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.