System displays an ASP.net Page,
User is able to select databases for connection
System displays tables found in database
User is able to click check boxes for tables to search
System displays tables and columns for search and a column for a Count of Results.
User is able to enter text or value and start search
System returns a count of the data item found for each table and column and displays resultsin the Count of Results column
The solution can be in vba access or Sql Server.
VBA Access
For the access project the input files will be access links to mysql tables.
ASP.net, C#, Sql Server
For an asp.net, c#, Sql Server project the input files will be a mysql connection or a sql server linked server to mysql or any method that works accessing data contained in mysql.
## Deliverables
You should have the ability to complete this request based on the examples provided and knowledge of typical solutions for the request described or be willing to research any subject matter needed to complete the request. Specific technical specifications are not available.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confdentiality is deemed to be in all contracts present past and future with the Parties to this request.
## Platform
VBA Access 2003
or
ASP.net, C#, SQL Server
Visual Studio 2005
Sql Server 2005