Em Andamento

excel finance sheets moved to access for database intergration

I work in a remote catering company and we use excel in a daily basis with linked sheets to produce data results for us. I have linked and played with the company sheets so it allows a single piece of data to be placed in once, not 4 times like they were doing before me. My excel skills are good but I need someone to set up Microsoft access and actually use it what it is designed for, a database of information.

We currently use excel like a database and I am sure a lot of other people do as well. However I believe setting up to trial our sheets through access with web integration, or even a nice user friendly interface to help my managers do their reporting more efficiently.

The type of data entry that my managers do on these mine sites is the following.

1. Weekly reports that have the clients occupancy, our staff occupancy, any back charges, bar takings.

2. Food figures: Stocktakes that get done every fortnight. This will give the total amount of people breakdown and consumption rate per category of food item. This allows us to study our food budgets and costs etc.

3. I need data sent back to my Sydney office in a similar format so they don't see anything different. Operationally in my role I want to give my team on the frontline a much better tool then just excel which can break very easily.

4. Optional and may be out of scope in this project. However a bar code scanning system that would scan directly into this access database when stocktakes are done. This would allow really accurate stock control. If item is not in the system, then allow it will ask for the bar code and cost of product.

I have all our sheets that I am currently using so it would be quite a simple job for someone with the knowhow of excel to access. I wish I knew how to do it however I think when this gets done it will give me such a better understanding to never use excel as a database again, and actually use what access is designed for, a DATABASE of information that you can send queries to and have the EXACT information you want come back at you instantly!!.

Looking for to getting this started.

We have over 40 remote sites in Australia so the impact if this gets done right will have a big impact.

Habilidades: Processamento de dados, Excel, Microsoft Access

Ver mais: work in sydney australia, work in remote australia, work in australia sydney, work bar sydney, work at sydney, what job sites actually work, total finance, sydney job sites, sydney job, sydney bar work, sydney australia job, remote work australia, remote excel, remote data entry work, remote data entry job, project managers sydney, project managers need australia, project managers australia, office work sydney, office work in sydney, office work in australia, office work australia, need someone to help with excel reports, need someone to do a excel project, mine work in australia

Acerca do Empregador:
( 5 comentários ) Browns Plains, Australia

ID do Projeto: #5101322

18 freelancers estão ofertando em média $217 para este trabalho

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 AUD in 4 dias
(155 Comentários)
6.5
Premshanks

[This is a ballpark quote and we would like to discuss in details before we mutually agree to take it forward] Hi I have gone through your sheets there are two sets a) Bootu Sheets b) Cosmo files Ques Mais

$350 AUD in 15 dias
(184 Comentários)
6.0
winnet21

Hi, I am very interested your project, I send you a small example that I had programmed for customer you please download example here : [url removed, login to view] you plea Mais

$888 AUD in 30 dias
(14 Comentários)
4.9
inoussakabore

I am a statistician engineer woirking as a database manager there is 4 years. I master the job you needs and i am ready to do it for you.

$210 AUD in 3 dias
(2 Comentários)
3.3
jawadaman

A proposal has not yet been provided

$155 AUD in 3 dias
(3 Comentários)
2.2
sirajulislam1986

A proposal has not yet been provided

$155 AUD in 3 dias
(0 Comentários)
0.0
sunilsharma22

I am working on MS access for the last 9 years and have expert knowledge using its objects like forms, reports, macros and automation (if required). Reports from simple to complex formats can be easily designed with da Mais

$222 AUD in 5 dias
(0 Comentários)
0.0
plpmagesh

Hi, I have read your requirement and understood as well. I completed some Excel macro and MS access projects successfully. Please assign me this task. I'm sure I will give you best in form of quality work. I Mais

$100 AUD in 10 dias
(0 Comentários)
0.0
ItConsultant935

Good Afternoon, Normally, my rates hover around 45.00 an hour depending upon the complexity. One thing to be aware of as a person entering the wonderful world of Database'ing, watch out because as one begins to Mais

$222 AUD in 3 dias
(0 Comentários)
0.0
arvindbishnoi92

A proposal has not yet been provided

$40 AUD in 5 dias
(0 Comentários)
0.0
mastermontilla

Hi,. I'm willing to give you the best to achieve your goal. I did many system and they are all operational now. If you give me the chance to be involve in this you will never regret. I just a beginner in this site but Mais

$250 AUD in 3 dias
(0 Comentários)
0.0
AVKDevelopment

Предложение еще не подано

$100 AUD in 3 dias
(0 Comentários)
0.0
Pharoa

Thanks for the opportunity to bid on your project. I have red and understand your tender post. I propose to develop a solution centered around Ms Access 2007 to replace your current excel based solution. I will brin Mais

$250 AUD in 3 dias
(0 Comentários)
2.7
IsaacFCosta

My experience regarding data manipulation, and analyzing database structures will provide you a great solution. Also and beyond the scope of your project request, I will be free to give you, after the conclusion of the Mais

$188 AUD in 3 dias
(0 Comentários)
0.0
Lambert90

Hi, Thank you for the opportunity to bid for this project. I am a Data analyst working in the UK therefore I will be ideal for completing this task. I have been working with Excel for around 7 years and in th Mais

$222 AUD in 7 dias
(0 Comentários)
0.0
Satyendra0502

I there, I am ready to do this project. It will create a big impact ,lets discuss more about the project and deliverables.

$222 AUD in 3 dias
(0 Comentários)
0.0
kashifbaig779

i am ecp;ert in M.s [url removed, login to view] you give me a chance then i can provide you quality work in time.i am sure that you will consider me.

$111 AUD in 3 dias
(0 Comentários)
0.0
sunshinelabs

How about this...Let's do one thing at a time. For the price quoted, I'll setup an MSSQL 2008 R2 database for you. Then you'll have a foundation upon which you can build all the other stuff you want. You do NOT want an Mais

$172 AUD in 3 dias
(0 Comentários)
0.0
Thejaswininayak

Hi sir, I have strong knowledge on MS Access. Working on excel and Access projects from last 2 years. I have undergone all your needs am sure that I can come up with your satisfaction . Thanks Thejaswini

$155 AUD in 3 dias
(0 Comentários)
0.0