Asked by Ashia Arnold on Jul 05, 2024
Verified
All the fields selected in a(n) _____ query must match fields with the same data types in the target table.
A) Make-Table
B) Crosstab
C) Apply
D) Append
Append Query
A database query that adds records from one or more sources to the end of a table.
Data Types
Categories of data that determine the kind of data that can be stored and how it can be used, such as integers, strings, or dates.
Target Table
The specific table in a database that is designated to receive data during import, export, or query operations.
- Comprehend the operations and utilities of Append queries in the context of adding entries to tables.
Verified Answer
DP
Despicari PiratesJul 07, 2024
Final Answer :
D
Explanation :
The Append query combines data from one or more tables into another table. In order for this to work, the fields selected in the query must match fields with the same data types in the target table. The other options (Make-Table, Crosstab, Apply) are not relevant to this requirement.
Learning Objectives
- Comprehend the operations and utilities of Append queries in the context of adding entries to tables.