Find Jobs
Hire Freelancers

Build a database using Microsoft Access

$30-250 USD

Terminado
Publicado hace más de 2 años

$30-250 USD

Pagado a la entrega
I am a business owner who needs to process data using Microsoft Access. On a weekly basis, I receive a CSV file with approximately 250,000 rows of data that consists of about 15 columns of data that I would like to process. I have created tables that can show you what information I want to work with. I need to be able to use forms to select parameters (such as zip/postal code, city, date of license, etc.) so that I can generate a report that will give me a listing of all individuals who fall within those parameters. Then I need to export that report to an excel spreadsheet. I plan to use those spreadsheets as mailmerge listings when I use Microsoft Publisher to send out email flyers to potential customers. I have built the tables in a way that I want the data to look, but I want to have Access be able to take the raw data and put it into the table format when I want to update my information. I know this is possibly hard to follow but would welcome more detailed Q/A. I have attached some screen shots of some tables that I've been working with but I don't have time to lean all that I need to learn in order to process the data the way I want it. Summary: I want to use Access or Excel to automatically produce a table or spreadsheet that I can dump into an Access database. The table will have to be the result of processing the raw CSV data so that it only uses the columns that I want to use and discard the columns that I do not need to see. Then I want to use Access Forms to select parameters such as "Distance" or "Area", "LicYEAR" (which I want to be derived from the LicDate, "LicType", .... to become part of the criteria of the query in order to produce a result that can be output to a spreadsheet. I would also like to be able to update the "email sent" field to checked when the spreadsheet has been generated. I hope this makes sense. Thank you for your interest.
ID del proyecto: 31641245

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 3 años

¿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
Adjudicado a:
Avatar del usuario
Hello! I'm a Databases Developer, Access, Excel and VBA expert more than seven years. I have completed many complex projects in my practice and I am ready to carry out your project 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 From the Microsoft Access, of course, familiar. Regards, Vladimir
$150 USD en 3 días
4,9 (249 comentarios)
7,1
7,1
36 freelancers están ofertando un promedio de $156 USD por este trabajo
Avatar del usuario
Senior Visual basic , Database Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$150 USD en 2 días
4,8 (114 comentarios)
5,4
5,4
Avatar del usuario
Hello I am working with MS-Access database and VBA for the past 18 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. 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
$111 USD en 3 días
4,9 (41 comentarios)
5,1
5,1
Avatar del usuario
Greetings! My name is Sergey, I'm from Kyiv, Ukraine. I have 25+ years experience with MS Excel/Access/VBA/SQL: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Looking forward for further clarifications of details. Regards, Sergey
$150 USD en 7 días
4,9 (14 comentarios)
4,7
4,7
Avatar del usuario
Hi, I am interested in your offer as a developer with 10 years of experience. I want to do my best to you with my experience and diligent efforts. For a cheap price, you'll get more than you want in a short period of time. I hope you have enough discussion about the assignment. Thanks.
$140 USD en 7 días
5,0 (2 comentarios)
3,0
3,0
Avatar del usuario
Hello, I have more than 4 years of experience in MS Access and VBA programming. Let's discuss more in the chat. Thank you Best Regards
$150 USD en 7 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with database processing in Access. All clients call me "Prince of Access". I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!
$150 USD en 3 días
5,0 (2 comentarios)
1,6
1,6
Avatar del usuario
EXPERT IN NAMED SKILLS, OVER 18 YEARS OF EXPERIENCE, DEAR EMPLOYER, After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS as this is my area of PROFESSIONAL SPECIALIZATION having the above QUALIFICATIONS, i hereby humbly request you to consider my bid for QUALITY and PROFESSIONAL work. THANK-YOU.
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
=====Ms Access DB and Excel Processing Expert HERE ===== Dear Client! I am Liam from US. I have read your requirement and I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with Ms Access DB and Excel Processing, VB.Net and built many projects like this. I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!
$140 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I am a developer and I can help you with your requirements. Contact me for more information.
$50 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I Can Assist you with the entire software development life cycle. 1. Understand the requirements 2. Understand the Design.(Including Proper coding standards) 3. Implementing the design. 4. Unit Testing. 5. Deployment. 6. Documentation
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am good in filtering in excel & understood your requirement so kindly provide this project to me
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a VBA Expert with 3 years of expertise developing Excel workbooks utilizing Formulas, Complex VBA scripts, Pivot tables, Charts, and Custom Functions. In Microsoft Excel, I can address problems utilizing Formulas, VBA, Dashboards, Charts, and Data Connectivity. I can provide you the following services. 1) Data analysis using dashboards. 2) VBA scripts 3) Complex excel function. 4) Pivot Charts 5) Custom Functions 6) Financial models
$250 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This is possibly a challenging project, I understand most of the stuff you've indicated here and I think I am up for the challenging
$300 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have seen your job posting, I get imprecise idea about your requirements. Come over the chat for the task discussion. I need some brief introduction & all technical and non-technical details about your assigning task. Here is my intro, I’m a passionate developer and expert in mentioned skill set in a project. Let’s exchange some dialogs for the clarification about the project. I’ll show you me created works in chat box. Please check my certifications to estimate my skills. Regards,
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 18 years experience creating and designing robust databases for various purposes. I sm able automate the entire process of importing the CSV file and create a report for your use. I can also automate exporting report(s) in an excel file, and automatically generate an email with it attached. This can be set to automatically send or to only create and attach the file so it can be reviewed before bed no sent. If you have a standard message in the body of the email this can also be automatically generated. If there are portions that change depending on clients or scenarios I can pull the data from the database to populate those specific portions of the email and subject line, As part f the get-end there will be a form to allow for easy access to add/update email addresses associated with each client. I will work closely with you and listen to your needs and offer any insights and possible improvements I may have. I have built countless databases with similar requirements. I am often able to provide additional functionality in the database and VBA coding to surpass initial requirements required. I pride myself in building innovative and effective databases and exceeding expectations of the users.
$30 USD en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Garden Ridge, United States
0,0
0
Forma de pago verificada
Miembro desde mar 18, 2021

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.