Find Jobs
Hire Freelancers

access / excel database

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
Hello , I am trying to create a one to many relationship using several linked excel spreadsheets. I need the excel spreadsheets to be linked as they are updated on a weekly basis. Once the relationships are created I want to combine certain columns from each spreadsheet using a query. Once I have all the information I need on one table I need to import this into excel to create a profit per sale and total profit per month. I have already created a database that suited my needs perfectly using Vlookup and various formulas, however, it has become too big and heavy to use. I would like help and advice to optimize database. The above description with access is my theory on how to do this. If anyone can provide a more creative / effective way to assist I am all ears. I have tried doing this myself and I am coming across error messages that I cannot solve by myself.
Project ID: 20880705

About the project

46 proposals
Remote project
Active 4 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
46 freelancers are bidding on average $140 USD for this job
User Avatar
Dear Employer, I perfectly understand your job and have seen your attached sheet as well. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
$250 USD in 7 days
5.0 (228 reviews)
8.0
8.0
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
$220 USD in 5 days
4.9 (410 reviews)
8.2
8.2
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel workbook optimized to produce useful data such as profit. I plan to use a combination of formulas to accomplish this. I will charge you $130* and can deliver within a couple of days (I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$130 USD in 2 days
4.9 (360 reviews)
8.0
8.0
User Avatar
Hi, I am skillful accountant and Excel developer so you may expect the best here. Thanks
$100 USD in 14 days
4.9 (132 reviews)
7.1
7.1
User Avatar
Hi, Reading your project description about combining several downloadable report using unique reference number makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than just show you past similar projects, I want to exceed your expectations 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. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
$150 USD in 4 days
4.9 (62 reviews)
6.6
6.6
User Avatar
$ 30 ONLY!!! In just 3 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LEAST time and for LOWEST price. You can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar
$30 USD in 1 day
5.0 (229 reviews)
6.2
6.2
User Avatar
Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your merging and formatting job. Please share your project details over chat. BR, Razvan
$200 USD in 7 days
5.0 (19 reviews)
6.0
6.0
User Avatar
I can create the database by linking multiples files and creating report like profit per sale and profit per month from that, for optimizing the database and process , i would use VBA macros instead of formulas, please initiate chat to discuss this in detail. Please find below a brief introduction of myself. I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$200 USD in 2 days
4.9 (47 reviews)
5.8
5.8
User Avatar
Hi I'll code all via ms access . The interface will be very friendly. Regards Zurab ms access/vba coder since 1997.
$277 USD in 3 days
4.7 (65 reviews)
6.2
6.2
User Avatar
Thank you for giving me the opportunity to express my interest on your project. This project is related to my are of expertise. I can provide you best support on your project. let's have a chat and I am highly interested to take care of your project.
$250 USD in 5 days
4.9 (31 reviews)
5.7
5.7
User Avatar
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$120 USD in 3 days
4.8 (104 reviews)
5.9
5.9
User Avatar
Hi there, Greetings! I am an experienced MS Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Office applications. I have done more than 1000 MS Access database projects and happy to show you a demo on a chat. Let's get on a chat to discuss your requirements in detail. Thank you, Rayyan
$200 USD in 7 days
5.0 (22 reviews)
5.0
5.0
User Avatar
I am a Chartered Accountant & Business Consultant. I have more than 5-year experience in the field of FINANCE, ACCOUNTING, AUDIT, RISK ASSESSMENT and BUSINESS MANAGEMENT. I have performed more than+50 accounts and business related assignment. I have audited financial institutions such as Insurance Companies, Leasing Companies and Banks, Currently, I am working as a Finance Executive in a leading roll in a technology-driven company Tech Access Pakistan Pvt Limited. I have also worked as a supervisor at the Audit and Assurance Department of Crowe Horwath Hussain Chaudhury & Co Chartered Accountants, Lahore Office, Pakistan. I can provide you with all your required services including Business Plan Writing, Management Overview, Financial Statements in accordance with IFRS/GAAP, Financial Modelling (Budgeting and Forecasting), Financial Analysis, (SWOT, PESTAL,ICFR,CAR,CRR,LCR,Process Flow,Exposure, project risk profiling, value for money analysis transaction structuring and many others.
$140 USD in 7 days
4.5 (28 reviews)
4.3
4.3
User Avatar
SHOWCASE I have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-design-18665960/ • https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ • https://www.freelancer.com/projects/database-programming/data-base-search-options/ I can also produce a sketched prototype for this project and upload on YouTube. INTRODUCTION I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. 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
$140 USD in 7 days
4.4 (6 reviews)
4.5
4.5
User Avatar
Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have read your description could you contact me for details
$60 USD in 7 days
5.0 (6 reviews)
3.7
3.7
User Avatar
The choice of formulas you choose makes the Excel file heavy. We can use different formula which makes the files less heavy and easy to scroll. If data is not so large, Excel can be used, otherwise Access will be needed. Howver, by the look of sample you provided, it looks a fairly easy job.
$60 USD in 2 days
5.0 (15 reviews)
3.6
3.6
User Avatar
Hi, I would like to suggest you to use MySQL as database. This can handle huge database and we can generate many reports like you need. Please let me know if we can discuss in more details. Thanks.
$200 USD in 7 days
5.0 (3 reviews)
3.7
3.7
User Avatar
Hi Sir I am interrested in this project. My name is Faiz and im an Actuary and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and data visualization. I promise you for a quality work at an effordable price on time. Expecting a reply soon. Thank you.
$30 USD in 2 days
5.0 (5 reviews)
2.7
2.7
User Avatar
Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like develop the database using MS Access as per your requirement and input provided by you.
$100 USD in 3 days
3.6 (10 reviews)
3.9
3.9
User Avatar
I am working with skills that you required for this job from 16 years. I am working with VB 6.0,COM,ActiveX,MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. You'd also be delighted to know that I have acquired the Information Technology extensive education, that's why I'm confident that I can be a great asset to your organization. I am willing to work for 40 hours per week to help you with your project. Please contact me with your interest to discuss next.
$250 USD in 7 days
5.0 (3 reviews)
2.4
2.4

About the client

Flag of COLOMBIA
Envigado, Colombia
0.0
0
Payment method verified
Member since Mar 23, 2019

Client Verification

Other jobs from this client

Web scraping
$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.