Inserting Excel Charts and Worksheets

Access is designed to let you store, manipulate, and ask questions of large amounts of data. Excel offers a wide range of data analysis and presentation tools you can use to extend the analysis you perform in Access. Including an Excel chart or worksheet in an Access form or report lets you explore alternative scenarios, use past data to project future patterns, or summarize your data in ways not available in Access summary queries.

Add an Excel Chart

  1. Open a form or report in Design view.

  2. Click the Design tab. ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.