offline
Last seen: Apr 07, 2014 9:08 AM EDT
Hire Me!
Rate: $25.00 USD/hour
Follow Invite to Project
 

MDavidCrompton

Excel, Access and VB specialist

Username: MDavidCrompton

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Boothstown, Manchester, United Kingdom

Member since: August 2011

Reputation:

4.9/5

(40 reviews)

5.7
[see more]

No user has recommended this freelancer.

  • $125 USD
    5.0
    Profile image for Seller chgeiselmann

    chgeiselmann

    23 days ago

    As in earlier projects, I am totally satisfied with the quality of David's product, his friendly communication, and his readiness to adjust the initial plan during work. Pure pleasure!

    Project Description:GENERAL TASK I need a tool for Access (Access 2010, but should work also in 2007 and with Access 2003 type databases, i.e. mdb) to perform a Lookup task: I have 2 databases, a Source database and a Target database...
    [more]
  • $110 USD
    5.0
    Profile image for Seller Palmweb

    Palmweb

    Mar 5, 2014

    Nice work, was a complex project that required both of us to really put our heads together to figure it the best course of action.

    Project Description:I have a DataBase I'm building (excel) that contains records from many different sources. 77k rows and 50+ columns in total. I would like to condense it by unique address but keep all the other unique data cells in the rows...
    [more]
  • $160 USD
    5.0
    Profile image for Seller abagne

    abagne

    Feb 8, 2014

    David did an excellent job with my project. He completed on time, asked the right questions, and delivered an outstanding finished project.

    Project Description:I created a new Microsoft Access database using MS Office 2010 and am in need of about eight reports. I will provide the necessary fields and layouts as well as information about fonts and color schemes,...
    [more]
  • $750 AUD
    4.4
    Profile image for Seller sarahduncan

    sarahduncan

    Feb 3, 2014

    This database proved to be more complicated than either David or I anticipated. Despite this David persevered and delivered a highly functional, creative solution.

    Project Description:The project would consist of 4 stages: 1. Finalise the specification for an Access 2010 database to manage rental properties (draft specification attached) so as to incorporate your suggestions to improve the databases functionality and remove any ambiguity 2...
    [more]
  • $50 USD
    5.0
    Profile image for Seller chgeiselmann

    chgeiselmann

    Feb 1, 2014

    Working with David was a pleasure. He altered my initial concept for the small Access tool I ordered in a somewhat unexpected way, but eventually I got a very handy tool that does what i need it for in a more comfortable way than i initally planned. I will be glad to invite him to more projects. I also appreciate his quick, clear and friendly communication.

    Project Description:I need a simple VBA function for MS Access (2010) that I can use in an update query to 1) checks the strings in a given field for duplicates 2) then, for strings that have duplicates, add digits to its end...
    [more]
  • $15 AUD
    5.0
    Profile image for Seller newconnect

    newconnect

    Jan 27, 2014

    Professional, Efficient and Quality Work

    Project Description:I need to work out the loan amount using only: Repayments Interest rate Loan length/term Normally your would use =(D17)*(($S$24)/12) /(1-(1+($S$24)/12)^(-12*G17)) to work out the repayments however I have the repayments and need to work out the Loan amount...
    [more]
  • $50 USD
    5.0
    Profile image for Seller seanExcel

    seanExcel

    Jan 18, 2014

    Thank you for your help

    Project Description:I need some help to calculate the Frequency of a few hands that I just cannot get my head around As far as I can tell when you get dealt 5 cards out of 52 3 of the same suits Frequency (13 choose...
    [more]
  • $300 USD
    5.0
    Profile image for Seller stephaniedoig

    stephaniedoig

    Nov 26, 2013

    David continued to be a great help. He is always contactable and always happy to help. Thanks again. Stephanie

    Project Description:Finishing up of Access DB
    [more]
  • $600 USD
    5.0
    Profile image for Seller stephaniedoig

    stephaniedoig

    Sep 4, 2013

    David has been an absolute pleasure to work with and has delivered a fantastic contact database. He is constantly on line and happy to help and has given great advice on things we were unsure of, resulting in a database that exceeded our expectations. He is extremely professinal and has all of the expertise (plus more) described on his profile. Would hire again, no dout about it. Thanks David.<br/>

    Project Description:My company is looking to build an Access database ASAP. I have tried to do it myself but have hit a brick wall with Access. If you would be free to spend 2 days on this in the next 10 days please contact me on 02072501418...
    [more]
  • $29 USD
    5.0
    Profile image for Seller Beech

    Beech

    Aug 31, 2013

    Excellent communications, David knows how to implement excel formula structure very well!

    Project Description:We have a simple workbook with 3 worksheets. We want a simple formula or macro that will perform the following operations and is not limited to the data in each worksheet - we may add records to all three worksheets - the macro or formula must be able to manage the additional data...
    [more]
    MDavidCrompton has not completed any projects.
  • $150 USD In Progress

    I have four different assignments on excel but I&quot;m not sure if you can handle all 4 as they require different skills. In any case, they are the following:1 - I need help building a simple macro which does the following:a) Opens a file with a specific name &quot;ChefsClub.xml&quot; in a specific folderb) Copies all cells of that sheet (the workbook only contains one sheet)c) Pastes in the current workbook all cells (with values and same format) into the sheet called &quot;paid&quot;d) All date values of the column &quot;I&quot; are originally with the format mm/dd/yyyy and should be paste in the format dd/mm/yyyy2 - Here I need to connect and extract data from MySQL to excel. There will be some simple data extraction according to some parameters, such as location or date related to that cell. Also, would be great to have some help crossing some of the data in order to identify customer segments.3 - Create a VBA Macro that goes to every option of a dropdown cell and then generates a pdf with the results displayed. Every time an option of the dropdown is chosen, the page refreshes values and therefore. So the VBA, should go through all options and generate a pdf with the displayed results for with each one. 4) an Excel sheet that will build PPC Campaigns for Google Adwords after my criteria.Attached you have a draft of what data i want to input and how it should be structured. The VBA will create a file that will generate an output ready for Adwords Editor upload (CSV).See attached files.Are you up for the tasks? :)Please let me know what you think.

    [more]
  • $15 USD/hr In Progress

    I have a DataBase I&quot;m building (excel) that contains records from many different sources. 77k rows and 50+ columns in total.I would like to condense it by unique address but keep all the other unique data cells in the rows.This will require some type of fuzzy matching as the duplicate addresses are not all 100% exact, ie:300 Water Street suite #3 | Portland | Oregon300 Water Street | Portland | Oregon300 Water St | Portland | OregonThe above examples would all be the same record. Each row may have different corresponding data in the columns that needs to be condensed into one row.I have normalized the data as much as I can using my limited excel skills and powergrep. I have made sure the states, cities and abbreviations are all consistent for easier duplicate recognition.I estimate that there is probably 20k actual unique addresses, which is what this should be condensed to, but keeping all the unique cells. making a very rich data set at the end.I&quot;m not sure if Excel can handle this type of project perhaps you have a better solution using sql or VBA Access or some other db manipulation/deduplication tool.Let me know via PM how you would best tackle this.

    [more]
  • [Sealed] /hr In Progress

    Currently using basic program in VB & Excel but can be rewritten with other programming as long as reports can be read by others with no special software such as converting to pdf file. Existing program works well but need to rewrite for better usage. Only way to quote is by the hour but we&quot;re more interested in expertise and quality than price for continuing maintenance or changes or other work.Must be well established as we are only looking for the best. Requires excellent basic math skills and logic. Must speak fluent English to communicate with Skype and email.

    [more]
  • $12 AUD/hr In Progress

    I have some flat csv files that I need added to an Access database. I need some basic queiries run on these tables, and reports created. Very easy to do, just above my skill level

  • $25 USD In Progress

    I have a process I repeat regularly on excel and would like to automate it.I will have a file in excel with data which is exactly 6 columns (A to F) but with any number of rows (minimum of 2).The process would be:1) Insert new (blank) alternate rows after each row - so line 1 will have data, 2 will be blank, 3 with data, 4 blank etc. - this should be done until the last line with data. The macro I currently use for this step is:Sub InsertAlternateRow()Do While Not IsEmpty(ActiveCell)ActiveCell.EntireRow.InsertActiveCell.Offset(2, 0).SelectLoopEnd Sub2) Then merge the blank fields on each blank line after the data for column A to F (so the first 6 cells of each blank row).3) Apply a border to all sides (and inside) for every cell in column A to F, down to the last merged cell.4) Revise every cell height to be 0.85cm / 32 pixels.5) Revise cell widths as follows:A - 1.59cm / 60 pixelsB - 2.38cm / 90pixelsC - 9.31cm / 352 pixelsD - 6.16cm / 233 pixelsE - 3.18cm / 120 pixelsF - 2.78cm / 105 pixelsI want all of these processes to be made together into one macro so I can do them rapidly.

    [more]
  • $40 USD In Progress

    1) Currently when I want to issue a receipt, I need to go to each donor that hasn&quot;t yet been receipted. Push create receipt, Then Print receipt. Then Thank you letter, nnWhat I want is after let&quot;s say a month of entering in donations, I want to click one button that will Create a receipt for all donations that have yet to have a receipt number attached to it. - I would like a screen to show me the list of all receipts that are going to be created for me to click OK or Cancel. nn2) Another button that would then let me print all of those receipts just created (or print all receipts since last time I printed all receipts) - again a screen should show me the list of receipts. - this screen should also show me if the Alias is checked or not. nn3) Another button to be able to select all of those same donors for a thank you letter (I&quot;ll choose which thank you letter).nn4) another button will print me all of those donor&quot;s for a standard address label.nn5) finally, separate from the above, I need a report (or query?) that allows me to issue start and end dates, so that I can print out a list of all receipts issued with their receipt number, donor name, and amount. sorted by whether it is a donor with an alias or just a regular. Also it should give me the total $ amount for each of those 2 categories. nnn

    [more]
  • Rp50000 IDR/hr In Progress

    database untuk aplikasi visual besic6

  • $100 USD In Progress

    Hey there i have a small VBA ten pin bowling project, its just basic data entry and sorting. Please let me know if you are intrested. I will send you the full project detail.

  • $20 USD/hr In Progress

    [This is a Private Project. You must be logged in to view the Project Description]

  • $25 USD/hr In Progress

    Hi,I have two excel spreadsheet. One is master spreadsheet and other list has the info I want to delete from the mastersheet.I want a quick way to do this.Master sheet is name and emailother sheet jst has emailThis is simple project so bid per hour.

    [more]
  • £150 GBP Jan 22, 2014

    I have a marketing schedule spreadsheet in Excel with multiple tabs for separate projects. Each tab details a list of tasks to be completed in a month order. I need a new that lists by month and pulls in the relevant tasks from all the other tabs. So this would become a master of all tabs. Eg if I updated a task in a sub tab, it would automatically update in the master

    [more]
    MDavidCrompton does not have any open projects.
    MDavidCrompton does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

IT Consultant

May 1976 - Sep 1992 (16 years)

Engineering Industry Training Board

I was involved in training employees in the use of computers from the very earliest time of desk-top computers

Education

2.1

University of Nottingham

1966-1969

Certifications

Level 3 ITQ

Oxford and Cambridge RSA (OCR)

Top level vocational qualification in Excel, Access, Powerpoint and Word. I also assess this qualification for OCR