DeVry BIS 245 Week 1 Quiz
Question 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.
Question 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.
Question 3
To create a filtered list on a particular field in a record,
- Click on the home tab, advanced filter, and then filter by form.
- Click on the home tab, filter, and then the find option.
- Click on the home tab, filter, selection, and then pick your criteria.
- right-click on an item in your field column and then click sort.
General Feedback:
See Chapter 1: Grauer section of the book.
Question 4
To locate the tool to compact an Access database, click on the
- File tab, options, current database, and select compact and repair database tools.
- home tab, advanced, and select compact and repair database tools.
- database tools tab, and select compact and repair database tools.
- external data tab, and select compact and repair database tools.
General Feedback:
See Chapter 1: Grauer section of the book.
Question 5
Which view best describes the image below?
Image Description
This is a picture from the Access program with the Home tab selected. The file that is shown is the Employee Form with fields shown for First Name, Last Name, Title, Reports to, Hire Date and Education along with a picture of the employee who records are being shown. On the lower toolbar, the numbers are 3 of 9.
- Datasheet
- Design
- Form
- Report
Question 6
To add, delete, and edit a record, use
- the datasheet view of a table.
- design view of a table.
- design view of a query.
- report view.
Question 7
When building a database, you should first
- create and input the design of the table and reports at the same time.
- determine the input and then design the tables.
- determine the output and then design the tables.
- input the data and then design the reports.
Question 8
Excel should be used instead of Access when
- you have a small amount of data.
- your data needs to be regrouped in various views.
- your data needs connectivity to external databases.
- your data requires a relational database.