(CO 1) A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a

   

field.

 

   

record.

 

Correct!

   

table.

 

   

database.

 

 

Question 2

5 / 5 pts

(CO 1) Which statement is NOT true?

  

A relationship is a connection between two tables using a common field.

 

Correct!

   

A primary key is used to identify common fields in a table.

 

  

Multiple users on different computers can work on a database simultaneously.

  

Access speed measures the time it takes for a storage device to make the file content available for use.

 

Question 3

5 / 5 pts

(CO 1) 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.

 

Correct!

   

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.

 

 

Question 4

5 / 5 pts

(CO 1) 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.

Correct!

   

you need to sort, group, and total data in various views.

 

   

you only need a smaller, manageable amount of data.

 

 

Question 5

5 / 5 pts

(CO 1) 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's records are being shown. On the lower tool bar, the numbers are 3 of 9.

 

   

Datasheet

 

   

Design

 

Correct!

   

Form

 

   

Report

 

 

Question 6

5 / 5 pts

(CO 2) To add, delete, and edit a record, use

Correct!

   

datasheet view of a table.

 

   

design view of a table.

 

   

design view of a query.

 

   

report view.

 

 

Question 7

5 / 5 pts

(CO 2) 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.

 

Correct!

   

determine the output and then design the tables.

 

   

input the data and then design the reports.

 

 

Question 8

5 / 5 pts

(CO 1) Excel should be used instead of Access when

Correct!

   

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.

 

Quiz Score: 40 out of 40

PreviousNext

Submission Details:

 

SmartExpert

(118)

Status NEW Posted 02 Mar 2019 04:03 PM My Price 5.00

BIS----------- 24-----------5 W-----------eek----------- 1 -----------Qui-----------z A-----------nsw-----------er-----------

Attachments

file 1551544894-BIS 245 Week 1 Quiz Answer.docx preview (364 words )

(-----------CO -----------1) -----------A c-----------oll-----------ect-----------ion----------- of----------- cu-----------sto-----------mer----------- in-----------for-----------mat-----------ion----------- an-----------d p-----------urc-----------has-----------e t-----------ran-----------sac-----------tio-----------ns -----------tha-----------t m-----------igh-----------t b-----------e s-----------tor-----------ed -----------in -----------bot-----------h A-----------cce-----------ss -----------and----------- Ex-----------cel----------- wo-----------uld----------- be----------- ca-----------lle-----------d a----------- Â----------- Â ----------- f-----------iel-----------d. -----------  ----------- Â----------- Â ----------- r-----------eco-----------rd.----------- Â-----------  -----------Cor-----------rec-----------t! -----------  -----------  ----------- ta-----------ble-----------. -----------  -----------  -----------  ----------- da-----------tab-----------ase-----------. -----------  -----------  ----------- Q-----------ues-----------tio-----------n 2----------- 5----------- /----------- 5Â----------- pt-----------s -----------(CO----------- 1)----------- Wh-----------ich----------- st-----------ate-----------men-----------t i-----------s N-----------OT -----------tru-----------e? -----------  ----------- A----------- re-----------lat-----------ion-----------shi-----------p i-----------s a----------- co-----------nne-----------cti-----------on -----------bet-----------wee-----------n t-----------wo -----------tab-----------les----------- us-----------ing----------- a -----------com-----------mon----------- fi-----------eld-----------. -----------  ----------- Co-----------rre-----------ct!----------- Â----------- Â ----------- A----------- pr-----------ima-----------ry -----------key----------- is----------- us-----------ed -----------to -----------ide-----------nti-----------fy -----------com-----------mon----------- fi-----------eld-----------s

Not Rated(0)

• Buy Answer