Author Question: Which of the following is NOT true when copying and pasting data from Excel into Access? A) There ... (Read 67 times)

anshika · **on:** Aug 28, 2018

Which of the following is NOT true when copying and pasting data from Excel into Access?

A) There cannot be missing columns or columns in different orders between the two files.
B) Copying and pasting requires that the columns be exactly the same in Excel and Access.
C) If you have any doubt about the data being compatible, use the Append feature to add the data to the table.
D) You cannot paste fields that are nonnumeric into numeric fields.

Question 2

When you click the Run icon in the Design tab of the Ribbon to run an Update query, a warning box will appear indicating the number of records that will be changed.

Indicate whether the statement is true or false