Exam 6: Managing Data With Data Tools
Exam 1: Getting Started With Excel94 Questions
Exam 2: Formatting Workbook Text and Data55 Questions
Exam 3: Performing Calculations With Formulas and Functions69 Questions
Exam 4: Analyzing and Charting Financial Data41 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks69 Questions
Exam 6: Managing Data With Data Tools120 Questions
Exam 7: Summarizing Data With Pivottables43 Questions
Exam 8: Performing What-If Analyses62 Questions
Exam 9: Exploring Financial Tools and Functions62 Questions
Exam 10: Analyzing Data With Business Intelligence Tools64 Questions
Exam 11: Exploring Pivottable Design88 Questions
Exam 12: Developing an Excel Application103 Questions
Select questions type
If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.
Free
(Multiple Choice)
4.9/5
(39)
Correct Answer:
A
If you select a(n) _____ control on a form in Form view, it means "yes" or "true".
Free
(Multiple Choice)
4.7/5
(27)
Correct Answer:
A
If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.
Free
(Multiple Choice)
4.9/5
(39)
Correct Answer:
D
To change the text displayed on the report tab, use the report's Caption property.
(True/False)
4.8/5
(30)
The _____ determines the underlying table or query for a form.
(Multiple Choice)
4.9/5
(37)
To use the Command Button Wizard, the _____ button must be toggled on.
(Multiple Choice)
4.8/5
(36)
When you add a field to a form in Form Layout view, Access creates a text box but not a label.
(True/False)
4.9/5
(39)
What criterion would you use in the LastName field to find records that do not contain a last name?
(Multiple Choice)
4.8/5
(31)
If you delete the text box for the State field on a report, Access removes _____.
(Multiple Choice)
4.8/5
(34)
To select more than one control in Form Design view, you _____ and then click each control.
(Multiple Choice)
4.8/5
(40)
How can you select more than one control at a time in Form Design view? Select all the options that apply.
(Multiple Choice)
4.8/5
(27)
To determine whether a control appears or is hidden on a form, set the _____ property for the control.
(Multiple Choice)
4.8/5
(35)
In _____ view, you can make some design changes to a report while you are displaying the data.
(Multiple Choice)
4.8/5
(29)
Which of the following are controls you can add to a form in Form Layout view? Select all the options that apply.
(Multiple Choice)
4.8/5
(27)
To have form users select one of three options, add a(n) _____ to the form.
(Multiple Choice)
4.9/5
(39)
To change the column layout in a report in Report Design view, you use the _____.
(Multiple Choice)
4.8/5
(32)
To add a subform to a form in Form Design view, you use the Subform/Subreport control.
(True/False)
4.9/5
(40)
The Display Control property of a _____ field is set to Combo Box by default.
(Multiple Choice)
5.0/5
(27)
Showing 1 - 20 of 120
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)