Which of the following regarding complex update queries is FALSE?
A) Some of the data in the destination fields may be truncated.
B) If you update data from one table to another and use compatible data types instead of matching data types, Access converts the data types of the fields in the destination table.
C) The data types for both the source and destination fields must match and be compatible.
D) First begin with a select query that identifies the records to be updated and then change the query to an update query and click Run.
C
You might also like to view...
Describe three factors that may result in worksheet errors.
What will be an ideal response?
Write a recursive ternary search algorithm that splits the array into three parts instead of the two parts used by a binary search.
What will be an ideal response?
The ________ tab in the Object dialog box allows you to embed an existing PowerPoint file
Fill in the blank(s) with correct word
Which of the following statements best describes data hiding?
A. Mechanism used to ensure that information available at one processing level is not available at another level. B. A process operation that is divided into layers by function. C. The process of segmenting the memory into protected segments. D. A design objective in which each process has its own address space.