Find Jobs
Hire Freelancers

Build a database using Microsoft Access

$30-250 USD

Tamamlandı
İlan edilme: 2 yıldan fazla önce

$30-250 USD

Teslimde ödenir
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.
Proje No: 31641245

Proje hakkında

36 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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 3 gün içinde
4,9 (249 değerlendirme)
7,1
7,1
36 freelancer bu proje için ortalama $156 USD teklif veriyor
Kullanıcı Avatarı
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 2 gün içinde
4,8 (114 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
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 3 gün içinde
4,9 (41 değerlendirme)
5,1
5,1
Kullanıcı Avatarı
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 7 gün içinde
4,9 (14 değerlendirme)
4,7
4,7
Kullanıcı Avatarı
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 7 gün içinde
5,0 (2 değerlendirme)
3,0
3,0
Kullanıcı Avatarı
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 7 gün içinde
5,0 (1 değerlendirme)
2,0
2,0
Kullanıcı Avatarı
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 3 gün içinde
5,0 (2 değerlendirme)
1,6
1,6
Kullanıcı Avatarı
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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
=====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 2 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hello, I am a developer and I can help you with your requirements. Contact me for more information.
$50 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I am good in filtering in excel & understood your requirement so kindly provide this project to me
$140 USD 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 4 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 4 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED STATES bayrağı
Garden Ridge, United States
0,0
0
Ödeme yöntemi onaylandı
Mar 18, 2021 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.