The Power of Integration
Would you like to be able to do some analysis of financial information using Excel?
It's easy and inexpensive to translate the information stored in your company database into Excel. Anything that can be done in Excel directly can also be done under the control of the Access ® program.
Starting out: A screen in an Access program
Excel spreadsheet created automatically
The following shows the spreadsheet (including bold titles and a graph) that was created automatically by the Access® program - all the user had to do was click a button!
Note: It's also possible to accomplish this in any Access® program by clicking Tools - Office Links - Analyze in Excel, but this is beyond what most users want to do, and you also then have to format every time.