|
1 | | You need to design a new Access database. The first step is to organize the smallest to largest data, also called: |
| | A) | Alphabetical design. |
| | B) | Detail structure. |
| | C) | Data design. |
| | D) | Hierarchy of data. |
| | E) | Logical order. |
|
|
|
2 | | Access is a relational database, which means that the data are organized into a collection of related: |
| | A) | Workbooks. |
| | B) | Datasheets. |
| | C) | Tables. |
| | D) | Fields. |
| | E) | Pages. |
|
|
|
3 | | In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: |
| | A) | An entity. |
| | B) | A cell. |
| | C) | A field. |
| | D) | A row. |
| | E) | A fact. |
|
|
|
4 | | A pre-designed database that contains various pre-built objects is called: |
| | A) | A template. |
| | B) | A form. |
| | C) | A layout. |
| | D) | A table. |
| | E) | A key. |
|
|
|
5 | | Tables and forms are examples of database: |
| | A) | Entities. |
| | B) | Reports. |
| | C) | Entries. |
| | D) | Objects. |
| | E) | Views. |
|
|
|
6 | | Each major subject or grouping of information you will store in your database should have a separate: |
| | A) | Form. |
| | B) | Row. |
| | C) | Sheet. |
| | D) | Column. |
| | E) | Table. |
|
|
|
7 | | When you need to create an interface to view, add, update, and delete data in Access, you should use a: |
| | A) | Form. |
| | B) | Query. |
| | C) | Report. |
| | D) | Worksheet |
| | E) | Layout. |
|
|
|
8 | | If you want create a formatted, professional way to present and print the contents of your database, you use a: |
| | A) | Layout. |
| | B) | Form. |
| | C) | Query. |
| | D) | Report. |
| | E) | Template. |
|
|
|
9 | | The last row in an Access table is called the: |
| | A) | Append Row. |
| | B) | Auto Row. |
| | C) | Selector Row. |
| | D) | Hanging Row. |
| | E) | Exit Row. |
|
|
|
10 | | In a database, the special field that contains a unique value for each record is the: |
| | A) | Primary field. |
| | B) | ID type. |
| | C) | Product number. |
| | D) | Master cell. |
| | E) | Primary key. |
|
|
|
11 | | If any of your database columns display the ###### symbols, you need to: |
| | A) | Delete the contents. |
| | B) | Widen the column. |
| | C) | Reformat the text. |
| | D) | Change to Design view. |
| | E) | Change to Data view. |
|
|
|
12 | | When you first open a table in Datasheet view, Access uses the first field to sort the data records: |
| | A) | Alphabetically. |
| | B) | In descending order. |
| | C) | In ascending order. |
| | D) | By most recent entry. |
| | E) | By oldest entry. |
|
|
|
13 | | When you want to view only certain database fields such as product type, use this function: |
| | A) | Sort |
| | B) | Filter |
| | C) | Find |
| | D) | Data view |
| | E) | Enable content |
|
|
|
14 | | You need to find both a particular product type AND a price, you can do this through: |
| | A) | compound criteria. |
| | B) | double entry. |
| | C) | find fields. |
| | D) | related records. |
| | E) | contiguous cells. |
|
|
|
15 | | Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text? |
| | A) | Sans serif |
| | B) | Unicode |
| | C) | Rich Text |
| | D) | Font style |
| | E) | Editable type |
|
|