Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Access VBA,Microsoft Access Administration,Microsoft Excel freelancer for Microsoft Access (R) job

Posted at - Jan 15, 2022

Toogit Instant Connect Enabled


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.

About the recuiterMember since May 20, 2018 Kemal Morris
from Jammu and Kashmir, India

Skills & Expertise Required

Access VBA Microsoft Access Administration Microsoft Excel 

Candidate shortlisted and hiredHiring open till - Feb 5, 2022

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$173.99
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Network And System Administration category.


Related Jobs


Latest In Access VBA Jobs


Latest In Microsoft Access Administration Jobs


Latest In Microsoft Excel Jobs