Find Jobs
Hire Freelancers

Assistance with MS Access Database Creation

€8-30 EUR

Mbyllur
Postuar about 6 years ago

€8-30 EUR

Paguhet në dorëzim
I am creating a relational database. My expertise is fairly limited but I have managed to create a simple database with several tables and many-to-many link tables joining the tables. I am now a little stuck because I want to show links between records in a table to other records in the same table. When I display this data in a form with a subform, it shows the records that match Key 1 but not records that match Key 2. Ie I can see that John is linked to Steve and Matthew but I cannot see that he is linked to Allan because he appears on the second foreign key in the link table rather than the first. I'm just looking for some very simple help here. I don't want any confusing VBA coding. I need you to be able to show me exactly how you did it so that I can replicate the steps myself later. Although a simple task I am keen to develop a relationship with a competent access database creator potentially for future tasks.
ID e Projektit: 16414701

Rreth projektit

27 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
27 freelancers are bidding on average €26 EUR for this job
Avatari i Përdoruesit
Greeting, I have understood your Assistance with MS Access Database Creation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Programming, Excel, Microsoft Access, SQL, Visual Basic
€100 EUR në 2 ditë
4,9 (471 përshtypje)
8,4
8,4
Avatari i Përdoruesit
Hello! I have some years of experience in sql data modeling and I believe I can help you with your problem. Best Regards
€20 EUR në 1 ditë
5,0 (33 përshtypje)
6,1
6,1
Avatari i Përdoruesit
Hi, I'm a senior databases developer. I have checked your file and I'd like to help you get this done. However, your tables and relationships are correct but in a recursive relationship Access Relationship Manager cannot do much. What you need here is some very basic VBA that takes SQL query and turns it as a record source to your subform. Let me know if you're interested in working on this together. I will guide you step by step. Best, Alaeddin
€34 EUR në 1 ditë
4,9 (73 përshtypje)
5,9
5,9
Avatari i Përdoruesit
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects I've developed for Ms Access/Excel/VBA projects. I'll do your small Ms Access project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
€29 EUR në 1 ditë
4,6 (68 përshtypje)
6,5
6,5
Avatari i Përdoruesit
I am a business analyst with 15 years professional experience working with Access. In order to achieve what you are after you will need to modify the underlying SQL in the table to have an OR condition in the join - is this a solution you would be comfortable with?
€23 EUR në 1 ditë
5,0 (35 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Good day. I would like to help you on your project. I have been using Ms access and sql in general so this kind of problem should be easy for me. Feel free to message me so that we can talk more about this project. Thanks and have a nice day.
€20 EUR në 1 ditë
5,0 (65 përshtypje)
5,7
5,7
Avatari i Përdoruesit
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
€29 EUR në 1 ditë
5,0 (95 përshtypje)
5,9
5,9
Avatari i Përdoruesit
I am ready to support you right now. I can fix this issue easily. the main reason behind this can be the relationship issue. many to many not managed correctly. I can develope your complete project within a sort time and within your budget.
€24 EUR në 1 ditë
4,9 (39 përshtypje)
5,8
5,8
Avatari i Përdoruesit
This is not the way to show all the data associated to one matching key. If you see the join is set on one field (go to design view, select the subform and see the Data tab property) where in you want the data based on two different fields. If you wish to manage this way, we need to apply left join and filter or just filter or union query. Union query won't allow to edit the record where filtering will do but this needs one line of VBA coding to update the key. I can show you over a call. Thanks
€20 EUR në 1 ditë
5,0 (23 përshtypje)
5,0
5,0
Avatari i Përdoruesit
Greeting, I have understood your Assistance with MS Access Database Creation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Programming, Excel, Microsoft Access, SQL, Visual Basic
€50 EUR në 1 ditë
4,8 (13 përshtypje)
5,3
5,3
Avatari i Përdoruesit
Hello, If you want just to view these records, you can use the method implemented in the demo. But this method only for see the records. If you need edit/add records, then without VBA it will fail.
€23 EUR në 2 ditë
5,0 (30 përshtypje)
5,2
5,2
Avatari i Përdoruesit
Ciao I have worked with MS Access for 18 years and would be more than happy to assist you where needed. Sounds like you just need a guide as you learn and make updates to your database which I am more than happy to do. Let me know if you would like to discuss in more detail. --- UPDATE I can see the problem with your database. You should change the structure of the people_link table Mike
€13 EUR në 1 ditë
4,8 (3 përshtypje)
4,2
4,2
Avatari i Përdoruesit
I am senior software engineer, developing mobile application and website using technology java, spring and hibernate, html, css, ajax, jquery I have worked on also JSF, backbone JS, groovy and grails, ruby and rails I have worked on Mysql, Oracle and Postgres Data Base. I have a team which have skill of data entry, I am looking for data entry related project also others. I believe in work quality and to provide work on time.
€13 EUR në 1 ditë
5,0 (1 review)
3,4
3,4
Avatari i Përdoruesit
A proposal has not yet been provided
€29 EUR në 1 ditë
5,0 (1 review)
2,8
2,8
Avatari i Përdoruesit
A proposal has not yet been provided
€23 EUR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
€24 EUR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
€19 EUR në 30 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
€23 EUR në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have over 28 years' as a technical writer, developer, and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. These are totally menu-driven, security-enabled applications that include functionality such as excel-enabled imports and exports, PDF reports, charts and graphs, snapshot reports, embedded Visual Basic and dynamic SQL, complex multi-level searches, and more. I find the multiple tables and relationships between them interesting. I also enjoy reporting and the challenges of presenting and manipulating data to provide the most benefit. Having presented to C-level executives (and having been one myself) I appreciate the criticality and value of properly designed databases and reports. They can speak volumes. I would like to be of assistance. Let's get started.
€30 EUR në 3 ditë
0,0 (0 përshtypje)
2,2
2,2
Avatari i Përdoruesit
I've create (design and implementation) several complex MS Access applications. What you are looking for is very simple and potentially could be a very flexible tool for you to work with. I can create a sample for you, based on your schema db, and work with you on this (va teamviewer/skype call) for you to understand how you should proceed and/or create something more permanent (e.g.: a dynamic search for your data through a form maybe?)
€29 EUR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i ITALY
Italy
0,0
0
Anëtar që nga mar 3, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.