DEVRY BIS245 WEEK 2 QUIZ

(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:

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.