Devry BIS245 Week 1,2 4,5 & 6 Quiz Latest 2015 October

Devry BIS245 Week 1Quiz Latest 2015 October

1. Question : (TCO 1) A database that organizes data in a set of overlapping tables is which of the following?

Student Answer: Flat-file

Hierarchical

Object-oriented

Relational

Comments:

Question 6. Question : (TCO 2) In using a web search engine, typing the web site address in the proper place in the brower and then hitting enter is called

Student Answer: server setup.

presentation task.

client browsing.

systems application.

Comments:

Question 8. Question : (TCO 1) You should use Excel over Access when:

Student Answer: you have a large amount of data.

you need to group, sort, and total data based on various parameters.

you need multiple related tables to store data.

you require a series of what if scenarios on your data.

Comments:

Devry BIS245 Week 2 Quiz Latest 2015 October

2. Question : (TCO 2) Which of the following does NOT describe a many-to-many relationship?

Student Answer: There must be at least two tables.

Many matching records exist in each direction between the tables.

A junction table is used.

You can connect to tables in other databases such as Oracle.

Comments:

Question 4. Question : (TCO 3) Queries can do all of the following EXCEPT

Student Answer: display specific records from tables and other queries.

perform calculations.

provide parameters at run time.

run from a table Datasheet View.

Comments:

Question 5. Question : (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?

Student Answer: Date/Time data types need no delimiters.

Date/Time data types need to be enclosed in single quotes.

Number data types require no delimiters.

Text data types require pound signs.

Comments:

Question 10. Question : (TCO 2) What is the special character called to represent one or more characters in the Criteria area of a query?

Student Answer: Delimiter

Operand

Wildcard

Operator

Comments:

Devry BIS245 Week 4 Quiz Latest 2015 October

1. Question : (TCO 1) Data aggregates

Student Answer: are used to perform calculations on individual records in a table or query.

cannot be used in a report.

perform calculations on entire columns of data.

return multiple values.

Comments:

Question 7. Question : (TCO 2) A function used to isolate a specific portion of a date such as year, month, or day in a date field is

Student Answer: Date.

DateDiff.

DateParse.

DatePart.

Comments:

Devry BIS245 Week 5 Quiz Latest 2015 October

3. Question : (TCO 2) Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is

Student Answer: >.

".

'.

<>.

Comments:

Question 4. Question : (TCO 2) Which of the following below will provide the current computer data as a default?

Student Answer: --/--/--

CurrentDate()

Date

Date()

Comments:

Question 5. Question : (TCO 2) An input mask placed on a form will apply to

Student Answer: all forms based on that table.

all forms in the database.

all forms based on that table and the table itself.

that specific form only.

Comments:

Question 6. Question : (TCO 5) To edit a form, use the

Student Answer: design view.

datasheet view.

layout view.

layout view or design view.

Comments:

Question 8. Question : (TCO 5) All of the following are form creation tools EXCEPT

Student Answer: blank form.

form design.

form layout.

form wizard.

Comments:

Question 9. Question : (TCO 5) The title for a form should be placed in the

Student Answer: details area.

form header.

textbox in the details area.

textbox in the form header.

Comments:

Devry BIS245 Week 6 Quiz Latest 2015 October

2. Question : (TCO 1) A report footer

Student Answer: is used to print page numbers on the report.

prints group statistics at the end of the report.

prints grand totals at the end of the report.

All of the above

Comments:

Question 4. Question : (TCO 1) The following steps will create a report.

Student Answer: Set focus on a table or query object, click on the Create tab, then click the Report button in the Reports group.

Set focus on a table or query object, click on the Design tab, open the table or query object, then click Design Report.

Click on the Create tab, select the Report Wizard, select your tables or queries, and then your fields.

Click on the Table tab, select your fields, and then click the Finish button.

Comments:

Question 6. Question : (TCO 1) The expression "= [Price] * [Quantity]" would most likely be found in

Student Answer: a bound control.

a calculated control.

a label control.

an unbound control.

Comments:

Question 10. Question : (TCO 7) Based on the values in aggregate data, a calculated total field in a PivotTable

Student Answer: allows for grouped data.

generates a new field.

provides for Average, Standard Deviation, and Sum totals.

All of the above

Comments: