Question

devry bis245 week 2 Quiz latest 2016 may

1. Question : (TCO 2) When building a database, you should first

create and input the design of the table and reports at the same time.

determine the input and then design the tables.

determine the output and then design the tables.

input the data and then design the reports.

Question 2. Question : (TCO 2) All of the following describe a large database system EXCEPT

different users may have different levels of access to data in the database.

simultaneous logging into a database is not recommended.

multiple users in the database are common.

the database could be split into a front and back end.

Question 3. Question : (TCO 2) Columns in an Access table are called

fields.

records.

relation.

tuples.

Question 4. Question : (TCO 3) A relational table includes the following conditions EXCEPT

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.

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

#12/11/2011#

Between #10/01/2011# And #11/12/2011#

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

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.

changes can be made with a property sheet.

tables, forms, queries, and reports can have properties.

Question 8. Question : (TCO 4) Which of the following is NOT an example of a primary key?

ISBN number for a textbook

Last name

Social Security Number

Student ID

Question 9. Question : (TCO 4) Which of the following is NOT an Access data type?

Text

Currency

Name

Date/Time

Question 10. Question : (TCO 2) In Access, which item below is NOT considered a logical operator?

Equal

And

Not

Or