Hourly - Est. Time: More than 6 months, 30+ hrs/week -
TYPICAL ACTIVITIES include
1 - Transformation of address data from Websites to Excel (e.g. scraping)
2 - Deduplicationand Extensive cleaning & formatting of address data in Excel
- Very experienced in working with MS Excel spreadsheets
- Quick in applying Excel Formulas including VLookup and all sort of string formulas
- Comprehensive understanding of VBA
- Familiar with UTF-8 encoding
- English communication
- Be responsive, flexible and draw EXTREME attention to detail
PLUS - Any of the following skills is a plus
- Databases like MySQL and MS Access
- Silenium Web Driver
- Software Engineering Skills
I have an Access 2007 database (single table of 17 fields) that I need to have another table added based on a spreadsheet(15 fields) that I am currently using. The main table is a Customer List and the Excel spreadsheet is a list of invoice/banking data.
It needs to be upgraded to Access 2013 and be used by several people. At the moment I am the only user so locking isn’t an issue, but I am employing someone in a few weeks and so it needs to handle record locking better. I understand that this means that you will have to create several views and be able to search across multiple fields.
I use this database for mail merges and so it needs to be able to pull data from both tables within the same Word document.
Nothing too difficult but requires more time than I have.
I have 5 csv files that contain real estate data and 4 csv files that contain secondary data (links to property images, agent info etc.). I need a relational database that can import these csv files daily and output csv files for import into another system.
We presently have an MS Access application with SQL Server on the back end. We have a Report Menu that chooses about 6 options (like date range) and then can open 4 reports.
We want to show that same data on the company website instead, with a print-friendly option for extra wide reports.
Members are already registering and logging into the site, but we will need a new Admin screen to approve new members and manage existing members.
The queries for the reports are complex, and use industry specific terminology. We have some of them translated to MS Access queries to SQL queries, but not all of them. We simple web page reports for 2 of the reports, but the 2 hardest reports remain.
Two of the reports are not laid out in just rows and columns. They were originally spreadsheets.
Would prefer someone who can work this weekend.
Hourly - Est. Time: Less than 1 week, Less than 10 hrs/week -
I am looking for somebody to help me develop a database that has a friendly user interface. That can easily input data and search for data and display reports.
Please do not spam me with your complete work history, I will not read it, and I will delete it, just let me know:
1. Are you able to use microsoft access?
2. Can you write and speak English to a decent level.
3. Your best hourly rate.
4. How fully functional input, search and report section of a database.
I am on a very tight budget, so please make your bid reasonable. Please use my name when applying.
There is an issue with the database... the 'billed' form, which was previously AR, does not record to the home table when you enter it in new services. I guess some sort of underlying connection is messed up or missing; I think when i changed it's settings by changing the name from AR to billing and removing the calculation code for AR something happened. So please leave the field billed able to be calculated, but please add it to the 'home' tab of the database as a column like everything else (i.e, CPT code, Consumer, etc etc).
I have a client using Ezy Invoice 13 and I need this to developed in Microsoft Access
Main focus in :
1. Create Invoice
2. Create Quote
3.Create Credit note
4. Individual database for each customer
5. Inventory list
7. Monthly Customer statement
8. Create Purchase order
9.Search for invoices based on invoice names, date range etc.
and together with other features need for accounting software.
I will portfolio of applicants of their previous development
I want to link my mysql database from an internet form to MS Access so it automatically updates.
In the mysql database there is a "data" field that has all the information from the form, I want it parsed into different fields im the MS access database.