This topic contains a solution. Click here to go to the answer

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

anshika

  • Hero Member
  • *****
  • Posts: 510
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

miss_1456@hotmail.com

  • Sr. Member
  • ****
  • Posts: 289
Answer to Question 1

C

Answer to Question 2

TRUE




anshika

  • Member
  • Posts: 510
Reply 2 on: Aug 28, 2018
:D TYSM


bitingbit

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

For a complete list of videos, visit our video library