Microsoft Access - Project Profile for the Postal Accounting System

Ask us a question on-line
or get our email address on scr.im

Access Programmers has a mission to help people improve productivity through the effective use of technology.

 

 

Microsoft Certified Partner

  

Postal Accounting System Case Study

Customer Profile

Sector: Direct Mail
Industry: Direct Marketing and Mail
Revenue: $18 million

This direct mail advertising services firm is a provider of mass marketing and mailing services. They have an average daily production of 6.4 million pieces of personalized mail with the capacity to dedicate up to 2 million mail pieces daily to a single client.

Business Situation

The firm sends out all of their direct mailings via the United States Postal Service (USPS). For each mailing job sent out, the USPS requires a form which itemizes the counts of the pieces, weight of the mailing, and the calculated cost of the mailing. There are dozens of types of mailings with each one having a different form required. The USPS was implementing a rate change for the existing shipping methods and also introducing new methods. The company’s Postal Accounting System is responsible for automating the creation and printing of the required USPS forms. The company needed an IT team to analyze their system and update all elements that would be affected by the rate change. The situation was urgent. The solution needed to be completed within one month.

Solution

Postal Accounting System

The Access Programmers team was selected as the solution provider. Every screen, report, data table, and line of programming code was analyzed, updated, and tested for compliance with the USPS. It was critical that the solution be accurate and tested extensively with a large volume of data. The staff at Access Programmers executed and delivered the solution on time and within budget which enabled the company to continue to perform daily operations in an efficient and automated manner.

  

Executive Summary

Company

This direct mail advertising services firm based in Palos Hills, Illinois is a private company organized in 1976.

Solution Description

The Microsoft Access application had every element of the system updated to handle the new USPS rate changes.

Software and Services

  • Microsoft Windows XP
  • Microsoft Access 97