MS Office Integration Module

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 Accounts 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 Accounts 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.

New Features - Even Greater Ease of Use

10 Simultaneous links to 10 different company data files, for consolidating information.
Converts technical field names for accounts data into meaningful, plain English descriptions.
Specific, in-built functions for extracting:
- Profit and Loss
- Customer Information
- Sales Analysis
- Supplier Information
- Supplier Analysis
- Project Management
- Stock Prices and Quantities
Each time a MS Excel spreadsheet is opened, it is automatically refreshed with up-to-the-minute data from the back office accounts.
Facility to produce MS Word documents using information extracted directly from Customer and Supplier records. Once a document has been sent, copies can be attached to any number of accounts records.
Facility to use MS Project to work on information drawn from the Access Costing module, and to post it back in an instant.

Benefits

Radically reduces the time taken to get information from the accounts system into Excel spreadsheets, Word documents and Project files.
Far simpler to set-up and use than ODBC connectivity.
Non-auditable data can be worked on using all the speed-editing facilities and functionality offered by Excel and Project.
Auditable data (e.g. financial values, dates and tax values) is completely protected and secure.