Find Jobs
Hire Freelancers

Current Access Database - Generate Formatted Excel Files Populated with Data From Form Queries

$250-750 USD

已完成
已发布将近 9 年前

$250-750 USD

货到付款
I have an existing access database that I need 3 forms built that will each run a query to generate 3 different excel files populated from specific data from the access database. I've attached the 3 excel template that the outputs will need to look like. The 3 forms will need the ability to check mark/multi-select a list of employees pulled from the employee table and then generate an excel sheet with information pulled from the access database. This excel outputs are called the "Personal Profile", "Manifest" and the "Training Record Summary". In the excel templates I've put a $variable name that corresponds with the column names in the database tables. I've also attached the ERD Diagram and the excel templates. I can share the actual database as well if needed. PERSONAL PROFILE FORM Options: -Muli-Select dropdown or check boxes to select multiple employees Cells Populated From Database: -First_Name -Last_Name -Position -Call_Sign -Weight -Incident_Date -Incident_Number -Client -Days -Training_Date -Course_Name -Course_Number If in the form for example, 10 employees are selected, then there would be 10 personal profile excel file generated, 1 per employee. MANIFEST GENERATION FORM Options: -Muli-Select dropdown or check boxes to select multiple employees -Dropdown Choose Crew Type (5, 10 or 20 Person Crew, First Aid) -Enter Mobilization Date Field (Default to Current Date) -Crew Name Dropdown (Phonetic Alphabet, example Alpha, Bravo etc) Cells Populated From Database: -Call Sign -Initial -Position -Last Name -First Name TRAINING RECORD SUMMARY Options: -Muli-Select dropdown or check boxes to select multiple employees Cells Populated From Database: -Date (current date auto-­input) -Last Name -First Name -Initials -Employee Position -Employee Call Sign Course Cells: -ICS I100 -ICS 1200 - S100/S100A (has to be <1 year of expiry) -S185 -S212 -S230 -First Aid (Show value of $Course_ID if less than $Expiry Date) -Danger Tree Assessor -Power Saw Operator -Moderate Fitness Test (If employee has valid course "X" will be entered into cell. For first aid will be a 1,2 or 3 depending on valid first aid level they hold. ) All course will need to meet some conditions to make sure they are valid and be associated with an employee: a) If course is identified in the course table as needing rectification after a period of time, Current date has to be within validity period or training_date b) Has to have have a passing test score value value Thanks,
项目 ID: 7733169

关于此项目

25提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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.
$250 USD 在5天之内
4.8 (23条评论)
5.1
5.1
25威客以平均价$418 USD来参与此工作竞价
用户头像
Hello, I saw the summary of your project and I would like have the opportunity to work with you. I have availability to start as soon as possible. I am TOP 4% over more than 14 million of freelancers. I work with values of transparency, honesty and high level of quality. I believe in long term relationship with my clients. I invite you to see my profile at: https://www.freelancer.com.es/u/eduardocubel.html If you have any question, please feel free to ask me. Yours Sincerely, Eduardo
$655 USD 在7天之内
5.0 (8条评论)
6.1
6.1
用户头像
Hi, I'm an expert VBA / Excel / Access / database programmer and can do the job for you. I can develop the user interface forms for the database and the needed functionality to make the database work as you indicated. I especially have experience with data export / queries to Excel. I can deliver in 2 days. Good quality work done. I also offer free support after the job is complete for any fixes. Thanks for considering my bid. Bests, Larry ps: My Timezone is GMT+1 (Malawi), this is good because I work at night and by your morning, you would have the work ready.
$250 USD 在2天之内
5.0 (23条评论)
5.4
5.4
用户头像
Hi, I can complete this project for you. My plan of actions: 1. Create blank of Access database from ERD Diagram. *Completed (I had created it already). 2. Create 3 forms using description of this project (with export to Excel template ability). 3. Test result. 4. Post results for you Regards, programmer Aleks
$250 USD 在3天之内
5.0 (57条评论)
5.1
5.1
用户头像
Dear Buyer, I am working as a programmer since 1984. With Access databases I have been involved since 1998. I went through your Excel templates and database diagrams. Not tough project - can be easily done with VBA use. Is version 2010 suitable for your needs ? Other than this, I am ready to start immediately. Many thanks in advance for seriously considering my bid. Looking forward to hearing from you soon. With best regards, Solon ...
$250 USD 在5天之内
4.9 (24条评论)
4.7
4.7
用户头像
Excel & Access developer since respectively 1997 & 2000. Can certainly do. Regards, Svet.
$722 USD 在5天之内
5.0 (3条评论)
4.5
4.5
用户头像
Предложение еще не подано
$526 USD 在10天之内
5.0 (5条评论)
3.8
3.8
用户头像
Hi, I am 12+ years experienced Visual Basic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,XML,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) , oracle developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern
$315 USD 在3天之内
4.7 (5条评论)
3.7
3.7
用户头像
Give me you database with some sample data, to save the time. I will do my best to make it in 2 days. Reply for more discussions. Thanks
$250 USD 在3天之内
5.0 (8条评论)
3.0
3.0
用户头像
Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.
$250 USD 在3天之内
5.0 (4条评论)
2.2
2.2
用户头像
Hi, I have more than 14 years of MS Access, VBA/Excel exp and I am expert in this kind of work. I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 USD 在10天之内
5.0 (4条评论)
2.2
2.2
用户头像
Experience of VBA and MS Office development more than 15 years. The complete cycle of software development for the enterprise.
$444 USD 在10天之内
5.0 (1条评论)
1.2
1.2
用户头像
Hi I'm Microsoft Certified Database Developer & Administrator. With MS Access I working since it first version. With work I could start immediately.
$250 USD 在3天之内
5.0 (1条评论)
0.4
0.4
用户头像
Hello, I have worked as an analyst for the past 10 years in Europe. I have already made some good work in Excel and Access in Freelancer, but I have never had the opportunity to take care of a project combining both Tools while I have capabilities to make it happen. If you have any question about my bid, please let me know.
$277 USD 在3天之内
3.6 (1条评论)
0.6
0.6
用户头像
I have read and fully understood your requirements. Please open chat to discuss further….. =================+++++++++++++++++++++++++==================
$250 USD 在10天之内
0.0 (0条评论)
2.4
2.4
用户头像
Sir, We would love if we can get a chance to serve you. We will make a C# application , which will extract data from Acess and arrange in Excel. We would lke to share that we have done almost same work before for a local firm here in India. We are waiting for a response from you. Thank you
$277 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$722 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$250 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello, I have real experience 15 years working SQL SERVER advanced queries and reports; strong knowledge in Access,Excel 2010-2013 designs and queries (+VBA) Interested in this project and able to start immediately!
$300 USD 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$255 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I have 15+ years experience delivering Access, Excel, VBA solutions to financial institutions in London. I can provide a robust solution to your spec with a quick turn around. Kind regards Jason Bailey
$555 USD 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

CANADA的国旗
Vancouver, Canada
5.0
144
付款方式已验证
会员自2月 19, 2006起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。