| Word VBA
|
In this example we are using a form interface to populate the underlying 48 page Word document.
It was very frustrating for the user to have to scroll and search through all the pages to enter the
necessary pieces of information. To drastically improve data entry time, we created this user-friendly
form interface. Now they simply enter all the required information on the form and then simply click a button
to populate the related fields in the document. |
|
| Excel VBA
|
Again we have a user-friendly form interface to populate the corresponding
Excel worksheets.
Like the Word form above, this Excel form is used to restrict data entry and to validate information entered.
It will also serve as a template. It is used to assist Principal Investigators with their grant budgeting.
This particular template integrates with MS Word. When the click the "Generate Budget Justification Document"
button, it launches a new MS Word document and populates it with all the required budget justification information
in the MS Excel spreadsheet.
|
|
| Access VBA
|
This is an MS Access database application used for tracking grant information and budgeting. Its power
is in its reporting and the coverting of Fund Year data to Budget Year figures.
Again a form interface is used for data manipulation and to validate the information immediately when entered. |
|
