Microsoft Access Proctored Exam 2 Study Guide
What happens when you apply a theme to a form?
The formatting changes in all forms and reports.
Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?
You can change the orientation of the report to Landscape.
How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?
Enter "Product Description" in the Caption property for the field.
In Form Design view, you can make design changes while displaying the data.
False
In Report Layout view, you use the Format Painter to change the theme of a report.
False
The Alternate Background Color command changes the background color of alternate records in a selected section.
False
The only way to create a Crosstab query is to use the Crosstab Query Wizard.
False
To add a heading to the Detail section of a form, you use a text box control.
False
Use a Size option when you want to specify the exact height and width of two selected controls.
False
When you add a new field to a form, two controls are usually created: a(n) caption and a text box.
False
You switch to Report Layout view to display the entire report as it will appear when printed.
False
Conditional formatting can change the appearance of a report control based on criteria you specify.
TRue
A combo box is a combination of a text box and command button.
True
A parameter query displays a dialog box that prompts you for field criteria.
True
A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.
True
Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.
True
If you do not enter a Caption property for a field, Access uses the field name to label the field.
True
The Allow Value List Edits property determines whether users can change the items in a lookup list.
True
To add a subform to a form in Form Design view, you use the Subform/Subreport control.
True
To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.
True
To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.
True
Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.
True
Use a Number field to store values that represent money.
True
You use conditional formatting to highlight important data in a report.
True
You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.
True
Deleting a text box in Form Layout view _____.
removes the text box from the form
To close a form in Form Design view and keep Access running, you _____.
right-click the form tab, and then click Close on the shortcut menu.
When you click the first value in a column in Report Layout view, what are you actually selecting?
the control containing the value
Create a Top Values query to find the highest values in set of unsorted records.
False
If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.
"Positive"
Which of the following statements apply to Long Text fields? Select all the options that apply.
- set the Append Only property to let users add but not change data in a Long Text field. -Use Long Text fields when you need to store more than 256 characters in a field. -Fields that store comments, reviews, or notes are good candidates for Long Text fields.
Which of the following are common report enhancements?
-Font colors -HEaders -Footers
In a calculated control, expressions must start with what character?
=
What could you use to display the amount of a 25% discount on a form?
A calculated control
An aggregate function is _____.
A function that calculates a statistic such as a subtotal or average.
To change the background color of a form control in Form Design view, you use the _____ button.
Background Color
A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.
Crosstab
What data type is most appropriate for a field named PaymentAmt?
Currency
A check box control usually displays a "yes" or "no" answer for a field.
False
Alternate colors are a set of coordinated colors to apply to reports and other database objects.
False
To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.
Form Design Tools Arrange
In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.
Format
In Report Design view, you set the sort order of records in a report using the _____.
Group & Sort
What is the advantage of grouping controls on a form?
Grouping related form controls makes forms more understandable for all users, as related controls are easier to identify
Where does a background image appear in a report?
In the background.
Which of the following controls would you use to describe another control on a report?
Label
In _____ view, you can make some design changes to a report while you are displaying the data.
Layout
The _____ property indicates which field serves the link between the main form and subform.
Link Master Fields
You can retain a history of changes to a _____ field.
Long TExt
_____ fields allow you to make more than one choice from a field's lookup list.
Lookup
If you move a text box in Form Design view, you _____.
MOVE LABEL ASSOCIATED WITH TEXT BOX
To change the fonts in all the forms and reports in the database, you can change the _____.
Orientation
In which one of the following views can you edit the text in a label?
Report Layout View
Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?
Size/Space
To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.
Summary Query
If you select a(n) _____ control on a form in Form view, it means "yes" or "true".
button
Which of the following controls would you use to display a Yes/No field on a form?
check box
To center the text in a selected form control in Form Layout view, you _____.
click the Center button on the Home tab
To set a validation rule for an entire table, you _____.
open the property sheet for the table
To have form users select one of three options, add a(n) _____ to the form.
option group
If you select 25 in the Top Values list, Access displays _____ in the query results.
the top 25 records