Solved by verified expert :quizesweek 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:
Question 7. Question
: (TCO 3) Data validation refers
to
a set of constraints that helps control
illegal data entry.
correcting data errors after they are entered
into a table.
duplicating a primary key in a table.
typing data accurately into a table.
Instructor Explanation: Chapter 2:
Grauer section of book
Points Received: 4 of 4
Comments:
Question 8. Question
: (TCO 4) What Access data type
would you use to store $23.58?
Calculated
Currency
Money
Number
Instructor Explanation: Chapter 1:
Grauer section of book
Points Received: 4 of 4
Comments:
Question 9. Question
: (TCO 4) Which is NOT true of
validation rules?
They enforce a size limit.
They check authenticity of data entered in a
field.
An error message will appear if a rule is
violated.
They protect from fraudulent practices.
Instructor Explanation: Chapter 2:
Grauer section of book
Points Received: 4 of 4
Comments:
Question 10. Question
: (TCO 4) Which question is part
of a requirements analysis?
What is the organization’s structure and core
business?
What are the existing problems with the
current database?
Will the database interface with other
systems?
All of the above.
Instructor Explanation: Week 3 Lecture
Points Received: 4 of 4
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.
Comments:
Question 7. Question
:
(TCO 5) Which statement below best describes how designers
and users work with forms?
IN
The designer and the users will
edit and update forms.
The
designer of a form will make it functional and easy to use the first time.
The
designer of a form will need to keep revising a form as suggested by the users.
The
designer and users will never need to edit a well designed form.
Comments:
Question 8. Question
:
(TCO 5) If you click on the form tool, you will open a(n)
existing
form.
new
form in design view.
new
form in layout view.
wizard
to design a form.
Comments:
Question 9. Question
:
(TCO 5) In the design view of a form, which of the following
would NOT be performed?
IN
Add calculations, controls,
pictures, and lines.
Change
the size of a form section.
Enter
a data value.
Modify
the properties of the form.
Comments:
Question 10. Question
:
(TCO 5) A data macro
executes
a series of actions when a table event occurs or whenever a named macro is
executed.
identifies
fields to compare.
is
a switchboard.
is
a table event.week 6
Question
Offered Price
$11.00
DEVRY BIS245 WEEK 6 QUIZ 2015 GRADED 100 % CORRECT
Question # 00050010 Subject: Computer Science / General Computer Science Due on: 02/28/2015 Posted On: 02/22/2015 08:23 AM
Posted By:
spqr
Questions:6235
Tutorials:6139
Spent$0.00
Earned$42,758.63
Feedback Score:
96% (1384 ratings)
Send Message
Report this Question as Inappropriate
Question
(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: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:
Question 8. Question
:
(TCO 4) Which of the following is NOT true of a hire date
field?
A
hire date is considered a constant.
A
hire date would be defined as a date/time field.
IN Date arithmetic can be applied to a
hire date field.
The
years of service field, which shows how long an employee has been with the
company.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received:
Comments:
Question 9. Question
:
(TCO 4) Storage space for a field is reserved with the
PNPI.
field
size property.
indexed
property.
validation
rule property.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received:
Comments:
Question 10. Question
:
(TCO 2) In Access, which item below is NOT considered a
logical operator?
Equal
And
Not
Or
Instructor Explanation: Chapter 2: Grauer section of book
Points Received:
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:
Question 7. Question
:
(TCO 2) When building a calculated field, formulas can be
created using the
IN Form Wizard.
Expression Builder.
Report
Builder.
Table
Wizard.
Instructor Explanation: Chapter 3: Grauer section of book
Comments:
Question 8. Question
:
(TCO 2) A primary key
can be computer generated.
consists
of one field only that uniquely identifies each record in a table.
is
a relationship between two or more tables.
IN All of the above
Instructor Explanation: Chapter 2: Grauer section of book
Points Received: 0 of 4
Comments:
Question 9. Question
:
(TCO 6) Which of the following does NOT describe data
redundancy?
The
same data exists in multiple tables.
The data is always in linked
tables.
Data
updating must be done in multiple table locations.
Data
redundancy can result in data anomalies.
Instructor Explanation: Chapter 2: Grauer section of book
Comments:
Question 10. Question
:
(TCO 6) A make table query
creates the structure of a table
but does not populate the table with records.
is
another name for an append query.
selects records from one or more
tables and uses them to create a new table.
requires
the destination table to exist first.
