Access 2010 Web database(repost)

The database consists of (45 tables, 12 queries, 31 forms and 16 reports). All running without error on SharePoint server. Debug existing web database. > track and check for correctness data - table, query, form and report. > format reports correctly for viewing in the browser. Design and develop complex pivots and reports. > Develop 12 pivots (we have several samples, but mostly this is a design and develop step). Crosstab queries will not work in a browser. The crosstab pivots should be the basis for well designed web compliant reports that do. Apply professional theme and branding throughout. We will provide a logo. Match the colors. Deploy the logo. ## Deliverables [login to view URL] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). Current draft schedule: **_Step-1 (days 1 ??" 3)_** 1. (Fix) Call “issues detail?? form, and match tabbed sub-forms for capacity and production. Add two buttons to the Issues Detail form, "2005 to 2010" and "2016 to 2020" that call forms for managing capacity and production values. The "2005 to 2010" form should be tabbed. The same for "2016 to 2020". The format should be same as 2011-2015 as appears in the Issues Detaill subform currently. 2. (Fix) Update comments for changed values in capacity and production tables, recording the old value and the new value, user changing the values, time and date stamp. 3. (Dev.)Create comments report, date parameterized for all issues with comments in the selected date range. 4. (Dev.)Comments report by assigned to (i.e., user assigned to an issue), parameterized. 5. (Check) Validate data values (flows) in existing web reports against data values in relevant tables Main Form; Reports Tab * CapacityYrs IssuesOpenCapaYr05_10 IssuesOpenCapaYr11_15 IssuesOpenCapaYr16_20 CapaQtrYr05_10 CapaQtrYr11_15 CapaQtrYr16_20 Q_ProductionByYrs PrdnQtrYr05_10 PrdnQtrYr11_15 PrdnQtrYr16_20 (Fix) and incorrect data flows from table to report if any exist. Demonstrate (or Fix) **_Step-2 (days 4 ??" 7)_** 1. (Dev.) pivot 1 through 5 using excel templates supplied by AEI 2. (Dev.) web reports for pivots Demonstrate (or Fix) **_Step-3 (days 8 ??" 10)_** 1. (Dev.) pivots 6 through 12 2. (Dev.) web reports for pivots 3. (Dev) add all pivot reports (1 through 12) to Reports Tab on Main form 4. (Fix) formatting of reports where required for pivot reports and reports mentioned above on main form in reports tab. 5. (Check/Fix) for proper browser operation of all reports Demonstrate (or Fix) ## Platform MS Access 2010 deployed on SharePoint.