Find Jobs
Hire Freelancers

Build an Access database that autofills and prints forms

$10-30 USD

Đã hoàn thành
Đã đăng vào hơn 7 năm trước

$10-30 USD

Thanh toán khi bàn giao
Hello, I have an excel spreadsheet that has balances owed to me. The spreadsheet contains a variety of useless columns and about 100 rows that I import into an Access (2010) table. I then create a query that only shows the following information that I need: Account #, name, address, open amount, 90 - 120 Days, and 121 - 150 Days. Then I create a form that auto populates the name, address, and open amount based off the account#. The end result is I print the form and put it in an envelope and mail it to the client as an invoice. If it is possible what I need is an access template where I can add the data as outlined above that would allow me to select certain rows, like say all the rows that have a balance in the 90 - 120 Days columns and press a print button that automatically prints each form for each of the selected rows. In other words, I need to be able to send like 20 forms to the printer by somehow selecting only the rows I want? Or maybe somehow tell access what rows need forms filled out and then on a report have those forms listed and press a print all button. I hope this makes sense. FYI, I cannot provide any real data to you. Thank you.
Mã dự án: 12792806

Về dự án

12 đề xuất
Dự án từ xa
Hoạt động 7 năm trước

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

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:
Avatar người dùng
Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Access. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Price might be negotiable during discussion. Pm me for more information and sample as well. Let me know the full specifications of the project. Thank you very much for your opportunity to bid. RoyalCalif
$30 USD trong 1 ngày
4,9 (38 nhận xét)
5,4
5,4
12 freelancer chào giá trung bình $62 USD cho công việc này
Avatar người dùng
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$100 USD trong 3 ngày
4,8 (82 nhận xét)
6,5
6,5
Avatar người dùng
Hi For your project I'll make standalone ms Access app with excel automation providing all your assignments, auto export/import , automobile, auto print, autopdf etc Thanks, and regards Zura
$222 USD trong 2 ngày
4,6 (40 nhận xét)
6,0
6,0
Avatar người dùng
A proposal has not yet been provided
$30 USD trong 2 ngày
4,8 (65 nhận xét)
5,5
5,5
Avatar người dùng
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details. I'm looking forward to hearing from you. Regards,
$25 USD trong 1 ngày
5,0 (50 nhận xét)
5,3
5,3
Avatar người dùng
Hi, You use Access just to filter data and create invoice or also for storing them too? I can develop a tool in Excel, which will query data you like and make invoice for them. It will create a list of all invoice in MS Word in each page, which you can print. If you cant send actual data for review, you can send a blank file with couple of dummy data. Which will help in understanding structure of file/table. Lets discuss in detail. Thanks
$60 USD trong 1 ngày
4,9 (12 nhận xét)
4,3
4,3
Avatar người dùng
Hey there, From the sounds of it, you need an Office expert who can write optimized formulas, VBA code and SQL queries to print invoices to your customers based by your data. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database (Ms Access, Sql Sever) and analytic background that could be a profit in your project. I've completed microsoft;s exams 70-461 (Quering Sql Server) and 70-462 (Administering Sql Server) I've successfuly completed many projects for random clients. Always on time and budget. What is your favorite way to comunicate? I understand that you can't send any real data, but could you provide fake data in real format? Do you have template (any format) of form that you want to print? Are you sure that you want to do this in access? I'm pretty sure that you reaquest can be realized in excel. Your source data is in Excel, so why do you want to import it elsewhere to get simple report/form? Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm really good business partner. Best regards, Rafael.
$25 USD trong 3 ngày
5,0 (5 nhận xét)
3,8
3,8
Avatar người dùng
Good Day, I am writing with reference to your posted job for want of a MS Access Developer. I consider that my credentials and interests match with your requirement and want to propose for the same. Looking forward hearing from you soon. Kind Regards, Marco
$25 USD trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I would love to do this for you. You clearly know what you want. let's work together and bring this about!
$20 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Excel and Access.
$55 USD trong 5 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
St. Louis, United States
5,0
7
Phương thức thanh toán đã xác thực
Thành viên từ thg 4 9, 2013

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.