A local company in Indiana is currently using many Excel spreadsheets to track all their company data. This project is a two part solution to improve their data tracking. The first part is the building of a database hosted on a SQL server. This database is replacing several spreadsheets so the database is rather large with 28 tables. Many of the tables are large and have multiple relationships with other tables making it a very complex database.

     The interface for which the company will use to enter this data is an ASP.net website written in the C# language. The website consists of web forms that are used to display, edit, and enter company data. The web portion of the project is equally as complex as the database it interacts with. However, the forms developed are very simple and user friendly. Data can be view from a table and entered from the same form requiring a lot less navigation for the user.

Author