Find Jobs
Hire Freelancers

Create Access 2010 Database with Sharepoint as Backend

$30-250 AUD

В роботі
Опублікований over 13 years ago

$30-250 AUD

Оплачується при отриманні
Hi, I’m looking for someone to create a small Microsoft Access 2007/2010 Database for us with the Access Tables stored on a hosted SharePoint 2010 backend so that it can be shared with users over the internet. We would like it so that the Access front end, with the SharePoint backend, can be set to “work offline” so that the database can be edited offline for users without the internet then synchronized back to the server when the internet connection is available again. (This is the reason I need an access frontend rather than just using SharePoint entirely). I already have a hosted SharePoint 2010 service set up ready to go. The purpose of this database is to let users submit a weekly form for each week of the year, per 'project'. It also needs a Report so that the manager can press the "Report Selected Week" button and 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 stored value in it is different from the previous week. The front-end 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). I'd like it to be coded so that there is 52 weeks (for the year). If no form was entered for a week then it should automatically “submit” the previous week’s 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. There will be up to 6 users accessing this database; no user however will be working on the same project_name form at once (one per user) so I don’t imagine there will be any conflicts using the database in ‘offline’ mode. I would a simple facility to record which user has submitted the form (e.g. when the submit button is pressed it prompts for a user name). It would be nice if when a form was submitted an email was sent by SharePoint indicating the form is ready for review however if this feature is too clunky/complicated then it’s not required. I have attached an Excel spreadsheet showing a rough design of what I would like the user form and report to look like and what fields are required. It is required that this database be coded without the use of VBA (i.e. in open source/code format... I can’t think why VBA would be required). Thanks heaps :)
ID проекту: 861111

Про проект

4 пропозицій(-ї)
Дистанційний проект
Активність 13 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Hello Ready to start. Please see your PMB for details. Thanks
$155 AUD за 5 дні(-в)
4,8 (22 відгуки(-ів))
4,3
4,3
4 фрілансерів(-и) готові виконати цю роботу у середньому за $359 AUD
Аватарка користувача
Please check PM for details.
$1 000 AUD за 21 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Sir, I am an IT Professional having more than 8 years of working experience in Data Operations Management & Systems Implementations by using Databases, Applications and Web Based Tools. Currently Deployed as Asst Manager in Largest Telecoms Company of Pakistan Responsible for following tasks in general. Billing of local and International customers which include a) Collection, Conversion and dispatch of more then one billion billing records b) Backups and space management on billing servers e) Systems Implementations f)Software development in (Oracle,Acess,Sql Server and ASP.net,Workpro and access 2007). g) Data entry tasks in different tools At present I develop following application (Inventory management system, Vehilcle Management system, Product development system and Payment system, Call Log System). Use of tools to accomplish different tasks are 1) Databases (Oracle, SQL Server, MySQL, MS Access) 2) Various Reports Development Tools (Report Builder with barcodes, MS Office Tools, etc) 3) Bulk Data Handling Tools (SQL Loader, TextPad, etc) 4) Web based tools (as required) 5)Data Processing I have proven experience of working for various assignments on this platform. I can start immediately and have required expertise and resources.
$180 AUD за 15 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am a MS access guru and having 5 years of working experience in MSACCESS. I am now working as Software Engineer in Descon Engineering. I have also passed ODESK tests of MSACCESS, SQL and ODesk readiness test. You can see my portfolio. I have developed many projects for my company in access. Some of my working is attached. I am definitely sure to be able to help you in this.
$100 AUD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор AUSTRALIA
Milton, Australia
5,0
15
Спосіб оплати верифіковано
На сайті з жовт. 5, 2010

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.