The primary goal of this project is to translate the form example from the attached access database into a functioning HTML/PHP interface which can eventually be loaded to our website and will allow clients to query their customer/operational data.
1000 rows of sample data in a text file will be provided for the project and should be created in a SQL db/table that supports the reports. Please note that the data set has *hundreds* of fields.
Additionally, there is a table in the attached access db that should serve as direction on how we would like the form to operate. There are three types of reports (list, management and graph). Each of these should allow results to return to screen or be downloaded to excel.
Once the project has been initiated:
I will provide an example of each report type, however, in summary:
List reports is a simple query generating a list of customers
Management reports are roll up/summary reports that will need to be grouped at various dimensions
Graph reports are simple queries that should return line/bar charts
In this project I will ask for three specific qry/reports to be developed to return an example of each report listed above. I’ll provide the specifics of those queries once I’ve passed the sample data.
Our goal is to have a working demo available within 1 week for review and feedback and final project delivered w/in one week following that.
We'll be available to discuss in as much detail as necessary once we've started the project.