Tech.Note.Analyze

Tech.Note.Analyze - in the Access table. If you change or...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
The operation “analyze” Frequently the work book will instruct you to “analyze” a table in Excel. My sense of this operation is that it is the equivalent of a copy and paste. For a table or query, you would simply execute the query and then, while the “table” is in front of you, select the rows and columns that you want in Excel and move to the other application and do a paste into and empty worksheet. Note that this is a copy of the data
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: in the Access table. If you change or update the Access data, you would have to make corresponding changes in Excel. See Technical Note #1 for a method of linking the two together. I have located the following information in the help files for Access where the analyze operation is mentioned....
View Full Document

This note was uploaded on 04/22/2010 for the course BUS 255 taught by Professor Mcgee during the Spring '10 term at Aarhus Universitet.

Ask a homework question - tutors are online