| |
| |
Demonstrating capabilities with Microsoft Access |
|
| |
Publication management system |
|
 |
| This application monitors magazine production: |
| |
|
| » |
There are tables for the base issue, the articles, article type, article categorization, and author information. |
| |
|
| » |
The authors are relationally linked to the entity's Access contact table. This provides for reporting on authors multiple contributions to the magazine over its 30 year life. |
| |
|
| The table information is also used for web reports: |
| |
|
| » |
All the information is placed on the web using MS ASP or ASP.Net database driven web pages. This provides text for the search engines. |
| |
|
| » |
In addition the tables are linked to Adobe PDF of the entire magazine, the table of contents, plus each article individually. |
| |
|
| Also, the same table information is used to produce an annual DVD that included all issues over the life of the magazine (30 plus year). |
| |
|
|
 |
| |
| Contact management system |
|
 |
 |
| This Access application enables the entity to share the people, place, and vendor information company wide. |
| |
|
| |
This particular application has well over 20,000 individual records and has been used continuously for ten years without issues. |
| |
|
| Each record is linked relationally to sub-records that track the following: |
| |
|
| » |
Donation history. In addition to detail it provides form thank you letters, tax form 1099 management, and many statistical reports for multiple donation campaigns. |
| |
|
| » |
Event attendance. This includes a separate record of registration and the topics spoken on at any event. The application produces name tag, registration materials, accounting reports, and various statistical reports. |
| |
|
| » |
Magazine subscriptions. This information allows the production of form renewal reminders, author participation history, and historical reports. |
|
| |
| Conference management system |
|
|
| This application facilitates convention production: |
| |
|
| |
It utilizes tables for the base issue, the sessions, subject categorization, and speaker information. |
| |
|
| Partial list of uses for each event: |
| |
|
| » |
Event mailings, registration, speaker selections, and accounting |
| |
|
| » |
Paperwork production, including name tags, meal tickets, door signs, session chair package, |
| |
|
| » |
When audio is recorded and made available for sale and other distribution, the tables provide audio lists, CD or cassesste labels |
| |
|
| This client also places all their event hisotry on their website (which we built using ASP) |
| |
|
| » |
The event information can be searched by title, category, speaker, date, or event. |
| |
|
| » |
Audio files are also linked for downloading. |
|
|
| |
| Ratio Analysis Generator for the web reporting system |
|
 |
|
| The ratio contruction tool is part of the Web Reporting application. |
| |
|
| » |
We use it to "setup" ratios for each client based upon their specific chart of accounts. Note there are three section (three tables) involved. |
| |
|
| » |
The header section is for describing and naming the ratio. Then there are table entries for the numerator and the denominator items involved. |
| |
|
| » |
The client can choose to setup standard or custom ratios based upon their unique operating requirements. |
| |
|
| » |
Each ratio has a "Target" and an "Industry" comparitive field for performance budgeting purposes. |
|
| |
|
| |
Contact us |
|
|
