multi 2

question_2.docx

Home >Environmental science homework help >multi 2

Question 1.1. (TCO 2) To create a relationship between two tables, you need at least a (Points : 4)

data type. query. hyperlink. primary key.

Question 2.2. (TCO 2) Which of the following does NOT describe a many-to-many relationship? (Points : 4)

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.3. (TCO 2) Columns in an Access table are called (Points : 4)

fields. records. relation. tuples.

Question 4.4. (TCO 3) Queries can do all of the following EXCEPT (Points : 4)

display specific records from tables and other queries. perform calculations. provide parameters at run time. run from a table Datasheet View.

Question 5.5. (TCO 3) Relational table and relationship have different meanings; the difference is (Points : 4)

relationships focus on query filters while relational tables focus on filters only. that there really is no difference. a relational table defines a logical association between two relationships. relational table is a two-dimensional structure while the relationship defines an association between the tables.

Question 6.6. (TCO 3) Which data type will increment automatically each time a new record is entered into a table? (Points : 4)

AutoNumber Currency Date/Time Number

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) All of the following make good candidates for a field on an employee table EXCEPT (Points : 4)

Employee ID. Hire date. Last name. Name.

Question 9.9. (TCO 4) Storage space for a field is reserved with the (Points : 4)

PNPI. field size property. indexed property. validation rule property.

Question 10.10. (TCO 2) What is the special character called to represent one or more characters in the Criteria area of a query? (Points : 4)

Delimiter Operand Wildcard Operator