Google doc & Html creation & syncing from MS Access & Excel

Awarded Posted Feb 12, 2012 Paid on delivery
Awarded Paid on delivery

As the first stage of this project we have several business documents that we want to convert to Google docs so they can be shared around the office.

We also require that the Customer Job Form can be made in to webform for clients to input their own data and submit completed document to our client liaison.

These individual docs will need to have some fields automatically updated from the other documents.

The Library Database will also be required to output relevant details to enable easy programming of a page on our website for our Band of the Day listings. So it's possible that an HTML template for our website Band of the Day pages are also required. Links to the current band of the day pages can be seen here: [url removed, login to view]

Documents to be converted to Google Doc format include:

1/ Library Database of CDs/Dvd/Videos in MS Access format - Containing Artist/Title/ tracks/Format/ Catalogue number etc etc. It is envisaged some extra data fields will be added to the current Access Document

Ability to add thumbnails of artwork or links to Associated artwork files and other info seen as additions to the work.

2/ Customer Job Form in Excel format. - Containing Name. Artist, Title, Job due date and job details covering CD/DVD/Bluray and USB manufacturing procedures. Job progress info. Music details to be added include Album Name, Artist, Song Titles, genre etc. Extra data fields will need to be added such as Song titles (expandable list due to varying number of songs per CD) Twitter, Facebook or other contact details, Artwork thumbnail link.

This job form will need to update relevant fields in Library Database - Document (1)

Updating of job progress fields by our suppliers is also required.

Client access to certain fields for online job tracking progress or an App for client job progress is envisaged as part of this work in the future. The Job Progress App should be compatible with Smartphone or Email/SMS

3/ General Job Tracking Form is a cut down version of the Customer Job Form (2) and sits on our reception computer as an Excel spreadsheet - This is used for daily job tracking in a simplified [url removed, login to view] Job Number/ Date in / Date out / Name/ Job details/ qty/ job contact / job complete assigned.

It is envisaged that this work will require updates and revisions as it is implemented in our business, not all of these elements will be required straight away. for example the App can be introduced later when the system is running.

However I think it's important that the scope of the project is understood so all the items can be taken in to account for future work.

The initial scope of work should include converting the current documents (Access/ Excel files ) to Google Doc format and implementing the "sync" capability. And include the library database to web html files and also the Client online data job form.

I've included the current Job forms as attached file. I can upload Access Database if required.

This is a complicated project to describe so please ask questions if I havent explained the scope very well.

I've just added a word doc project doc to show diagram of job scope and how the various Google Forms will need to link

I have uploaded Job Progress Form and Access Library Database documents so that the relevant data fields can be seen.
This currently completes the data that needs to be converted to various Google Docs and have the necessary datafields automatically update
If you have further questions please email
regards
Mark

Google App Engine HTML Microsoft Access Website Design

Project ID: #1441878

About the project

6 proposals Remote project Active Feb 15, 2012

6 freelancers are bidding on average $422 for this job

sunztech

Please see PMB.

$500 USD in 5 days
(26 Reviews)
7.3
karthik105

Hi Sir I can convert the doc to google doc. Please assign me the work.

$200 USD in 8 days
(0 Reviews)
0.0
XKA7m

Check PMB please.

$500 USD in 1 day
(0 Reviews)
0.0
kitrak93

We can do it for you in just 2 days. it will be 100% perfect.

$330 USD in 2 days
(0 Reviews)
0.0
mubbasharhusain

Hi, I have read your requirements. Please check PMB. Thanks

$500 USD in 10 days
(1 Review)
0.0
Bhavit09

Professional consultant-specialist in Google Docs, can acquire desired result. Please see PM.

$500 USD in 10 days
(0 Reviews)
0.0