1. A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a_____
- Field
- Record
- Table
- Database
2. You should use Access over Excel when:
- you have a large amount of data.
- you need to create complex charts.
- you have only one worksheet to handle all of your data.
- you have extensive subtotals and totals in your worksheet.
3. Examining the image below, which statement best describes what we see?
- Six records have been filtered from a query called Employees.
- Six records have been filtered on the Title field containing Sales Representative from the Employees table.
- A table called Employees has been created from six filtered records.
- A query called Employees has been created from a filtered table.
4. Access should be used instead of Excel when
- a nonrelational view of the data is needed.
- you need to run various comparisons of statistical and comparative data.
- you need to sort, group, and total data in various views.
- you only need a smaller, manageable amount of data.
5. On which tab is the Sort & Filter group found?
- File
- Home
- Create
- External Data
6. In using a web search engine, typing the web site address in the proper place in the brower and then hitting enter is called
- server setup.
- presentation task.
- client browsing.
- systems application.
7. Types of relationships between tables do NOT include
- one-to-one
- many-to-many
- primary-to-foreign
- many-to-one
8. To display a subset of records based on certain criteria, use which of the following?