A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____. |
Predefined input mask |
The aggregate function which returns the number of nonnull field values is the ____ function. |
Count |
Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number? |
999\-000\-0000 |
Crosstab queries may use which of the following aggregate functions? |
Var |
An input mask property cannot be changed after the Input Mask Wizard closes. |
False |
Rich text formatting available for Long Text fields includes ____. |
Font options |
You can define a condition with a list of two or more values for a field by using the ____ comparison operator. |
In |
The calculated expression =City & "," & State & " " & ZipCode is an example of ____. |
Concatenation |
The Like comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*, ?, #) in a query. ____________________ |
True |
Which of the following is an example of a parameter query prompt criterion? |
[Type the state:] |
Max is an example of a(n) logical function used in a crosstab query. ____________________ |
False |
In crosstab query results, the value of a checked Yes/No data type field will display as ____. |
-1 |
Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces. |
Like "704*" |
An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional. ____________________ |
False |
When creating an input mask, the ____ input mask character is used to indicate that the following character will be a literal display of that character. |
\ |
A parameter query displays a dialog box that prompts the user to enter one or more values when the query is run. ____________________ |
True |
The label attached to a bound control displays which of the following? |
the field name or Caption property |
A ____ asks a series of questions and then uses your answers to create a control in a form or report. |
Control wizard |
To create a custom form, the user may modify an existing form in Form view or Design view. |
False |
The record source for a subform must be a table. |
False |
A selected column of controls may be aligned to the left or right edges of the controls using the Arrange tab on the ribbon. |
True |
When resizing controls in Design view, the user can see actual field values while resizing the controls. _________________________ |
False |
Which button on the Format tab is used to change the background color of a control, section, or object |
Background color |
Number signs indicate that a text box has been resized too small to display the contents properly. |
True |
The number of occurrences of an expression is determined using the ____ function in a form or report. |
Count |
Tab order allows a user to navigate the label boxes in a form by pressing the Tab key on the keyboard. |
False |
Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property. |
Special effects |
Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout. |
Tabular |
The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom. |
Auto order |
Spacing around the text inside a control is determined using the ____ property. |
Control margins |
The Access tool that allows the user (or designer) to create detailed documentation of all, or selected, objects in a database is the ____. |
Documenter |
Which form tool displays data in both Form view and Datasheet view at the same time? |
Split form |
Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property. |
ControlTip text |
The Layout view or the Design view may be used to create a ____ form. |
Custom |
A value that is the result of an expression is displayed in which type of control in a form? |
Calculated |
The value of a field containing no information is a ____ value |
Null |
To avoid the display of a security warning when opening a database, place the database ____. |
In a trusted folder |
Tables used in a find unmatched query must have a common field. |
True |
Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value. |
Append only |
The office manager at Riverview Veterinary Care Center would like to create a query which displays all patients who have not yet received their yearly check up. She will use the qryAnimalsAndOwners and tblVisit table to create the query. Which type of query will most likely create the desired results? |
Find unmatched query |
To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion. |
Like |
A summarized record for each unique field value is displayed in a crosstab query. |
True |
When using the IIF function, each part of the function is separated by a colon. |
False |
Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu |
False |
The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false. |
IIF |
Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results? |
In |
A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records. |
Crosstab |
When using the IIf function, a condition is tested, and if the condition is false, the first value of the condition is returned by the function. |
False |
A nonnull field is a field that contains any data at all, including a single space. |
True |
The format field command freezes a field (column) in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet. |
False |
The input mask character ____ indicates that a letter only must be entered, and the entry is required. |
L |
Which view or tool allows the form designer the most control and precision when designing a form? |
Split form tool |
A combo box control may only be modified in form Design view. |
False |
Titles, instructions, command buttons, and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form. |
Form footer |
The caption that displays in a label cannot be changed in Design view when creating a form. |
False |
A tool used to form a group of related controls or to separate the group from other controls is the ____ tool. |
Rectangle |
To increase an object’s window size to view more of the vertical contents of the object, collapse the ____. |
Ribbon |
The expression =Sum([InvoiceAmt]) might be found in which type of control added to a form? |
Calculated control |
A selected control will display how many sizing handles? |
7 |
The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view. |
Design |
Set the ____ property to No to prevent users from using the Tab key to navigate to a control. |
Tab stop |
The Record Source property specifies the table or query on which a form is based. |
True |
A subform may be added to a main form by using the Subform/Subreport tool or by using the ____. |
Subform wizard |
Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report? |
Shift |
A control that allows users to type an entry is a(n) text box. |
True |
The Bound Column property specifies the default control used to display a field |
False |
The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key. |
Tab order |
Which symbol is used to distinguish an expression from a fieldname in a calculated control? |
= |
The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view. |
one-quarter inch |
Which button on the Format tab is used to change the background color of a control, section, or object? |
Background color |
Which Access object(s) may be used when creating a lookup field to select values? |
Table |
A criterion may be negated by using the ____ logical operator. |
NOT |
Yes/No field values are stored in an Access database as a –1 for a checked value and a 0 for an unchecked value. |
True |
In an input mask, the letter ____ indicates that a letter or digit must be entered, and the entry is required. |
A |
A pattern match selects records whose values for the designated field matches one of two or more simple condition values. |
False |
An input mask may be created for any field with the ____ or ____ data type. |
Short text, number |
The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters. |
Like |
To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion. |
Like |
The Record Source property specifies the table or query on which a form is based. |
True |
Module 5 & 6 Exam #3 REVIEW
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price