Remote Network And System Administration Job In IT And Networking

Microsoft Access (R)

Find more Network And System Administration remote jobs posted recently Worldwide

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 recuiter
Member since Nov 11, 2022
Rachit Agarwal
from Buenos Aires, Argentina

Candidate shortlisted and hiredHiring open till - Apr 5, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$238.78

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

Similar Projects

Microsoft 365 flow and power bI expert

Looking to improve current workflows using Microsoft Flows and create power bi apps. I have been using flows for a year and continually run into issues. I have to constantly create new flows since i cannot re-use old ones. Also looking for an individ...read more

Developer needed to create a simple asset management software

We need to create a software management tool that would allow us to keep track of equipment, assign (scanning in) equipment to the company profile, create accounts for workers and reassign(scanning out) equipment to the workers, create reports, pull...read more

Microsoft Excel - Duplicate name Consolidation

I have contact in an excel spreadsheet format which need to have duplicates removed/merged consolidating contacts.

Excel Modelling - statistics and data visualisation

Looking for someone who is solid in Excel modelling and can perform substantive statistical calculations across large data sets.

Skill sets required:

Calculate mean median mode, standard deviation plus co-efficient of variation read more

Need Support from Data Analyst

CCS Data Analyst Role

CCS Fundraising, a strategic consulting firm serving the nonprofit sector, is searching for consultative support from a data analyst.

The scope of the role at the outset will be tightly defined. The analyst...read more