Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Watch this: Create an Access database/Excel workbook solution
 
Mark Gillis

The following five demos work together and show how to create your own database/workbook solution, step-by-step. For background information, see Top 10 reasons to use Access with Excel.

Activity Description
Callout 1 
Show me Thumbnail Copy Excel customer data to Access, and then create a simple report by using the Report Wizard.
Callout 2 
Show me Thumbnail Link to Excel customer data from Access, and then create a detailed report by using Report Layout view in Access.
Callout 3 
Show me Thumbnail Import the Excel customer data into Access, delete the data from Excel, connect to the data in Excel, and then create a Split Form in Access.
Callout 4 
Show me Thumbnail Collect new data from Access by using Outlook, create a query of customer addresses, and then create a mailing label report.
Callout 5 
Show me Thumbnail Create a working database/workbook solution with a startup form and links to reports in Access.


Assistance Problems watching the video? Try our troubleshooting tips.
advertisement