Microsoft Access (R)

Posted by - Kemal Morris at Jan 15, 2022
Jammu and Kashmir, India

Toogit Instant Connect Enabled
BudgetTypeStatusValid Through
$194.79FIXEDOpenFeb 5, 2022

Job Description

I have a database that last freelancer could not finish two minor things, so two things are not working correctly.
1. When connections meeting list gets imported via excel de-duplicate logic is not working
a. De-duplicate by not importing/or deleting that data (data that gets imported that is under Relationships in the template), when new record in import has another record with same fields in: __________ Partner, company name and rdb with yes. All three field must exactly match.
b. De-duplicate in same way for ones already in the database.

2. Report named 'New Connections' not working.
a. So report would show when a record that had nothing in the connector field from a Connection meeting and nothing in Rdb field, later because of new imports (or existing records in db), the Company name of the new record (from import or existing) matches the company name of an existing record (two/multiple records having matching company name) that has connector field blank and Rdb field with yes.
b. Same data points as Data tab.
c. You should be able to see both (all) matching records in the report.

Skills & Expertise Required

Access VBA Microsoft Access Administration Microsoft Excel 

Offer to work on this project closes in 13 days!

Try more jobs by Kemal Morris

Telemarketing Services NEEDED (Proficient English & Spanish) - Hourly
Area apartments for rent - Fixed
Talent Agent for Female Martial Arts Video Website - Hourly
Telemarketing Services NEEDED (Proficient English & Spanish) - Hourly
Influencer outreach using Ninja Outreach software - Fixed
Looking for Member Press Integration on website - Fixed
English-French Translation - Hourly
Cybersecurity Program development - Hourly
Mobile Form Submit Solution - Fixed
CAD Designer for Creating Architectual Residential Plan - Fixed

Similar Projects

Data Entry

Deliverable - Accurately enter information from one excel into the correct excel template.
Type of Freelancer - This isn't a hard project, it's just copy pasting. BUT this data has an important f...read more
Hourly, $12.47

Create Labels from Spreadsheet Usin...

Create labels using online label generator from spreadsheet, and download PDF and JPEG versions for print. Work needs to be completed today.
Hourly, $10.91

Create an Excel spreadsheet

Create an Excel spreadsheet showing a loan portfolio returns with all monthly revenues being reinvested monthly into additional loans along with other revenue streams being added to the portfolio on a...read more
Hourly, $14.02

Kemal Morris hiring Access VBA, Microsoft Access Administration, Microsoft Excel experts from & nearby:

  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antarctica
  • Antiguaand Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosniaand Herzegovina
  • Botswana
  • Bouvet Island
  • Brazil
  • British Indian Ocean Territory
  • Brunei
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China
  • Christmas Island
  • Cocos Islands
  • Colombia
  • Comoros
  • Republic of the Congo
  • Democratic Republicof the Congo
  • Cook Islands
  • Costa Rica
  • Ivory Coast
  • Croatia
  • Cuba
  • Cyprus
  • Czech Republic
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • EastTimor
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • External Territories of Australia
  • Falkland Islands
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • French Southern Territories
  • Gabon
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guernseyand Alderney
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Heard Islandand McDonald Islands
  • Honduras
  • HongKong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jersey
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • North Korea
  • South Korea
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macao
  • Macedonia
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Man(Isleof)
  • Marshall Islands
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar
  • Namibia
  • Nauru
  • Nepal
  • Netherlands Antilles
  • Netherlands
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norfolk Island
  • Northern Mariana Islands
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Territory
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Pitcairn
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Reunion
  • Romania
  • Russia
  • Rwanda
  • Saint Helena
  • Saint Kittsand Nevis
  • Saint Lucia
  • Saint Pierreand Miquelon
  • Saint Vincentandthe Grenadines
  • Samoa
  • San Marino
  • Sao Tomeand Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • SierraLeone
  • Singapore
  • Slovakia
  • Slovenia
  • Smaller Territories of the UK
  • Solomon Islands
  • Somalia
  • South Africa
  • South Georgia and the South Sandwich Islands
  • South Sudan
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Svalbardand Jan Mayen
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • Togo
  • Tokelau
  • Tonga
  • Trinidadand Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turksand Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • United States Minor Outlying Islands
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Vatican
  • Venezuela
  • Vietnam
  • British Virgin Islands
  • U.S.Virgin Islands
  • Wallis and Futuna
  • Western Sahara
  • Yemen
  • Yugoslavia
  • Zambia
  • Zimbabwe
  • Aland Islands
  • Saint Barthélemy
  • Bonaire, Saint Eustatiusand Saba
  • Curaçao
  • Guernsey
  • Isleof Man
  • Jersey
  • Montenegro
  • Saint Martin
  • Sint Maarten
  • East Timor
  • Kosovo