If you have data in an Excel worksheet, what methods could you use to move the data inExcel to Access? How would you decide between the methods?

What will be an ideal response?


You could cut and paste the Excel data into an existing table, import it to append to an existing table, import it to create a new table, import it as a named range, or you can manually enter the data into Access.
• If there is an existing Access table, you would want to check that the Excel worksheet column headings are exact matches to the field names in the Access table. If the column headings and field names are identical, you would probably choose to import and append to that table. You are unlikely to cut and paste a complete worksheet for fear of pasting into the wrong fields. If the headings are not an exact match, you would need to change the Excel field names to make them match.
• If there is not an existing Access table, you could either design the table in Access and then import and append, or you could import the Excel worksheet to create the table and make changes in Access. If the Excel worksheet is close to the desired Access table, either method would work.
• If there are major differences between the desired Access table and the Excel worksheet, you might need to design the table in Access and manually enter the data. Avoid this if there is a great deal of data.

Computer Science & Information Technology

You might also like to view...

What statuses are listed?

What will be an ideal response?

Open Task Manager: Right-click the Task bar to open Task Manager.
Working in the Services Tab
a. Click the Services tab. Use the scroll bar on the right side of the Services window to view all the services listed.

Computer Science & Information Technology

You can create a(n) ____________________ animation in which you create the content for each individual frame.

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

Computer Science & Information Technology

Which of the following is a new Office 2010 feature?

A) Compressing the size of all images in a document B) Inserting symbols into a document C) Changing the contrast and brightness within the same image D) The ability to remove the background of a picture

Computer Science & Information Technology

In the figure above, which number refers to the place you would click to Save?

A. 2 B. 3 C. 4 D. 5

Computer Science & Information Technology