The coder will write an app in .ASP that will display information from an Access DB on a web page. The DB contains info about my beer bottle and can collection. There is one record for each bottle/can. The user will select from 1 or more drop-down lists and the app will output a list of items from the database sorted by the field that the user chose. See the Deliverables section for a very detailed description.
1) Complete and fully-functional working program(s) in executable .ASP form which is the same as the complete source code of all work done. 2) Step by step documentation on what configuration is needed on the server in order to the .asp application to use the Access database. 3) Complete ownership and distribution copyrights to all work purchased.
Write an app in .ASP that will display info from an Access DB on a web page. The DB contains info about my beer bottle and can collection. There is one record for each bottle/can.
The user will use a drop-down box to choose one field of information from a list of several fields, and the application will display all records from the database sorted in order by the field that was chosen. For example, if I choose "Company name" from the drop-dpwn box, then the application will display all records from the database sorted by Company Name.
The user could instead chose a field from a drop-down box and enter a specific text string to search for in the database. For example, the user might select "Brewery name" and type in "oregon" and the application would display all DB records in which "oregon" was contained as part of the Brewing Name such as "Oregon Brewing".
The records from the database will be displayed in a plain grid-like format of columns like this: (this is an example - these are not all of the fields)
Brewery name Beer name Style
Oregon Brewing Rogue Stout stout
Smith Brewers light pilsner pilsner
The fields of the database that will be available to be selected are:
The drop-down boxes and text-input box will be at the top of the page, and when the application returns the results, the page would be redrawn so that everything stays on one page. The use of an .asp include is okay here if necessary.
Also, the DB has over 2000 records so it would be impractical to display all 2000 records at once. The application should tell the user how many records are in the DB, and the user should be able to select from a drop-down box how many records he wants returned at once on each page.
At the top and bottom of the page, the user should be able to click on a link to go to the next page, the previous page, the first page, the last page, or a certain page number. The appliation will be strictly *read only*. There will be no write permissions at this time. The .ASP code should be internally documented and should *not* use .CSS. I want the code as simple as possible so that I can go in and tweak some of the basic items like text placement, link placement, etc.
<[url removed, login to view]>
Please see the included .zip file for example .jpg images.
Additionally, if you can code an additional features into the application for the same price, let me know what you can do. I want to be clear about the basic requirements, but I am open to additional features.
Windows 2003 with IIS6, with clients on the Internet using IE 5 and IE 6.