BIS155 Course Discussions Week 4

$4.50

BIS155 Course Discussions Week 4
Excel 2010 provides the capability to exchange data with other applications…

SKU: BIS155 Excel Data Exchange Categories: , Tags: , , ,

Description

BIS155 Course Discussions Week 4

BIS155 Course Discussions Week 4

All Students Posts – 30 Pages 

Excel Data Exchange

Excel provides the capability to exchange data with other applications.  Discuss the different types of ways to exchange data between Excel and other Microsoft applications.  Are there limitations to the exchange process?  How can you exchange data with other applications that are not part of the Microsoft Office Suite?  Discuss how you would exchange data with external data sources such as websites. There are several ways to exchange data between Microsoft Access and Microsoft Excel.  Describe a business scenario where it might be important to have these two popular pieces of software share data?

There are several ways to exchange data between Microsoft Access and Microsoft Excel. To bring data into Excel from Access, you can copy data from an Access datasheet and paste it into an Excel worksheet, connect to an Access database from an Excel worksheet, or export Access data into an Excel worksheet.

To bring data into Access from Excel, you can copy data from an Excel worksheet and paste it into an Access datasheet, import an Excel worksheet into an Access table, or link to an Excel worksheet from an Access table…