Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
1) A ________ is a question you ask about data stored in a database.
A) query B) form C) report D) macro |
A) query
|
|
2) You can click the ________ button on the table toolbar to sort records in alphabetical order, from A to Z. A) form B) descending C) order D) ascending
|
D) ascending
|
|
3) A form can best be described as a(n):
A) record. B) object. C) attribute. D) table. |
B) object
|
|
6) A relational database is a collection of: A) forms. B) field values. C) common fields. D) related tables.
|
D) related tables.
|
|
7) A primary key:
A) must include letters. B) must contain a unique value for each record within the table. C) has the same value for all records. D) is not usually necessary. |
B) must contain a unique value for each record within the table.
|
|
9) Access differs from other Microsoft software because it:
A) works primarily from memory. B) works primarily from storage. C) does not save your work as soon as changes are made. D) does not allow more than one user to work on a file at a time. |
B) works primarily from storage.
|
|
12) Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:
A) create a query. B) create a new table. C) create a form. D) create a report. |
A) create a query
|
|
13) Selecting data by means of a query:
A) deletes unrelated data. B) displays only the data that matches the query selection criteria. C) locks all other users out of the database. D) creates a report. |
B) displays only the data that matches the query selection criteria.
|
|
25) When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:
A) you need to create complex charts or graphs. B) you require multiple tables to manage data. C) you are managing a large quantity of data. D) multiple users need to work with data simultaneously. |
A) you need to create complex charts or graphs.
|
|
26) When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:
A) you only need a single worksheet to manage data. B) you need to manage primarily numeric data. C) you need to run a series of "what if" scenarios . D) you need to group, sort, and total data based on various parameters. |
D) you need to group, sort, and total data based on various parameters.
|
|
32) The ________ view in Access looks similar to an Excel Spreadsheet.
A) Report B) Form C) Datasheet D) Design |
C) Datasheet
|
|
37) A ________ displays a subset of records based on specified criteria.
A) filter B) form C) table D) primary key |
A) filter
|
|
43) A complete set of data elements within a table is called a record.
|
Answer: TRUE
|
|
44) A database is a collection of one or more related tables.
|
Answer: TRUE
|
|
49) A form can be used to make users view or edit only one record at a time.
|
Answer: TRUE
|
|
60) When making a change to an Access database, you must first save the change in order for the change to take effect.
|
Answer: FALSE
|