+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
What is an AutoFormat and how do you change one for an existing form?
|
AutoFormat is a predefined style for a form or report. To change it, display the form in Layout View, click the More button and choose the format to apply.
|
|
What is the purpose of the asterisk (*) in a pattern match query?
|
A wildcard that represents any string of characters in a pattern match query.
|
|
When do you use the In comparison operator?
|
To define a condition withtwo or more values.
|
|
How do you negate a selection criterion?
|
Use the Not logical operator tonegate a condition.
|
|
When do you use a parameter query?
|
When you want to prompt the user to enter the selection criterion when the query runs.
|
|
What is the purpose of a crosstab query?
|
It performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.
|
|
What are the four Query Wizards you can use to crete a new query?
|
Simple, Crosstab, Find Duplicates, Find Unmatched
|
|
What does a Find Unmatched query do?
|
It finds all records in a query or table that have no related records in a second query or table.
|
|
What is a Find Duplicates query?
|
It finds duplicate records in a query or table based on the values in one or more fields.
|
|
What happens when you set a querys Top Values Property?
|
You limit the number of records displayed in the query results.
|
|
What is a Lookup Field?
|
A field that lets you select a value from a list of possible values.
|
|
What is an Input Mask?
|
A predefined format you use to enter and desplay data in a field.
|
|
What is Property Propagation?
|
An ACCESS feature that updates control properties in objects when you modify table field properties.
|
|
What is Validation Rule Property?
|
A property that specifies the field values that users can enter in a field. EX: Use this property to specify users can only enter positive numeric values in a numeric field.
|
|
What is Validation Text Property?
|
A property that appears in a dialog box if a user violates the fields validation rule. EX:Displays a message "must be a Positive Integer"
|
