Find Jobs
Hire Freelancers

Build an Access database that autofills and prints forms

$10-30 USD

Завершено
Опублікований over 7 years ago

$10-30 USD

Оплачується при отриманні
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.
ID проекту: 12792806

Про проект

12 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 1 день
4,9 (38 відгуки(-ів))
5,4
5,4
12 фрілансерів(-и) готові виконати цю роботу у середньому за $62 USD
Аватарка користувача
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 за 3 дні(-в)
4,8 (82 відгуки(-ів))
6,5
6,5
Аватарка користувача
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 за 2 дні(-в)
4,6 (40 відгуки(-ів))
6,0
6,0
Аватарка користувача
A proposal has not yet been provided
$30 USD за 2 дні(-в)
4,8 (65 відгуки(-ів))
5,5
5,5
Аватарка користувача
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 за 1 день
5,0 (50 відгуки(-ів))
5,3
5,3
Аватарка користувача
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 за 1 день
4,9 (12 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (5 відгуки(-ів))
3,8
3,8
Аватарка користувача
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 за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I would love to do this for you. You clearly know what you want. let's work together and bring this about!
$20 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
St. Louis, United States
5,0
7
Спосіб оплати верифіковано
На сайті з квіт. 9, 2013

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.