click below
click below
Normal Size Small Size show me how
Access Unit 4 NP
New Perspectives textbook Access Unit 4
Question | Answer |
---|---|
A picture is one of many of "these things" you can add to and modify on a form. | controls |
This type of formatting changes based on certain criteria. | conditional |
A search value can be an exact value or it can contain one of these characters: | wildcard |
This wildcard character will match any single alphabetical character. | question mark |
This wildcard character will match any number of characters. | asterisk |
Typing this criteria will give results that start with the letter m and have any number of letters after it. | m* |
This search criteria will match words that end in AND | *and |
This search criteria will match words that start with M and end with N but could have any single middle letter. | m?n |
To find the names Johnson, Johnston, and Johnstone in form records, type this criteria: | Johns* |
Use this view to view, enter, and maintain data in the table on which a form is based: | Form |
To change a form's appearance, you can easily apply a new: | theme |
Which would be found with the criteria-- a?n --ant, awn, awning, or swan | awn |
Before applying a conditional format, you must select a: | field value box |
To locate a particular customer record and view it in the form, you would use this cmomand to locate the form: | Find |
In this view, you cannot make any design changes to a form: | Form |
Maintaining data using a form is sometimes easier than using this table view because you can focus on all the changes for a single record at one time: | datasheet |
When setting conditional formatting options, you are actually creating a: | rule |
The first button at the bottom of the form on form view goes to this place when clicked: | first record |
The second button at the bottom of the form on the form view goes to this place when clicked: | previous record |
It is possible to attractively format Access tables or forms for printing by creating these: | reports |