Support / Access / Access 2007 Help and How-to / Access Demos

Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

Watch this: Create an Access database/Excel workbook solution

Applies to: Microsoft Office Access 2007, Excel 2007

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
Show me	Copy Excel customer data to Access, and then create a simple report by using the Report Wizard.
Show me	Link to Excel customer data from Access, and then create a detailed report by using Report Layout view in Access.
Show me	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.
Show me	Collect new data from Access by using Outlook, create a query of customer addresses, and then create a mailing label report.
Show me	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.