Term
|
Definition
A collection of records for a single subject, such as all of the customer records, is called a(n) ____. |
|
|
Term
|
Definition
A(n) ____________________ object provides an easy-to-use data entry screen. |
|
|
Term
|
Definition
A(n) ____________________ object provides an easy-to-use data entry screen. |
|
|
Term
|
Definition
An Access database is able to store any number of records up to ____________________ gigabytes. |
|
|
Term
|
Definition
An Access database may be as large as 200 gigabytes.
True or False? |
|
|
Term
|
Definition
If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.
True or False? |
|
|
Term
|
Definition
In Access, data entry screens are called forms.
True or False? |
|
|
Term
|
Definition
| Microsoft Office Access can best be described as ____ software. |
|
|
Term
|
Definition
| Microsoft Office Access can best be described as ____ software. |
|
|
Term
|
Definition
| Press this keystroke combination to move focus to the last field of the last record. |
|
|
Term
|
Definition
Pressing [Ctrl][;] will insert the current date.
True or False? |
|
|
Term
|
Definition
Tables contain all of the data in the database.
True or False? |
|
|
Term
|
Definition
| Tables, queries, and modules are examples of Access ____. |
|
|
Term
|
Definition
| The [Esc] key will only affect the current field being edited. True or False? |
|
|
Term
|
Definition
The [F2] key switches between Edit and Navigation modes.
True or False? |
|
|
Term
|
Definition
The navigation bar is found at the top of the datasheet.
True or False? |
|
|
Term
|
Definition
| The Navigation buttons on a datasheet display the total number of fields in the datasheet. True or False? |
|
|
Term
|
Definition
| This Access object provides an easy-to-use data entry screen. |
|
|
Term
|
Definition
Values in an AutoNumber field cannot be edited.
True or False? |
|
|
Term
|
Definition
| When creating a database using an Access template, you must remember that field names cannot be altered later. True or False? |
|
|
Term
|
Definition
| When creating a database using an Access template, you must remember that field names cannot be altered later. True or False? |
|
|
Term
|
Definition
| Which data type is used to sequentially order each record added to a table? |
|
|
Term
|
Definition
| Which data type stores Web addresses? |
|
|
Term
Calculations on groups of records |
|
Definition
| Which is NOT a feature of Access reports? |
|
|
Term
| The ability to enter data through a data entry screen |
|
Definition
| Which is NOT a feature of Access reports? |
|
|
Term
|
Definition
| Which of the following is not a Data Type? |
|
|
Term
|
Definition
| Which shortcut key moves focus to the first field of the current record? |
|
|
Term
|
Definition
| E. First field of the current record |
|
|
Term
|
Definition
| B. Next field of the current record |
|
|
Term
|
Definition
| F. Last field of the current record |
|
|
Term
|
Definition
| A. Previous field of the current record |
|
|
Term
|
Definition
| D. Last field of the last record |
|
|
Term
|
Definition
| C. Current field of the previous record |
|
|
Term
|
Definition
| H. First field of the first record |
|
|
Term
|
Definition
| G. Current field of the next record |
|
|
Term
|
Definition
| A table contains all of the raw data within the database. |
|
|
Term
|
Definition
| A query is a method of asking questions about the data. |
|
|
Term
|
Definition
| A form provides a convenient way to enter data. |
|
|
Term
|
Definition
| A report is a customized format for printing data from one or more tables. |
|
|
Term
| What are the advantages of database software such as Access over spreadsheet software such as Excel? |
|
Definition
1. Data entry is faster and easier.
2. Information is more accurate, reliable and consistent. 3. Information can be viewed and sorted in multiple ways.
4. Information is more secure.
5. Information can be shared among several users.
6. Duplicate data entry is minimized. |
|
|
Term
|
Definition
Press this keystroke combination
to move focus to the last field
of the last record. |
|
|
Term
|
Definition
This Access object provides an
easy-to-use data entry screen. |
|
|
Term
|
Definition
| Microsoft Office Access can best be described as ____ software. |
|
|
