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 Sep 14, 2017
Lance Hirahon
from Jalisco, Mexico

Candidate shortlisted and hiredHiring open till - Jun 19, 2022

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$173.74

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

Create a small online database for collecting construction inspection report

This is a report to inform the creation of a Database for input while out in the fields. Below are suggestions thus far:

Add a Request ID field for the Cityworks number
Add a Timestamp field for each address
Ask the City for input...read more

Sales Analysis of an Ecommerce business

Sales analysis data from QB data
1) Churn rate
2) Customer acquisition cost
3) Sales / % increase MOM (Month on Month) + Graph
4) Average basket size
5) Transactions / % increase MOM + Graph
6) Revenue / % increase MOM + Grap...read more

Scraping European video games publishers over the web

Looking for someone to scrap all the public email of European video games publishers over the web. Most important are the French, English and German one.

I need all those data store in an Excel files with this structure :
Company name -...read more

API Development (Connect Distributors website site product with my site)

Connecting my shopify store to my distributors. Products updates from the distributor should flow to my store. Which includes, New product, Price, Qty, Etc. Orders should be able to flow from my shopify store to my vendor of my choice. I work with...read more

Brother PT-P900 integration with excel with VBA P-bac.

Im looking to integrate buttons into the excel workbook that takes specific information and prints a sticker with corresponding info, we use the brother PT-P900 and we have printer templates for the stickers but Im lost when it comes to the VBA int...read more