Sharing Data with Other Programs from within Access 2013

Part of the Access 2013 All-In-One For Dummies Cheat Sheet

Access 2013 is a great database application on its own, but it also plays well with others, allowing you to display and retrieve data from several other programs. If a program supports Visual Basic for Applications (VBA), you can control it from Access. Here’s a brief list of applications that you can take control of and share data with:

  • Microsoft Excel: Many users of Excel end up getting involved with Access because they need more structure for storing their data. Some of these people don’t make the leap to Access, however, so a strong tie still exists between Access and Excel. You can use an Excel spreadsheet as a table in Access or completely take control of an Excel application from VBA.

  • Microsoft SQL Server: SQL Server is like Access on steroids — at least from the table and query standpoint. You can move your data from Access to SQL Server to improve speed and performance when you’re using large amounts of data. After the data is in SQL Server, you can build your Access forms, reports, macros, and modules to use the data from SQL Server.

  • Microsoft Word: Most people who use Access have also used Word. Whether you’re writing a letter or making a list of tasks to do, Word is where you may be used to turning. You can also use Word as a reporting tool, where you can create bookmarks to place data from Access and someone else — who may be unfamiliar with Access — can edit the other information in the Word document.

  • Microsoft SharePoint: SharePoint is Microsoft’s vision for sharing and collaborating with data on the web. From Access 2013, you can share data with a SharePoint server. You can even create a custom web app that stores Access tables, queries, forms (as views), and macros on a SharePoint 2013 server and allows you or anyone else to access these forms on the web — all without having Access 2013 installed.

  • Microsoft Outlook: Outlook is more than just an e-mail tool; it’s also a contact management system. You can share contact, calendar, and task information with your Access application so that you have to enter it in only one place.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Access 2013 All-In-One For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.