Home >> Case Studies >> Application Design : Advocacy Associates
Application Design : Advocacy Associates - Washington, DC
 
  Client's Voice:
"Your developers are Brilliant.... I want you to know that this database is already making life about 1,000 times better. Thanks!"
- Stephanie Vance, The Advocacy Guru


The Advocacy Associates (AA), is a for profit organization working for non-profits, focusing on the scheduling and management of communication and political access resources for its clients. MBPS provided AA with Database modifications, Online access to an Event Calendar application and Project Planning and Management.


Challenge: The project goal was to modify and improve their current database tables and allow Advocacy Associates to provide more detailed reports to their clients, provide sign in accessibility to update calendar events, and make the overall scheduling and reporting process more efficient.
  • To integrate with an existing MS Access database with custom-built interfaces.
  • To integrate the current database which is kept on a local LAN with remote access through a third party vendor.
  • To develop a bridge to the internet and allow clients to view reports.
  • To be able to upload information easily to the event calendar (as opposed to hand typing it in)
  • To have pass code access for making changes to the calendar.
  • To allow clients makes a change to the online schedule and have a way to "flag" the event so that the client can feed it back to the database.
  • To be able to slice and dice the data by any of the fields in the database.
Strategy:
  • To make sure all development modifications are compatible to their current legacy system.
  • To develop and create all requirements in module components in separate .NET executable code.
  • To create all web based programming in ASP.NET and IIS.
Solutions: AA needed several solutions to improve their database and their ability to access reports and calendar events online. MBPS assessed their current process and current systems in place and came up with an appropriate course of action to meet their business requirements and no profit budget. Below is a list of the solutions and deliverables requested by AA:
  • Develop .NET Executable code for flexible integration.
  • Web components including web pages for calendar and online access.
  • Modify MS access reports & tables for flexible functionality.
  • Develop a mail merge module to allow for easy distribution.
  • Document mapping requirements to MBPS solution.
  • Help Documentation for each software Deliverable.
Database Modifications:
  1. Create Schedule Tables Modifications.

  2. Create a program which generates meeting requests letters to senate/rep offices listing all members attending. The program will automatically generate all letters and save them to a directory in MS Word format.

  3. Create a program which shows a progress report of participants with less then 3 (customizable number) meetings with information based on the requirements document.

  4. Create individual Report Modifications by adding new data fields to expand reporting functions.

  5. Create online access for staff and clients to a calendar of events web page that will be directly linked to MS Access (no uploading needed), allowing staff members to update calendar events automatically.

    1. Password access to add events to calendar by client.
    2. Client changes (Will be directly updated to the database, no flagging mechanism)
Benefits: These solutions allowed Advocacy Associates to provide more detailed reports to their clients, provide sign in accessibility to update calendar events, and make the overall scheduling process more efficient. The work enabled them to provide more detailed data requested by their current clients and allowed them to acquire new clients through better information and services.

Conclusion: By defining the scope of services necessary to meet the Advocacy Associates needs and requirements, MBPS was able to finish the project within the tightly defined project schedule time frame. The project was delivered on time and on budget allowing AA to launch the upgraded database, giving their clients the continued good service that is expected.



Would you like to discuss your project with us? Contact us directly.

 

Wednesday, April 24, 2019 10:42 PM
Print this page
Bookmark this page
Case Study Overview
Problem

The project goal was to modify and improve their current database tables and allow Advocacy Associates to provide more detailed reports to their clients, provide sign in accessibility to update calendar events, and make the overall scheduling and reporting process more efficient.

Solution

AA needed several solutions to improve their database and their ability to access reports and calendar events online. MBPS assessed their current process and current systems in place and came up with an appropriate course of action to meet their business requirements and no profit budget.

Benefits

These solutions allowed Advocacy Associates to provide more detailed reports to their clients, provide sign in accessibility to update calendar events, and make the overall scheduling process more efficient. The work enabled them to provide more detailed data requested by their current clients and allowed them to acquire new clients through better information and services.

Other Case Studies
GUI / UI:
Department of Human Services
Database Enginnering:
Board of Revision of Taxes

Contact MBPS Online