When deciding whether or not to use a multivalued filed in an Access database, what limitations of using multivalued fields should be given careful thought?

What will be an ideal response?


Student answers will vary but should contain each of these limitations.
1. Records cannot be sorted on values stored in mulivalued fields in queries, forms, or reports (except in special circumstances.)
2. Multivalued fields do not convert to a DBMS (such as SQL Server or Oracle) properly.

Computer Science & Information Technology

You might also like to view...

A ________________ occurs when computing the MD5 algorithm with two different initialization vectors produces the same hash value.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The primary benefit of offshoring and outsourcing is cost savings

Indicate whether the statement is true or false

Computer Science & Information Technology

A(n) ________ is a key that identifies the color, gradient, picture, texture, or pattern of each data series in a chart

A) legend B) label C) axis D) trendline

Computer Science & Information Technology

Answer the following statement(s) true (T) or false (F)

1. RSLogix 5000 software has no predefined data files as found in traditional PLCs. 2. ControlLogix's basic allocation of memory for any tag is a nibble. 3. The Style setting in the Edit Tags view defines the radix in which the tag's information is displayed in an instruction. 4. Once an alias tag is established, always select it to be consistent when programming. 5. Dissimilar data types can be grouped together in an array to better utilize memory allocation.

Computer Science & Information Technology