This project is for a Search Feature that looks at an Access 2000 database and applies as ASP search to present information:
All of the project requirements are included in the attachement.
Please note: you need to have experience in this area in order to qualify
here are the details:
Project
Access Database Data Search
The project involves extracting records from an access database system and presenting the results in html. The access database is updated daily.
The script that you make will only read data.
This project has to be done in ASP.
Screen Shots:
1. two search pages are required.
a. one for new hardware
b. the other for used hardware
New hardware search
Parameters:
Model ( when model is selected search presents only makes from that model)
Make (this is selected after a model is selected)
Model Year (this is a range search field)
Price Range ( this is a range search field
Stock number (single field search field)
Listing per page (limits the number of results per page)
(in case you are wondering, these two searches are identical, the presentation will be different)
Used Hardware Search
Parameters:
Model ( when model is selected search presents only makes from that model)
Make (this is selected after a model is selected)
Model Year (this is a range search field)
Price Range ( this is a range search field
Stock number (single field search field)
Listing per page (limits the number of results per page)
2. RESULTS PAGE
New Hardware Results PAGE
Selection box (this is a check box to select all the results that the user will require additional detail on)
Year (hardware model year)
Body Style (field in database)
Exterior Color (field in database)
Stock Number (field in database)
MSRP (field in database)
When the user selects the check boxes, the detail page will show the summary records for the selected records)
New Hardware Results PAGE
Selection box (this is a check box to select all the results that the user will require additional detail on)
Year (hardware model year)
Body Style (field in database)
Exterior Color (field in database)
Stock Number (field in database)
Selling Price (field in database)
(When the user selects the check boxes, the detail page will show the summary records for the selected records)
Note: the result page should also allow the customer to see a detail screen on item via hyperlink.
3. New Hardware Detail Page
Year ( field in database)
Make ( field in database)
Model ( field in database)
Body Style ( field in database)
Doors ( field in database)
MSRP ( field in database)
Stock number ( field in database)
Engine ( field in database)
Engine Cylinders ( field in database)
Engine Displace ( field in database)
Transmission ( field in database)
Trim ( field in database)
VIN ( field in database)
Exterior Color ( field in database)
Interior Color ( field in database)
Days in stock ( field in database)
Picture (database has the filename, name is hooked up to url to present an expandable thumb nail)
Have the option to print detail page on one page
Have the option to email detail page, send to friend
Options ( the options for each stock number are to be listed in bullet format. Field longer than one line will have a button on side that when pressed will show the rest of the line content in a text box format. Sort of like a drop down field with content.
Note: The picture expands into a new window.
Used Hardware Detail Page
Year ( field in database)
Make ( field in database)
Model ( field in database)
Body Style ( field in database)
Doors ( field in database)
Selling Price ( field in database)
Mileage (field in database)
Stock number ( field in database)
Engine ( field in database)
Engine Cylinders ( field in database)
Engine Displace ( field in database)
Transmission ( field in database)
Trim ( field in database)
VIN ( field in database)
Exterior Color ( field in database)
Interior Color ( field in database)
Days in stock ( field in database)
Picture (database has the filename, name is hooked up to url to present an expandable thumb nail)
Have the option to print detail page on one page
Have the option to email detail page, send to friend
Options ( the options for each stock number are to be listed in bullet format. Field longer than one line will have a button on side that when pressed will show the rest of the line content in a text box format. Sort of like a drop down field with content.
Note: The picture expands into a new window.
Data:
The database has two tables linked via a common stock number.
We will not be able to make any changes to the database.
The database has both new and used hardware records.
The database is in Access 2000 format.
No macros or queries will be put in the database.
Basically the database comes as is and cannot be touched .. we can read it though.. no password on database
Winning Bidder will be provided with sample data and url`s for image locations.
Please review this project carefully.
Summary:
Project requires
2 Search pages
1 results page (that shows either used or new hardware)
1 Detail page ( that shows either used or new hardware)
Note: Please use tables everywhere, this makes is easier to move around detail for presentation.