Best aspects of Microsoft Office suite of products is that added programs are intended to function fine with one another. The capability to include spreadsheet, database, word-processing, presentation and email programs is real productivity tool and good way to do with few resources. E.g. capability to include data from Microsoft Access into Microsoft Excel.

Instructions


Step 1

Start Microsoft Access and access database with which you want to work.

Step 2


Generate query that return information utilize Microsoft Excel.

Step 3

Open query that you made and click "File" menu. Select "Export" and click arrow beside "Save as Type" box. Modify type to "Microsoft Excel". Select place to save spreadsheet.

Step 4


Start Microsoft Excel and then open spreadsheet you made. Format data as you want and utilize Microsoft Excel to do any computations you want to do.