|
1 | | The best way to maintain data in an Access table will depend on all of the following except |
| | A) | the frequency of updates. |
| | B) | personal preferences. |
| | C) | the design features that have been applied. |
| | D) | the size of the records. |
|
|
2 | | When a sort field has multiple rows with the same value, this is needed to organize records with the same value in the primary sort field. |
| | A) | Secondary record |
| | B) | Secondary value |
| | C) | Secondary sort |
| | D) | Secondary find |
|
|
3 | | When using the Microsoft Office Clipboard to update Access data, the data is placed on the clipboard with this name as well as the copied contents. |
| | A) | Record |
| | B) | Field |
| | C) | Form |
| | D) | Value |
|
|
4 | | This is not one of the tips provided for defining fields in a database. |
| | A) | Assign a primary key to each table |
| | B) | Define relationships to establish table subjects |
| | C) | Each field must directly describe the subject of the table |
| | D) | Store data in its smallest logical part |
|
|
5 | | Which of the following is not correct with regard to field names in Microsoft Access? |
| | A) | Field names can contain control characters. |
| | B) | Field names cannot start with a space. |
| | C) | Field names can be up to sixty-four characters long. |
| | D) | Field names can include any combination of letters, numbers, spaces, and special characters except a period, an exclamation point, an accent grave, and brackets. |
|
|
6 | | In Access, field size determines all of the following except |
| | A) | how much storage space it requires. |
| | B) | how fast it processes. |
| | C) | the type of record allowed. |
| | D) | the maximum value a field can store. |
|
|
7 | | For fields with this data type, the field size can be set from 0 to 255 characters, and the default text field size is 50 characters. |
| | A) | Record |
| | B) | Form |
| | C) | Value |
| | D) | Text |
|
|
8 | | This is not one of the attributes common to all data types in Access. |
| | A) | Record |
| | B) | Validation |
| | C) | Caption |
| | D) | Default Value |
|
|
9 | | In Access, this attribute holds the rules that govern what data is valid for the field. |
| | A) | Default Value |
| | B) | Required |
| | C) | Indexed |
| | D) | Validation |
|