Find Jobs
Hire Freelancers

Access Database Query Development

£10-20 GBP

Cerrado
Publicado hace alrededor de 1 mes

£10-20 GBP

Pagado a la entrega
write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru
ID del proyecto: 37988633

Información sobre el proyecto

42 propuestas
Proyecto remoto
Activo hace 2 días

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
42 freelancers están ofertando un promedio de £19 GBP por este trabajo
Avatar del usuario
Hello! I'm a Databases Developer, Access, Excel and VBA expert more than ten years. I have completed many complex projects in my practice and I am ready to carry out your in the reasonable price and in the shortest possible time and with the highest quality. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f Regards, Vladimir
£15 GBP en 1 día
4,9 (239 comentarios)
7,1
7,1
Avatar del usuario
Hi I'll do asap. I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. Please visit https://www.freelancer.com/u/zu02?w=f Here you can also find reviews such as: "Zurab is an MS ACCESS genius","Zurab is Messi of Office" etc. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Zurab
£20 GBP en 1 día
4,7 (76 comentarios)
6,5
6,5
Avatar del usuario
As an experienced database programmer with a keen eye for detail, I believe I am the right person for the query development task. With a diploma in project management and CCNA certification, I have a thorough understanding of databases and the necessary skills to handle your project. I have spent 5+ years solving complex programming problems, and I am confident that this Access database query development is well within my wheelhouse. My prowess in database schema design and management, which includes ERD design and normalization, means that your database is in skilled hands. Commitment, reliability, time-consciousness, and honesty are values that I hold dear to me as a freelancer; you can be assured of timely delivery of high-quality work with no room for plagiarism. Click "Hire me" on my profile "https://www.freelancer.com/u/kaindo2017" to launch us into this fruitful partnership where perfection and satisfaction are top priorities. Let's make your request a success!
£50 GBP en 8 días
4,8 (23 comentarios)
5,2
5,2
Avatar del usuario
Hi, Created and ready. A single query to update merge table with the last customer added in the customer table, merge table will always have one record (the last customer)
£20 GBP en 1 día
5,0 (9 comentarios)
4,5
4,5
Avatar del usuario
Hello I am working with MS-Access database and VBA for the past 20 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your project specification and the file that you have asked for reference. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
£15 GBP en 1 día
4,8 (31 comentarios)
4,6
4,6
Avatar del usuario
Having been in the IT industry since 2015, I am well-equipped with the necessary skills in Database Programming, Microsoft Access, and SQL to efficiently tackle any query-related task. Tasked with copying the last record from the customer table to overwrite any existing entry in the merge table, I can guarantee a seamless solution that leaves only one record at all times in the merge table. My knowledge and expertise in access database management will ensure that your testdb access database functions optimally. Moreover, at CTS Cura Tech Solution, we approach every assignment with a commitment to excellence and a passion for leveraging technology to drive success for our clients. Our collaboration-driven methodology would ensure not just an effective query but also clear documentation for future use. With us on board, you can trust that this seemingly simple task will be completed with utmost accuracy and efficiency. Choosing my services means opting for a reliable partner who understands the value of staying ahead in a changing economy. With an unwavering dedication to providing cutting-edge software solutions, CTS delivers top-tier results at competitive rates. I assure you that after working with me, you won't have to reconcile records manually - your merge table will consistently contain the most recent record available. Partnering with CTS guarantees comprehensive solutions that amplify your business operations – let's get started!
£20 GBP en 1 día
5,0 (1 comentario)
3,9
3,9
Avatar del usuario
Hello, Can we discuss the project details over chat? I am MS full stack developer having expertise in developing web, desktop application and I think I can manage this project well. I can share my project examples with you. Hope to hear from you soon. Thanks
£15 GBP en 1 día
5,0 (6 comentarios)
3,7
3,7
Avatar del usuario
Hi, I have 11+ years of object-oriented architecture designing, programming, and administration experience with success in devising software solutions to meet business requirements. - Full-stack developer with C#.NET and VB.Net in the back end and javascript, knockout, and angular in the front end. - Development of database structures (MS SQL, Access, MySQL) - Crystal report, TelerikReport. - Development of ASP.NET, MVC website. - Development of desktop applications: WinForm, WPF. - Selenium automation I will be very reasonable as I believe in a long-term relationship. If you want me to do this task please get in touch with me.
£10 GBP en 1 día
5,0 (6 comentarios)
3,2
3,2
Avatar del usuario
hi I am one of staff about datacube.com.au. our company developed a lot of Access DB for client. and I coded for Access DB almost fifteen years. I can show you some of my work. please contact me asap. I can do wonderfully job for your. and our company is hosted on Perth. look forward to your reply. Best regards Bill
£50 GBP en 7 días
5,0 (1 comentario)
2,7
2,7
Avatar del usuario
Hi there, I have made a query but you should award a project so I can send it to you via messenger. No option to send a file otherwise. Thanks, Hiral
£20 GBP en 1 día
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
I am Hafiz Syed Ahsan, an SQL expert with a demonstrated history of delivering timely and satisfactory results for over 80 projects spanning my nine-year career. Considering your project is well within my field of expertise; I can confidently say that I could execute this task with the acumen expected of an over-9-year-experience developer like me. My mastery in SQL coupled with my meticulousness when it comes to data manipulation will ensure that the customer table details are accurately copied to the merge table. Beyond just writing a query, I'm attentive to details meaning I don't execute any actions without considering all possible scenarios. For instance, in this case, where you require only one record in the merge table, I will write a script that checks if there's a record in the merge table and only then proceeds to overwrite without omission or duplication. This is ultimately what sets me apart from other freelancers you might be considering for this job. I understand your key expectations: efficiency, accuracy, and on-time project delivery. As someone who has championed a hundred percent satisfaction over my career, assuring quality output and timely delivery is just but a norm for me. Minus saying more about my qualifications listed above, resorting to my profile history will affirm this commitment I offer as well as attesting to the unmatched service level I imprint on every project handed to me. Allow me serve you proficiently.
£35 GBP en 2 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
£10 GBP en 1 día
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
As an HR and recruiter who specializes in database programming and SQL, I am uniquely positioned to handle your Access Database Query Development project. With a strong background in SQL querying, I can easily write the query requested in the customer database to copy the last record created and overwrite any existing record in the merge table. My proficiency in handling different databases and my knowledge of multiple programming languages ensure that I am equipped with all the skills necessary to deliver this task on time, every time. In addition to my technical skills, my extensive experience as a freelancer has honed my abilities to communicate effectively, pay attention to detail, and deliver high-quality work under tight deadlines. Given that there should only be one record in the merge table as per your requirement, you can rest assured that I will ensure the utmost accuracy in my work. Lastly, what sets me apart is not just my technical expertise but also my multi-lingual fluency which allows me to connect and comprehend client instructions more effectively. This means I'm more than capable of understanding your vision for your project better even if it's a 'piece of cake' as you've described here. I'm very much excited about this opportunity and look forward to helping you streamline your database operation through this project.
£15 GBP en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
As a highly qualified professional with an extensive background in database programming, your project is a perfect match for my skillset. My team and I have worked with numerous clients all over the world delivering 100% satisfaction. We have over 10 years of experience working with different databases and writing complex SQL queries, making us more than equipped to handle your task. Our experience working in similar domains such as MySQL and SQL Server will assure you that we have a deep understanding of extracting, organizing and managing data. So tackling a simple task like copying the last record from one table to another is not new to us. We pride ourselves on our ability to deliver high-quality work within the agreed-upon time frame and at very competitive rates. Our understanding of SEO standards for your website development also ensures that you receive not just a functional solution but an optimized one. Finally, our commitment doesn't end upon delivery; we provide free unlimited revisions, extended support post-delivery, and even free on-page updates for the website. These are just some of the reasons why hiring us would be the best investment for your project; we're excited about the possibility of working with you! Let's chat and get started!
£15 GBP en 7 días
0,0 (0 comentarios)
0,9
0,9
Avatar del usuario
Hi, I've reviewed your project description, and I'm confident I can assist you with your database query needs. With my experience in database management, I'll craft a query to copy the last record from the customer table to the merge table, overwriting any existing record. I believe open communication will help us refine the query to precisely meet your requirements. Thanks.
£20 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Expert in MS Access and MS SQL. 20+ years of experience. Clearly understood your requirement. Will deliver in 1 day. Thanks
£15 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Thank you for your detailed explanation and instructions on how to implement the SQL query within our Access database. Your step-by-step guidance is clear, and I appreciate your suggestions regarding the structure and possible automation with VBA. Before implementing, I'll confirm the alignment of data types between the customer and merge tables to ensure compatibility. Could you also provide some insight on how to set up this query to run automatically upon closing the database or at scheduled intervals? Your assistance is invaluable as we aim to maintain data consistency efficiently.
£15 GBP en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
As a highly qualified professional with an extensive background in database programming, your project is a perfect match for my skillset. My team and I have worked with numerous clients all over the world delivering 100% satisfaction. We have over 10 years of experience working with different databases and writing complex SQL queries, making us more than equipped to handle your task. Our experience working in similar domains such as MySQL and SQL Server will assure you that we have a deep understanding of extracting, organizing and managing data. So tackling a simple task like copying the last record from one table to another is not new to us. We pride ourselves on our ability to deliver high-quality work within the agreed-upon time frame and at very competitive rates. Our understanding of SEO standards for your website development also ensures that you receive not just a functional solution but an optimized one. Finally, our commitment doesn't end upon delivery; we provide free unlimited revisions, extended support post-delivery, and even free on-page updates for the website. These are just some of the reasons why hiring us would be the best investment for your project; we're excited about the possibility of working with you! Let's chat and get started!
£15 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello Do you want to create a report containing customer fields and order details? You shouldn't need to create a merge table please chat with me, I will help you, i will return your testdb access database Thank You
£10 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I understand your requirement to create a query in the attached database that copies the last record created in the customer table to the merge table, overwriting any existing record in the merge table. I'm confident in my skills with Access databases, and I can certainly assist you with this task. I will ensure that the query performs the required action efficiently and effectively. Could you please provide me with the attached database so that I can proceed with creating the query for you? Once I have access to the database, I'll promptly develop and test the query to ensure it meets your expectations. Looking forward to your response and the opportunity to work on this project.
£10 GBP en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Aberdeen, United Kingdom
5,0
19
Forma de pago verificada
Miembro desde oct 19, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.