Closed

Access Database Entry Work

We need someone with excellent Access query skills, an understanding of how relational databases work, and who is experienced in linked Access files to help convert debt agreement covenant data into an already existing database structure for uploading to our website. VBA programming skills are not required nor is a knowledge of debt covenants, but you do need a willingness to learn about debt covenants. Our implementation process consists of these steps:

1. Debt Compliance Services (DCS), my company, has an Access application that allows us to identify the covenants in a debt agreement and writes questions about those covenants. A given debt agreement might have 80 covenants and some 120 questions related to compliance with those covenants.

2. You would restructure the underlying tables to a slightly different format for uploading to our website. We have an Access database with a series of queries for making the necessary change. However, this is not an automatic process that we could have used VBA for. Review of the query changes is sometimes needed with appropriate editing.

3. When completed, the file is uploaded to our website for client review and editing.

4. When the client finishes, the file is downloaded into an expanded Access database structure.

5. Similar to 2, you would execute a series of existing queries and initiate VBA routines to restructure this data into a questionnaire database structure and a calender structure of regularly scheduled tasks. Again, while it has been automated to extent possible, review of query changes is sometimes needed and edited.

6. The edited file is then uploaded to our website. If the file is not properly constructed, the upload is rejected with error messages. Fix the errors and try again.

7. Client requirements and debt agreements can differ substantially, which requires flexibility to adjust the existing queries to deal with slightly different requirements. You would be expected to be able to make these adjustments after training in how the standard process works.

The idea candidate would be someone who has a business background, who is quite familiar with working in Access, but who is not a programmer. We need someone who understands the final database schema objective, and can creatively figure out how to modify the existing query process to adjust for particular client specifics. We have a substantial amount of client work coming up, so there would be regular work coming up over the next several months.

Skills: Microsoft Access

See more: work it up, website to learn programming, website learn programming, underlying data structure, services agreements, requirements to learn programming, regularly scheduled programming, programming in access database, programming in access, programming access database, need of data structure to programmer, microsoft programmer, microsoft fix it website, microsoft access programming, learn website making, learn vba programming, learn programming website, learn programming microsoft, learn data structure, learn database programming, how to learn programmer, how to learn data entry skills, data structure programming questions, data entry work linked in, database programming services

About the Employer:
( 0 reviews ) United States

Project ID: #9673564

25 freelancers are bidding on average $61/hour for this job

rhomeu

Hi, I am a MS Access expert and there's no doubt I can help build queries and export them in your desired format. I have done a lot MS Access projects as you can see it on my profile. I can definitely help you More

$50 USD / hour
(62 Reviews)
6.9
winghei

Dear Client, I would like to express my interest on your project posted. Upon reading your job description, i feel confident that I could be the best fit for this considering my experience and expertise. I am an exp More

$50 USD / hour
(33 Reviews)
5.5
finecodervw

Hi, Let me introduce myself a kind of techno-functional analyst. I have interacted with multiple customers in the past to analyse the requirements, drill down the data provided by the customer and present the findin More

$50 USD / hour
(42 Reviews)
5.4
dghq123

Hello. I am expert in Access Database and can do any task on Access.. I will read your complete details once you inbox me.. kindly inbox..

$63 USD / hour
(7 Reviews)
4.7
AlexandrK1

please clarify details & deadlines .

$83 USD / hour
(10 Reviews)
4.4
rsliter

Hello, Over the past 18 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual More

$50 USD / hour
(6 Reviews)
4.2
sofex

Hi, I will be happy to automate the required process. I have an extensive development experience in VBA, Databases and more. Please have a look at my portfolio and contact me if you require more details or have quest More

$50 USD / hour
(10 Reviews)
4.0
gtorikt

Dear sir, I can work with relational databases. If you agree I can develop a sample database for you. I am sure we can work together.

$55 USD / hour
(9 Reviews)
3.3
y2klewis

Hi, my name is Daniel, i am an access expert and am also a vb programmer, i have a great experience working/developing access applications, i am sure i can help you with your project

$50 USD / hour
(6 Reviews)
3.6
zvrck

Hello sir, I carefully red your project description and I think I understood it. I have many years of experience in designing of relational databases. My wife runs non-governament organization which include dealing w More

$50 USD / hour
(2 Reviews)
3.2
SandelaSolutions

Hi - I am an experienced Access developer and run my own small IT agency in Durban, South Africa, where I create and maintain Access systems, which is the core of my business. I have also successfully completed sev More

$50 USD / hour
(5 Reviews)
3.1
dev3dworx

Hi I am an experienced Access database designer having excellent query skills and I also posses some business background. I can assure you that will never disappoint you. I have read brief and understood the main pro More

$50 USD / hour
(2 Reviews)
3.0
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I am ve More

$50 USD / hour
(3 Reviews)
2.9
ENRICOJ

HI. I HAVE EXTENSIVE EXPERIENCE IN MS ACCESS DATABASE SYSTEMS ;THIS IS IN ADDITION TO MY DATABASE AND MS SQL SERVER SKILLS. I HAVE A VERY GOOD UNDERSTANDING OF RELATIONAL DATABASE SYSTEMS. IT WOULD BE A PLEASU More

$50 USD / hour
(5 Reviews)
2.6
jatindhoot

I have expertise in ms-access and relational database management system. I am doing software development from last 15 years using microsoft technologies and i have worked with ms-access for many projects. please ha More

$78 USD / hour
(1 Review)
2.4
mehedi276

Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can se More

$77 USD / hour
(2 Reviews)
1.8
swarm22

Dear Sir, I have +5 year experiences in Ms Access Database. To Provide Quality,modular and object oriented coding.

$55 USD / hour
(2 Reviews)
1.9
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$50 USD / hour
(4 Reviews)
1.8
wawam82

We practitioners MS Access Ms Access control of various features of table creation to codding in VBA. Is currently working on creating a database specifically for Gemstones Laboratory. ranging from customer receipts More

$83 USD / hour
(0 Reviews)
0.0
detroitted

I have 6 years experience as a commercial underwriter and risk analyst, so I have direct experience with a wide variety of debt covenants. After 2 years developing and beta-testing my own Loan Loss Allowance database More

$50 USD / hour
(0 Reviews)
0.0