DeVrY BIS 245 All Quizzes Week 1 - 6 -
Latest
IF You Want To Purchase A+ Work
Then Click The Link Below , Instant Download
week 2
(TCO 2) How many data types
does Access recognize?
5
7
9
10
Question 2. Question :
(TCO 2) Which of the following
is used as a symbol for an entity?
Box
Diamond
Line
Triangle
Instructor Explanation: Chapter
2: Frost section of book
Points Received: 4 of 4
Comments:
Question 3. Question :
(TCO 2) Primary keys can be
created
as computer-generated fields.
from an existing single field.
from several existing fields.
All of the above
Instructor Explanation: Chapter
2: Frost section of book
Points Received: 4 of 4
Comments:
Question 4. Question :
(TCO 3) A relational table
includes the following conditions EXCEPT
IN column entries and
attributes must be the same data type.
rows must be in order.
cells contain a single data
value.
columns or attributes have a
well defined range of values.
Instructor Explanation: Week 2
Lecture
Points Received: 0 of 4
Comments:
Question 5. Question :
(TCO 3) In Access, a query
result that contained the date November 12, 2011 could have had which of the
following query criteria?
11/12/2011
12/11/2011
IN #12/11/2011#
Between #10/01/2011# And
#11/12/2011#
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 0 of 4
Comments:
Question 6. Question :
(TCO 3) Which data type will
increment automatically each time a new record is entered into a table?
AutoNumber
Currency
Date/Time
Number
Instructor Explanation: Chapter
2: Grauer section of book
Points Received:
Comments:
Question 7. Question :
(TCO 3) All of the following
are true about a property EXCEPT
a Datasheet View is used to
display properties.
referenced as an attribute.
IN changes can be made with a
property sheet.
tables, forms, queries, and
reports can have properties.
Instructor Explanation: Chapter
2: Grauer section of book
Points Received:
Comments:
Week 3
(TCO 2) In a relational
database, entities are
events.
persons.
things.
All of the above
Instructor Explanation: Chapter
3: Frost section of book
Points Received: 4 of 4
Comments:
Question 2. Question : (TCO 2)
Logical design refers to
developing a database model
that will support company operations.
developing a thorough
understanding of what needs to be done in developing a database.
translating the conceptual
design into the selected model for use in a database system.
understanding the business and
its functional areas or business processes.
Instructor Explanation: Week 3
Lecture
Points Received: 4 of 4
Comments:
Question 3. Question : (TCO 3)
Database design refers to
developing a database model
that will support company operations.
focusing on understanding the
business and its functional areas or business processes.
selecting the specific hardware
characteristics based on data storage and data access requirements.
the process of converting your
ERD into tables, and defining your rows and columns based your entities and
attributes.
Instructor Explanation: Week 3
Lecture
Points Received: 4 of 4
Comments:
Question 4. Question : (TCO 2)
A crow's foot
$ is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.
Instructor Explanation: Chapter
3: Frost section of book
Points Received: 0 of 4
Comments:
Question 5. Question : (TCO 2)
A one-to-many relationship is
a relationship that guarantees
that a record is unique.
an association between a record
and its fields.
used to describe attributes.
when a row in one table is
matched to multiple rows in a second table and a row in the second table is
matched back to a row in the first table.
Instructor Explanation: Chapter
3: Frost section of book
Points Received: 4 of 4
Comments:
Question 6. Question : (TCO 2)
An associative table is
used to identify primary keys
between tables.
a child of two parent tables
that are in a many-to-many relationship.
an integrity element within a
table relationship.
a tool that allows you to
locate an excel file.
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 4 of 4
Comments:
Week 4
(TCO 1) A storage location in a
database that holds related information is a
query.
form.
report.
table.
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 2. Question :
(TCO 2) When constructing
criteria for a query, you should use
no delimiters for number data
types.
quotes to enclose Date/Time
data types.
single quotes for number data
types.
the pound sign to enclose text
data.
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 3. Question :
(TCO 2) In Access, query
results are displayed in which view?
datasheet.
form.
recordset.
report.
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 4. Question :
(TCO 2) Access has __________
data types.
six
eight
10
12
Instructor Explanation: Chapter
2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 5. Question :
(TCO 2) All of the following
describe a many-to-many relationship in Access EXCEPT
a junction table is used.
IN many matching records are
found in each direction between tables.
may be used to connect to
Oracle and other databases.
there must be at least four
tables.
Instructor Explanation: Chapter
2: Grauer section of book
Comments:
Question 6. Question :
(TCO 2) Which of the following
statements is true about queries?
Forms and queries are actually
the same thing.
Queries can only be based on
one table
Query results are not saved
after the query is executed.
The instructions to create a
query are not stored in the database.
Instructor Explanation: Chapter
2: Grauer section of book
\
Comments:
week 5
(TCO 2) A required field that
is used in entering data is a field that
appears with a specific value.
IN can be left blank.
cannot be left blank.
is selected from a list of
values.
Comments:
Question 2. Question :
(TCO 2) An example of a lookup
is
one to a million.
2010.
AL, CA, NC, NY, TX.
IN SSN, Date, 111-22-3333, AZ.
Comments:
Question 3. Question :
(TCO 2) An input mask
allows one record to have more
than two field values.
allows the user to type a
social security number as 111223333 and it would display as 111-22-3333.
confirms that a value greater
than 100 is a valid value.
is a list of values that are
previously defined from which the user can select one item.
Comments:
Question 4. Question :
(TCO 2) Which of the following
will create a lookup field, populate the values in the field, and establish
relationships between tables?
Design View
Fields Group
Lookup List
Lookup Wizard
Comments:
Question 5. Question :
(TCO 2) To add a list of
available choices to a form, use a(n)
checkbox.
combo box.
option button.
tab control.
Comments:
Question 6. Question :
(TCO 5) A bound control
always contains a label.
contains a calculation.
must be unique and contain a
data field from another underlying source.
must contain a formula.
DEVRY BIS245 WEEK 6 QUIZ 2015 GRADED
(TCO 1) The easiest way to
create a report is to use the following report tool.
Blank Report
Report
Report Design
IN Report Wizard
Instructor Explanation: Chapter
4: Grauer section of book
Points Received: 0 of 4
Comments:
Question 2. Question :
(TCO 1) Which of the following
is NOT a Report Wizard Layout type?
Block
Outline
Stepped
Summary
Instructor Explanation: Chapter
4: Grauer section of book
Comments:
Question 3. Question :
(TCO 1) Which of the following
statements best describes the image below?
Datasheet view of the Employees
report
Design view of the Employees
report
Layout view of the Employees
report
Design view of the Employees
query
Instructor Explanation: Chapter
4: Grauer section of book
Comments:
Question 4. Question :
(TCO 1) A tabular layout
resembles a
form that you fill out.
spreadsheet.
group of index cards.
All of the above
Instructor Explanation: Chapter
4: Grauer section of book
Comments:
Question 5. Question :
(TCO 1) A tool that creates a
report through a series of dialog boxes on the Create tab is the
Blank Report.
Label Wizard.
Report.
Report Wizard.
Instructor Explanation: Chapter
4: Grauer section of book
Comments:
Question 6. Question :
(TCO 1) Modifications to a
report can be done in
Detail View.
Layout View.
Print View.
IN All of the above
Instructor Explanation: Chapter
4: Grauer section of book
Points Received: 0 of 4
Comments:
Question 7. Question :
(TCO 7) PivotTables and
PivotCharts that summarize data based on multiple sources use a
form.
query.
report.
table.
Comments:
Question 8. Question :
(TCO 7) In addition to the
detail field, the primary drop zone in a PivotTable design grid is the
column field.
filter field.
row field.
All of the above
Comments:
Question 9. Question :
(TCO 7) A bar chart is used to
display
continuous data.
data in horizontal bars.
percentages of a whole.
vertically stacked data.
Comments:
Question 10. Question :
(TCO 7) All of the following
are Aggregate Functions EXCEPT
average.
count.
select.
sum.
Comments:
No comments:
Post a Comment