I'm a PhD student wanting to outsource some data cleaning. I have a small amount of Excel data that needs to be re-coded in several ways and turned into an access database. I expect I will have a lot more work to offer as this project progresses. There is name data in the format "John Smith" that needs to be converted to "John_Smith". The d...
==No copy-paste voodoo programmer please, I already have enough bad experiences. Thank you for your understanding== An MS Access project went much different from what was intended. In a nutshell, the project is a customized stock management system with 5 different user levels. Each level has different permission for functionality and data accessibility
...provided: An Excel spreadsheet An online database system Instructions online Your Job Use the Excel spreadsheet to extract / download file from the online database Each file downloaded from the online database will have a unique file name, given in the Excel spreadsheet Expected to deliver 200-300 files per day Size of work 2000-3000...
...provided: An Excel spreadsheet An online database system Instructions online Your Job Use the Excel spreadsheet to extract / download file from the online database Each file downloaded from the online database will have a unique file name, given in the Excel spreadsheet Expected to deliver 200-300 files per day Size of work 1000-2000...
...tables. I have a pretty decent excel program I developed, but when having multiple people accessing the document, it became apparent that I needed to simplify the input process. Being a non-profit, if the database could work with OpenOffice Base, that would be preferable. However, if we need a few licenses for MS Access, I could probably swing that.
... 4) Admin 2. Website should access oracle database of our ERP server. For Storing any data and data access should be done from oracle database (11g) hosted internally. Our oracle server is accessible only within our network now, we should find a way to broadcast it our static IP address. (Right now database is not connected in static IP)
...and Asset Management. We need someone to work with us and help with our administration and research requirements. We have regular work 25-35 hours per week. The role can be split into two main tasks: 1) Updating our recruitment database - adding new candidates and clients, updating changes to their work history, assigning candidates to jobs, adding
...Open Mesh and Cloud Trax Scripting environment. We currently use Open Mesh to provide our Restaurant with Social Wifi Capabilities. Customers login, enter their email to access the Internet. We would like to build our own platform that connects to our Open Mesh / Cloud Trax platform. • Have a splash page login page template that is easily changed
...develop some software for me. I would like this software to be developed for Mac . Hi I need two jobs to build a database for price comparison tool from my suppliers to help my buyer First Part I need to automate scraping data from excel spreadsheets , csv, text from emails , for price comparison from various suppliers of products. Our suppliers provide
...WILL ONLY WORK WITH ORGANISATIONS WHO HAVE A PROVEN ABILITY WITH BOTH WEBSITE DESIGN, DATABASE CONSTRUCTION, MOBILE PHONE APPLICATIONS AND THE SEEMLESS INTEGERATION OF ALL THREE – DO NOT APPLY FOR THIS PROJECT IF YOU HAVEN’T GOT A PORTFOLIO THAT DEMONSTRATES THE ABOVE. We are a delivery company looking to move from a predominantly excel and paper based
...listings site. We need to develop an easy and simple system to import listings from an excel spreadsheet or csv format. Our data entry team will compile a list of addresses that needs to be imported. This project requires the following tasks: - restructure the database tables in order to simplify the way data is organized, making it possible to import
...build an access database to handle clients and progress them. We must be able to export all the data to Excel. The database must be user friendly. A number of the entries will need: 1. Drop down options 2. Date 3. Simple calculation 4. Automated Client ID 5. Currency in GBP The quote must allow for testing of the database fixing problems
...APIs, the VBA programming language, and Microsoft Access. Currently, I am using Excel workbooks and ad-hoc Access Databases to store Amazon order information from my seller account that I download as .txt file and manually import into either program. I would like to have VBA code written in an MS Access module to pull order information through Amazon's
Complete unfinished project: Previously compiled PHP code written for old system needs to be made to work with new system and be enhanced in a new database. Summary of Project: Access affiliate partner product sheets via FTP, match products from different affiliates and select the highest affiliate partner Rate, then combine with all unique products
...that understands basic database concepts and enjoys working unsupervised. This is probably you if you love MS Excel but wish it could do more. All work is done online in a platform that requires no coding. (REST API and other programming skills are a bonus) A client will ask us to build or fix things in their database as it is needed. This job
We work on web projects (mostly HTML5) and need a seasoned developer with experience in the following: -Basic form data collection and small database retrieval with PHP/MySQL, .NET -Connecting custom forms and writing results to db (with a way to review results) -HTML5 experience a plus, however not required as long as you can connect data to website
Scope of Work 1. Project Scope Employee Template and Scheduling module is for creating schedule templates and assigning it to employees for their weekly templates. Access rights will be applied for this module. Administrative rights are given to be able to make modifications. This module loads data from each corporation’s database, that has its
...always at my computer. [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions] I hope you can Help me. QUESTIONS 1. The Database and Main Menu Form: On opening the Database, you must have a Macro which runs and automatically opens the “Menu Form” in full screen view of the Menu Form, with no possible view or any other forms
I have developed more than 200 automations, using different platforms supported by VBA, Automation such as Excel to Excel, Excel to Access, Excel to Powerpoint, Web clawring, Excel to Mainframe. Key projects I have developed are enumerated below: 1. Quality Report for Finance, where data is taken from 5 different files, into a single consolidated
...client information in computer system Running and processing multiple documents utilizing Microsoft Word, Excel, and Access Inputting purchase orders Other various administrative tasks,Inputs information from a variety of sources into a computer database. May take customer orders and enter them into a pre-established tracking system, Assignments will be