Create Access 2007 Database with Sharepoint as Backend


We are looking for someone to create a small Microsoft Access 2007/2010 Database for us with the Acess Tables stored on a hosted Sharepoint 2010 backend so that it can be shared with users over the internet (I.e. so that access can be set to 'work offline' and the database can be edited then synced back later). The sharepoint setup is already in place.

The purpose of this database is to let users submit a weekly form for each week of the year, per 'project' so that the manager can press the "Report Selected Week" button and then the report shows up the CHANGES in the submitted forms between the selected report week and the PREVIOUS week, for each project. It does not need to 'calculate' the changes - only display the changed 'field' if the value in it is different from the previous week.

The form that the users fill out should be pre-populated with the data from the PREVIOUS week so that they only edit things that have changed (I.e. week 1 will be populated with blank data as there is no reporting in that week).

It should be coded so that there is 52 weeks (for the year) and the form automatically selects the week your in based on the date so that users can't enter the form for say "week 2" in "september". If no form was entered for a week then it should automatically submit the previous weeks data for that week.. For example if no forms were ever entered and you called up "report week 52" then it would show 51 copies of the data in "form week 1" - and in this case it would report that 'nothing has changed' since week 52 is the same as week 51's data and so forth.

I have attached an excel spreadsheet showing a rough example of what the form and report should look like. More details will follow after bidding.

Thanks heaps

Skills: Microsoft Access

See more: access 2007 backend sharepoint, create access database sharepoint 2007, access database backend sharepoint, access 2007 sharepoint backend, backend access 2007 database sharepoint, sharepoint 2007 access database, access backend sharepoint, create access 2007 database sharepoint, access database sharepoint 2007, create database sharepoint form access 2007 backend, create backend access 2007, sharepoint create access 2007 database, access 2007 backend database sharepoint, sharepoint access backend, create database sharepoint 2007, access database sharepoint backend, create access database sharepoint, sharepoint 2007 access 2007 backend, microsoft access create backend, sharepoint 2007 backend, access 2007 database backend sharepoint, sharepoint 2007 backend database, backend sharepoint access 2007, set database sharepoint 2007, sharepoint 2007 access backend

About the Employer:
( 15 reviews ) Milton, Australia

Project ID: #814275

4 freelancers are bidding on average $56 for this job


I am ready to Do This With In 3 days

$35 AUD in 3 days
(0 Reviews)

Hi there, I am a MS Sharepoint consultant and very keen to do the job and deliver you the solution. You can use MS access in combination with sharepoint or just use the sharepoint itself as ms sharepoint is a bespok More

$110 AUD in 1 day
(0 Reviews)

i am interested

$50 AUD in 5 days
(0 Reviews)

Sir, I’ve excellent skills on data entry, data processing,data analysis and Database & Web Programming with Excel, Access, SPSS, SQL Server, Oracle,, MySql, PHP and etc. I am ready to do this work at best pri More

$30 AUD in 3 days
(0 Reviews)