1. (TCO 2) How many data types does Access recognize? (Points : 4)
5
7
9
10
Question 2. 2. (TCO 2) All of the following describe a large database system EXCEPT (Points : 4)
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. 3. (TCO 2) A single crow’s foot at the left-most end of a relationship line would signify a
(Points : 4)
many-to-many relationship.
one-to-many relationship.
one-to-one relationship.
no relationship.
Question 4. 4. (TCO 3) A relational table includes the following conditions EXCEPT (Points : 4)
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. 5. (TCO 3) In Access, a query result that contained the date November 12, 2011 could have
had which of the following query criteria? (Points : 4)
11/12/2011
12/11/2011
#12/11/2011#
Between #10/01/2011# And #11/12/2011#
Question 6. 6. (TCO 3) A Text data type has a maximum character size of (Points : 4)
50.
200.
255.
limited only by memory
Question 7. 7. (TCO 3) All of the following are true about the Indexed property EXCEPT (Points : 4)
an example of a setting is Yes (Duplicates OK).
indexed records are scanned sequentially.
indexing a table speeds the retrieval time.
primary keys must be indexed.
Question 8. 8. (TCO 4) Which of the following is NOT an example of a primary key? (Points : 4)
ISBN number for a textbook
Last name
Social Security Number
Student ID
Question 9. 9. (TCO 4) Which of the following is NOT an Access data type? (Points : 4)
Text
Currency
Name
Date/Time
Question 10. 10. (TCO 2) In Access, which item below is NOT considered a logical operator? (Points :
4)
Equal
And
Not
Or
