Find Jobs
Hire Freelancers

Create Multi-Component Reports from Access DB

$250-750 USD

Completed
Posted over 5 years ago

$250-750 USD

Paid on delivery
Project is to create 2 series of reports from existing, large database: "Indicator reports": These should be pivot tables in an Excel document linked to the database. There are 26 indicators, each requiring a pivot table. Ideally, all pivot tables should be housed in a single Excel document, one pivot table per page. "Profile reports": These include up to 20 report components, drawing data from different database tables. Some simple graphics included (ie bar charts). This report could be produced in Excel or Access, depending on technical feasibility. Suggestions are welcome on how to improve structure and methods. Please find attached a sample of the report types in a single Excel document. Note that all "Profile reports" will require similar report components.
Project ID: 18534714

About the project

24 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am expert in Excel, Access VBA, MySQL, Google Sheet and Power BI. I can database and can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dynamic dashboards and Reports. I have checked the excel file, I can complete all your reports in excel or Power bi if you want. please send me your data and details I will complete a part of it for free in 12 hours and will send you. after checking my work you can decide to award me. I have completed many similar projects before, you can check some of my previous works here. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] waiting for your reply, Thanks
$250 USD in 5 days
4.8 (78 reviews)
6.1
6.1
24 freelancers are bidding on average $445 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$500 USD in 10 days
4.9 (346 reviews)
8.0
8.0
User Avatar
Hi! I understand what needs to be done, but I have one question - why you need pivot tables in Excel? I can make an export from DB to Excel (VBA is required and on Windows only, on Macintosh, it is quite troublesome), but since we have it in Access already, why not making a report in Access. Excel has better charting capabilities of course, and if that is the reason, then it makes sense. Overall, most of those can be achieved by some queries (SQL) and where needed I will write VBA code. We can talk about the details in the chat! Regards, Branislav Mihaljev
$611 USD in 10 days
5.0 (270 reviews)
7.6
7.6
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make your database reporting in excel Sir via VBA macro script so it will easy to use for user admin and also im familiar also with pivot table and bar chart please ping me for discuss more and im able to discuss now Thank you Galih
$250 USD in 10 days
4.9 (367 reviews)
7.2
7.2
User Avatar
I develop modules in Microsoft Excel by VBA with a direct connection to Access. The module builds a structured database for pivot tables and produces immediate reports and graphs. About Me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience in implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace.
$500 USD in 10 days
4.9 (89 reviews)
7.1
7.1
User Avatar
Hi there, sir i read your initial requirements and i have some question regarding to your access report project. please send me message so that we could discuss it further.
$250 USD in 5 days
5.0 (40 reviews)
6.6
6.6
User Avatar
Hi, You won’t make the right candidate selection without knowing what your project on creating two series of reports using an existing MS Access database will look like. Fortunately, I can show you how your job will look like before you award the project. Rather than just show you past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks
$250 USD in 10 days
4.9 (52 reviews)
6.4
6.4
User Avatar
Hi! There, My Name is Dipak Moliya, You have been invited me to bid on this project. I am able to make any complicated reports in Access and some reports in excel like pivot table etc... I am interested. So bidding on this project. I will be able to complete this project(26 Indicator Reports and 20 Profile reports ) for $555 USD. Thank you for inviting me on your project. Best Regards.
$555 USD in 20 days
5.0 (81 reviews)
6.6
6.6
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access and Excel, of course, familiar. Give me a chance to show what I can do!
$500 USD in 7 days
4.9 (182 reviews)
6.7
6.7
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Well. I would discuss a way that I would proceed to prepare these reports at the beginning of the job. Willing to take up your project. Thank you, Regards.
$700 USD in 7 days
5.0 (118 reviews)
6.5
6.5
User Avatar
Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards
$555 USD in 10 days
5.0 (13 reviews)
6.0
6.0
User Avatar
INTRODUCTION I can see you are interested in building reports from the existing access database. I can analyze requirements and create reports, create interactive dashboards, on-demand reports, and visualizations together with other specified business intelligence searches and lookup integrations. I am smart enough to take your business requirements and create reports to reflect the intent of your requirements. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/php/Building-Automatic-weekly-monthly/ • https://www.freelancer.com/projects/php/Project-for-fanninson-11770082/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$300 USD in 10 days
4.8 (25 reviews)
6.0
6.0
User Avatar
Hello I hope all's well with you. I would like you to consider me as a programmer for your project. Please look at following screens in my portfolio here: "Create sales and purchases database application" and "Invoice & book-keeping management" , you can view graphs how I coded there with Ms Access app. So you can find some similarities. I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses- please see my portfolio here. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I charge $750 , but I can offer a lower rate. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab Esartia
$750 USD in 10 days
4.6 (56 reviews)
6.2
6.2
User Avatar
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$250 USD in 4 days
5.0 (37 reviews)
5.0
5.0
User Avatar
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.
$500 USD in 10 days
5.0 (7 reviews)
4.1
4.1
User Avatar
Hello, My name is Waseem, I read your project and found a solution for your case which I have already done in the past. In my previous job I had a huge MS Access database that has all data I need for my reports, there was utility to link Access to Excel and get customized report and pivot tables in Excel, I think that would be the best solution for your case. I suggest to you to follow the same approach and since I have done it in the past I would make sure you will get the easiest way possible to have it implemented. Some clarification that I would understand from you about the database you have and then we are ready to go. Please let me know if you are interested in my offer so we can move further. Thank you Waseem
$300 USD in 10 days
4.9 (6 reviews)
3.4
3.4
User Avatar
Hello i'm a computer engineer from Greece with working experience in ms access development for more than 4 years (working in an IT company). If you are interested in my profile we can discuss more details about your project Please don't hesitate to contact me Regards
$377 USD in 10 days
5.0 (2 reviews)
2.8
2.8
User Avatar
I am honored to have done this work to you I have sufficient experience in this area You can communicate with me to accomplish this task with ease
$277 USD in 3 days
5.0 (2 reviews)
1.9
1.9
User Avatar
I have 10+ years of Experience in the software industry in designing, development, maintenance & application deployment. • Hands on experience of coding and bug-solving in core Java, Spring boot,Spring Data JPA, Spring MVC, Spring JDBC template, Hibernate, Enterprise Java Bean, Java Persistent API, Java server faces,Jersey, Pivotal Cloud Foundry, Amazon web service, Jenkins, Source control repository (GIT, SVN). • Strong Experience in making the application deployments into the Server(Glass- fish, Apache tomcat & IBM Web-sphere). • Easiness to become familiar with new technologies and paradigms. • Experienced to team management as well as independent working & individual contributor. • Possess good communication skills
$722 USD in 10 days
5.0 (1 review)
0.1
0.1
User Avatar
I will do
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 5+ years of experience in Excel VBA macros. Large data manipulation and visualization is my specialty. Reading large data sets from external Access databases can be problematic due to the limitations of Excel so it depends on how large is the data set.
$400 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MOZAMBIQUE
Maputo, Mozambique
5.0
6
Payment method verified
Member since Oct 1, 2018

Client Verification

Other jobs from this client

Revision of a database
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.