Build a database using Microsoft Access

$30-250 USD

Đã hoàn thành

Đã đăng vào

hơn 2 năm trước

$30-250 USD

Thanh toán khi bàn giao

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.

Mã dự án: 31641245

Về dự án

36 đề xuất

Dự án từ xa

Hoạt động 3 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@VladimirLilenko

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 trong 3 ngày

4,9

(249 nhận xét)

7,1

36 freelancer chào giá trung bình $156 USD cho công việc này

@merinsinha

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 trong 2 ngày

4,8

(114 nhận xét)

5,4

@KellogITSolution

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 trong 3 ngày

4,9

(41 nhận xét)

5,1

@SergeyKyiv

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 trong 7 ngày

4,9

(14 nhận xét)

4,7

@vovakovalkov80

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 trong 7 ngày

5,0

(2 nhận xét)

3,0

@sdineetha

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 trong 7 ngày

5,0

(1 nhận xét)

2,0

@albertogasulla

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 trong 3 ngày

5,0

(2 nhận xét)

1,6

@dominicnzioka197

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 trong 1 ngày

0,0

(0 nhận xét)

0,0

@nickoo0406

=====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 trong 2 ngày

0,0

(0 nhận xét)

0,0

@m7almasoud

Hello, I am a developer and I can help you with your requirements. Contact me for more information.

$50 USD trong 1 ngày

0,0

(0 nhận xét)

0,0

@SvvssSoft

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 trong 7 ngày

0,0

(0 nhận xét)

0,0

@rsavanur23

I am good in filtering in excel & understood your requirement so kindly provide this project to me

$140 USD trong 7 ngày

0,0

(0 nhận xét)

0,0

@andywarui

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 trong 4 ngày

0,0

(0 nhận xét)

0,0

@kkomen22

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 trong 7 ngày

0,0

(0 nhận xét)

0,0

@shafaqat16735

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 trong 7 ngày

0,0

(0 nhận xét)

0,0

@dangieske

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 trong 4 ngày