Microsoft Access - Project Profile for an Order Tracking System and Ecommerce Website

Sector: Education
Industry: Educational Products

This book supplier is a full service resource for their customers. The company offers thousands of books from major publishers along with many small, independent presses. They provide their customers with personalized, one-on-one service along with the convenience of ordering products online.

Business Situation

A customized solution was needed to handle their expanding business. Home grown systems were being used to enter and process orders, manage books offered, and track customers. Day to day operations was becoming inefficient and unorganized. A re-organization of the systems used for operations was needed. The company also wanted to build an E-commerce website to generate additional business and allow existing and new customers to place orders online.

Solution

Order Tracking System

An internal Ordering Tracking system was developed using Microsoft Access. The customized system was designed to enter and process customer orders and also features a centralized database. This solution keeps orders organized and processing time down to a minimum.

The system is also used to maintain a master list of customers along with customer billing and shipping information.

E-Commerce Website

A new E-commerce website was designed to give the company a presence on the web. The website provides new and existing customers a central access point to the company. Products and services such as binding services, cataloging services, and consulting services are showcased.

Visitors can establish an account online and shop for books. The complete list of books is provided for customers to search on and offers a variety of search options. In addition, customers can compile a list of titles, receive an automated calculation of the total cost of their list, and at the end of their shopping experience, purchase the titles in their list.