Accounting software
Reporting
Microsoft Office Integration Giving users a dynamic, 2-way link
Access has introduced a new range of menu options in Microsoft Office software (Excel, Word and Project), giving users a dynamic, 2-way link directly into Access datafiles. This suite of add-ins is created using Microsoft VBA (Visual Basic for Applications). The resulting enhancement will be of particular interest to those who prefer to work with spreadsheets, as it provides a secure and reliable method for displaying financial data in spreadsheet format.
Each time a spreadsheet is opened, it is automatically refreshed from the live accounts system, without the need for re-keying or reformatting of data.
Conversely, the write-back facility updates the Access datafile with any amendments that have been made in the spreadsheet. With this interaction it takes just seconds to change non-auditable data, such as the Sales Person allocated to hundreds of Customer Records, or to revise and update a whole year's budget in the Nominal Ledger.