Find Jobs
Hire Freelancers

Access/Excel Assignment Specification

$30-250 AUD

Cancelled
Posted over 11 years ago

$30-250 AUD

Paid on delivery
Your client, Climber’s Paradise Inc, has contracted you to develop an Excel workbook based on the information contained in this document, using Microsoft Excel 2010. Luckily, you don’t have to start from scratch. The client had some basic Information Systems skills and already has a database from which you can extract data. They have already started to develop an Excel workbook as well, but gave up due to lack of skills. Your job is to take the available database (Access file available on Blackboard) and develop queries that will facilitate you to finish the Excel workbook that your client has started (the incomplete file is available on Blackboard). You should read the below requirements summarised by the client, decide which data you need to finish the workbook, write the appropriate queries to extract the data from Access, and then finalise the formulas and analyses required in Excel. You must include appropriate formulae and functions required to set up the workbook in such a way that formulae and functions are fully flexible and dynamic. In addition to the workbook itself, you are required to submit the Access database file containing the queries you developed for data used in Excel. Your Excel workbook must also include two charts that you feel are appropriate to illustrate your analysis The Client Climber’s Paradise Inc was established in 2011 by Gabe Walker who is an avid mountain climber and an accredited climbing instructor. Gabe offers his clients climbing expeditions and operates his relatively small but dynamic business out of his home office in Brisbane, Australia. Gabe specialises in organising accreditation climbing tours all over the world – perfect holidays for thrill-seekers who want to advance their climbing skills under expert supervision. Climber’s Paradise Inc offers 1-week and 2-week tours to four main destinations: Mongolia (Mount Khuiten), Tanzania (Kilimanjaro), Peru (The Andes), and Nepal (Mount Everest). During these tours, Climber’s Paradise Inc’s clients perfect their skills through reading relevant climbing guides (authored by Gabe Walker) while acclimatising at their chosen destination, and then climb their chosen mountain under the watchful eye of Gabe’s hand-picked expert climbing instructors. Gabe has some Information Systems knowledge and has developed a basic database to record transactions that occur in his business. He was planning on developing a decision support workbook in Excel but realised he didn’t have the necessary skills to complete the task. He has asked you to take the database he created, and the workbook he started, and complete the task. Primarily, Gabe wants to use the workbook to see, amongst other things, sales of his climbing guides, as well as sales of travel guides, maps, and, of course, the number of climbing holidays organised. Gabe would also like to use the spreadsheet to view details of employees and clients for future marketing purposes. Note that the entire workbook is intended to apply to January 2012 data, which means that the file would be saved and backed-up at the end of the month, before the data is cleared for entering the next month’s data. This means that your formulae need only work for the month already referenced in the workbook (i.e. January 2012).
Project ID: 2567813

About the project

21 proposals
Remote project
Active 11 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
21 freelancers are bidding on average $123 AUD for this job
User Avatar
Hi sir, please check PM, thx Kimi.
$200 AUD in 5 days
5.0 (29 reviews)
5.5
5.5
User Avatar
======== Excel Expert here! Please check PM. ==========
$200 AUD in 4 days
4.5 (37 reviews)
4.9
4.9
User Avatar
Hi, I can do that project, I am ready to start...
$100 AUD in 3 days
4.8 (16 reviews)
4.8
4.8
User Avatar
Hi I am an Engineer and well versed with MS Access and Excel. I can handle this job for you. Thanks
$175 AUD in 3 days
4.5 (10 reviews)
4.2
4.2
User Avatar
Very confident team here. Please award us the project !
$95 AUD in 4 days
4.9 (16 reviews)
3.6
3.6
User Avatar
hi, we are Sydney based access/excel expert and very interested abt ur project. pls see our profile, our 100% completion rate proves our reliability. pls make us win the bid. -AA
$99 AUD in 5 days
4.8 (5 reviews)
3.1
3.1
User Avatar
############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############
$100 AUD in 3 days
2.6 (2 reviews)
3.2
3.2
User Avatar
Greetings Client, I have gone through the project details and will be very happy to help you with this.I have over 7 years of experience with Excel and VBA and Access and will provide you a robust and very user-friendly project. I will complete this project on time with 100% accuracy. Regards Mukul
$100 AUD in 3 days
5.0 (2 reviews)
2.2
2.2
User Avatar
Hello I have worked on excel for number of years and i can easily do your job. waiting for your feedback :)
$40 AUD in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
hola, podremos ejecutar su trabajo en excell tan pronto obtengamos el proyecto
$150 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a excel and access expert here.I can create Excel workbook and access database .check my pm
$94 AUD in 6 days
0.0 (0 reviews)
1.2
1.2
User Avatar
Excel Expert,fast and committed, looking to exceed your expectations
$175 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in MS Excel and Access, and I have the time to work on your project. I completely understand this project and I will send it to you on time and with 100% quality.
$50 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI Mr I am ready
$30 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm new here at freelancer.ca but I've been developing several applications using MS Excel/Access with VBA for the past 10 years. I'll make sure project is done as you wanted and able to support you even after the project. Thank you and looking forward to hear you soon.
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can complete this project according to specification. Let me know if you are interested.
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please let me know when we need to start the work for you . I am also on Skype add me as sankalpsaxena7
$100 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Our team consists of some highly skilled Excel users who have had to create a variety of solutions within some very established global companies. This project is well within our capabilities and look forward to the outcome of this bidding process.
$220 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Depends on the Job, just give me the details ow raw data and the jobs.
$31 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have total 11 yrs of IT experience of which 8+yrs in Business Intelligence, developed over a period of hands on experience on different projects, which were on Complex Excel dashboards for an MNC Bank.
$180 AUD in 45 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
899
Payment method verified
Member since May 3, 2012

Client Verification

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.