Access Work -- 2

Ukončen

I need someone able to perform the tasks below PERFECTLY. If you're chosen, I will send you the data sheet to begin work.

I need this job done by Wednesday evening.

I'm willing to pay $25 for this job.

Project description:

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to location picking or harvesting different crops, such as strawberries, grapes, watermelons, cantaloupe, oranges, grapefruit, and apples, among others. Unlimited Pickers has been in business for a few years, but has seen demand skyrocket in recent months (cf. recent legislation in Alabama to reduce the number of undocumented foreign workers). (All workers for Unlimited Pickers are either U.S. citizens or are legally authorized to work in the U.S.; Unlimited Pickers tries to help their workers complete the legal work-permit process.)

Customers, i.e., the farms who want to hire Unlimited Pickers teams, pay a small fee to the organization to reserve one or more teams of pickers. The workers are paid based on the quantity of the produce that they harvest, typically by the pound. (Note that some customers are large organizations, while others are quite small in the amount of produce grown.)

Unlimited Pickers would like for you to assist with the creation of a database program to help better manage their data and will include several queries. Some test data has been pulled from their paper-based business records and placed into a spreadsheet for you to use in designing and building the database. (The spreadsheet file is - Unlimited Pickers.)

Specifically they need for you to do the following:

1. Create the database, including loading the data from the spreadsheet into Access and establishing the Relationships. Label the database with your last name and HW#6 (1 pt)

2. Create a query that will select records for customers who had their first pickup in July 2011. Sort into alphabetical order by Business Name. Save the query as July 2011 – First Picking Query. (1 pt)

3. Create a query that will select customers who had less than 10 pounds of produce picked for Grapes, Watermelons, or Strawberries. The query should include the Service Date, Customer Number, Business Name, Street, City, State, Zip, and the Weight fields from those attributes. Sort into ascending order by Customer Number. Save the query as Low Volume Query. (1 pt)

4. Create a query to determine the total weights of all produce picked for each customer (by type and total). This should include all produce for a customer. Sort by Business Name. Save the query as Customer Total Weight Query. (1 pt)

5. Create a query to calculate the payment for each picking for grapes and strawberries. Include the Business Name, Picking Date (ascending), and the Weight and value for both types of produce. Save the query as Produce Value Query. (1 pt)

6. Create a query and a report to calculate the total payment for apples and watermelon for each customer. Include the Business Name (ascending) and the payments. In the report, break it out by state. (2 pts)

.

Dovednosti: Zadávání dat, Zpracování dat, Microsoft Access

Zobrazit více: bid work access excel, access visual basic code work access, ability work pressure meet deadlines follow queries, work access databases, create website forms work access, java perl work storage networking test, excel work access database, work access template, php work access, work access database, php work access database, complete project work access, word document work access integrer, access quiz test questions, work access database php

IČ projektu: #12207267

15 freelancerů učinili na tento projekt nabídku v průměrné výši $25

mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Více

$30 USD za 1 den
(166 recenzí)
6.6
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Více

$25 USD za 1 den
(90 recenzí)
6.2
royalcalif

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. https://drive.google.co Více

$25 USD za 1 den
(23 recenzí)
4.3
VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Více

$25 USD za 0 dní
(16 recenzí)
3.8
sharpzulfiqar

Dear Client, I am an experienced programmer and web/application developer. I have served the clients throughout the globe and believe in long term relationships, so I work upto client satisfaction and tries to earn Více

$30 USD za 1 den
(2 recenzí)
3.7
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Více

$25 USD za 1 den
(17 recenzí)
3.8
funkeojo

A proposal has not yet been provided

$25 USD za 1 den
(6 recenzí)
2.6
pateldhrumil

Hello I am Dhrumil, a motivated and expert freelancer. I am ready to get this job done for you quickly and within your budget. I have 3 years of experience with data analysis, data entry, spreadsheet work and Více

$22 USD za 1 den
(4 recenzí)
2.0
ahmedtaher2020

A proposal has not yet been provided

$18 USD za 3 dní
(0 recenzí)
0.0
brianoneill1

I have 12 years of experience in the finance sector and have created many excel and access systems to deal with streamlining operations. I will be able to create an easy to use system for you.

$25 USD za 1 den
(0 recenzí)
0.0
Seyico2011

if you could send the details of the work , I will delivery the work before Wednesday. Thank You

$20 USD za 2 dní
(0 recenzí)
0.0
vikashshukla7

hi this is vikash shukla i am working as a webdeveloper and data entry operator i will complete your work with in time duration my bid is negociatable Looking forward to your response

$25 USD za 1 den
(0 recenzí)
0.0
sergioobici

.......................................................................................................................................................................

$25 USD za 3 dní
(0 recenzí)
0.6
$25 USD za 1 den
(0 recenzí)
0.0
Shripx

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Best Regard Employer!97

$25 USD za 1 den
(0 recenzí)
0.0
anithasrikanth2

Hi I am good in access db and can do this work

$18 USD za 2 dní
(0 recenzí)
0.0