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

Show me 

Thumbnail

Copy Excel customer data to Access, and then create a simple report by using the Report Wizard.

Show me 

Thumbnail

Link to Excel customer data from Access, and then create a detailed report by using Report Layout view in Access.

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.

Show me 

Thumbnail

Collect new data from Access by using Outlook, create a query of customer addresses, and then create a mailing label report.

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.

 
 
Applies to:
Access 2007, Excel 2007