Awarded

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

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.

Skills: Google App Engine, HTML, Microsoft Access, Website Design

See more: access google docs form, google docs access, sync google docs excel, google docs form access, sync excel google docs, access sync google docs, access google docs, google form html, scope work database access library, www html programming com, www docs google com, www doc google com, website design procedures, website creation system, web programming online job, web form to google spreadsheet, web design or computer programming job, web design & html html forms, videos on creation, template web html, submit google app, stage of computer programming, spreadsheet in html, song business, scope for online business

About the Employer:
( 3 reviews ) Morley, Australia

Project ID: #1441878

6 freelancers are bidding on average $422 for this job

sunztech

Please see PMB.

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

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

$500 USD in 10 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
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
XKA7m

Check PMB please.

$500 USD in 1 day
(0 Reviews)
0.0
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