Find Jobs
Hire Freelancers

Assistance with MS Access Database Creation

€8-30 EUR

Stengt
Lagt ut omtrent 6 år siden

€8-30 EUR

Betalt ved levering
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.
Prosjekt-ID: 16414701

Om prosjektet

26 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
26 frilansere byr i gjennomsnitt €27 EUR for denne jobben
Brukeravatar
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 om 2 dager
4,9 (590 omtaler)
8,5
8,5
Brukeravatar
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 om 1 dag
5,0 (41 omtaler)
6,2
6,2
Brukeravatar
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 om 1 dag
4,7 (86 omtaler)
6,6
6,6
Brukeravatar
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 om 1 dag
4,9 (73 omtaler)
5,9
5,9
Brukeravatar
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 om 1 dag
5,0 (77 omtaler)
6,0
6,0
Brukeravatar
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 om 1 dag
5,0 (95 omtaler)
5,9
5,9
Brukeravatar
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 om 1 dag
4,9 (41 omtaler)
5,8
5,8
Brukeravatar
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 om 1 dag
5,0 (35 omtaler)
5,4
5,4
Brukeravatar
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 om 1 dag
4,8 (13 omtaler)
5,3
5,3
Brukeravatar
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 om 1 dag
4,7 (25 omtaler)
5,0
5,0
Brukeravatar
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 om 1 dag
4,8 (3 omtaler)
4,1
4,1
Brukeravatar
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 om 1 dag
5,0 (1 omtale)
3,4
3,4
Brukeravatar
A proposal has not yet been provided
€29 EUR om 1 dag
5,0 (1 omtale)
2,8
2,8
Brukeravatar
A proposal has not yet been provided
€23 EUR om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
A proposal has not yet been provided
€24 EUR om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
A proposal has not yet been provided
€19 EUR om 30 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
A proposal has not yet been provided
€23 EUR om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
2,2
2,2
Brukeravatar
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 om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

ITALYs flagg
Italy
0,0
0
Medlem siden mar. 3, 2018

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.