Freight and Duty Calculator
This MS Access database application calculates the freight and duty on all incoming parcels and packages for Khoy's Mailbox rentals, and then produces invoices for the clients, and maintains a balance of all transactions and invoices for the company. The application also keeps track of the company's mailbox rentals to its clients.
This is a simple, elegant, and yet powerful database application solution. Some of its capabilities include the following:
- Prepare an invoice recording the details of all parcels and packages received.
- Calculate the freight and duty on each invoice.
- Keeping track of invoices that are paid and unpaid.
- Search invoices.
- Keeping track of mailbox rentals paid.
- Print a summary of paid invoices.
- Print a summary of unpaid invoices.
- Print details of mailbox rental payments.
This application was a complete database development solution. This means that the client just said what they wanted and I was responsible for everything from there, including:
- Analyzing the needs of the client.
- Designing the database.
- Developing the database.
- Implementing the database, in MS Access in this case.
- Maintaining the database.
This database application was developed in association with with Sherrine N. Augustine