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.



Reply With Quote
Copyright Techfuels
Bookmarks