12.1. The Project Description

 < Day Day Up > 

Create an application that will be used to run a small service business. The application needs to store customer information, standard service charges, monthly expenses, billing information, payment information, and a history of customer contact. In addition, the application needs to produce invoices and income statements, and generate marketing letters and letters for past due accounts.

The following screens are required:

  • Main Menu

  • Customer Information

  • Billing Information

  • Payment Information

  • Contact History

  • Services and Charges

  • Expense Entry

  • Invoices

  • Letters

  • Income Statements

The application should be flexible enough to allow a non-programmer to create additional letters. In addition, it is important to maintain a history of contact information for customers. It is also a requirement that the standard service charges can be overridden. It is preferred that the standard invoice be in Excel.

     < Day Day Up > 


    Integrating Excel and Access
    Integrating Excel and Access
    ISBN: 0596009739
    EAN: 2147483647
    Year: 2005
    Pages: 132

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net