Assignment

Question 1. How many data types does Access recognize?
Five
Seven
Nine
10

Question 2. Which of the following does NOT describe a many-to-many relationship?
There must be at least two tables.
Many matching records exist in each direction between the tables.
A junction table is used.
You can connect to tables in other databases such as Oracle.

Question 3. SQL is
nonprocedural and record oriented.
nonprocedural and table oriented.
procedural and object oriented.
procedural and record oriented.

Question 4. 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. Which of the following is true regarding the use of delimiters in a field criterion in Access?
Date/Time data types need no delimiters.
Date/Time data types need to be enclosed in single quotes.
Number data types require no delimiters.
Text data types require pound signs.

Question 6. A Text data type has a maximum character size of
50.
200.
255.
Limited only by memory

Question 7. All of the following are true about the Indexed property EXCEPT
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. 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. To ensure that a value of 15 or greater was entered into a field, you would use a
field size.
field type.
Sarbanes-Oxley Act.
validation rule.

Question 10. What is the special character called to represent one or more characters in the Criteria area of a query?
Delimiter
Operand
Wildcard
Operator.