Access/Excel Assignment Specification

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).

Skills: Excel, Microsoft Access

See more: assignment, access excel assignment, excel functions, work offers in australia, work in brisbane australia, work in brisbane, work from home business australia, work from home brisbane, work for microsoft from home, work brisbane australia, work brisbane, work at home job offers, work at home entering data, work at home australia, who can expert in excel, well referenced, travel job australia, the month of january, seekers australia, sales job in australia, sales job brisbane, sales job australia, sales brisbane, requirements for marketing to occur, requirements and specification

About the Employer:
( 899 reviews ) Sydney, Australia

Project ID: #2567813

21 freelancers are bidding on average $123 for this job


Hi sir, please check PM, thx Kimi.

$200 AUD in 5 days
(29 Reviews)

======== Excel Expert here! Please check PM. ==========

$200 AUD in 4 days
(37 Reviews)

Hi, I can do that project, I am ready to start...

$100 AUD in 3 days
(16 Reviews)

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
(10 Reviews)

Very confident team here. Please award us the project !

$95 AUD in 4 days
(16 Reviews)

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. Please check private message for more [url removed, login to view] Jessie IDOCZ.

$200 AUD in 3 days
(25 Reviews)

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
(5 Reviews)

############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############

$100 AUD in 3 days
(2 Reviews)

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-friend More

$100 AUD in 3 days
(2 Reviews)

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
(1 Review)

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 Reviews)

Depends on the Job, just give me the details ow raw data and the jobs.

$31 AUD in 1 day
(0 Reviews)

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 out More

$220 AUD in 3 days
(0 Reviews)

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 Reviews)

hola, podremos ejecutar su trabajo en excell tan pronto obtengamos el proyecto

$150 AUD in 5 days
(0 Reviews)

I can complete this project according to specification. Let me know if you are interested.

$100 AUD in 3 days
(0 Reviews)

Hi, I'm new here at 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 More

$100 AUD in 3 days
(0 Reviews)

HI Mr I am ready

$30 AUD in 2 days
(0 Reviews)

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 Reviews)

Excel Expert,fast and committed, looking to exceed your expectations

$175 AUD in 3 days
(0 Reviews)