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:

Devry BIS245 Week 1Quiz Latest 2015 October1. 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 October1. 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 October3. 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: