In Progress

Access Work

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)

.

Skills: Data Entry, Data Processing, Microsoft Access

See more: types of data entry fields, test weight hire, test data creation, service database access, order entry job description, one harvest, need workers for business, hire foreign workers, first citizens, customer service data entry job description, access group, access database services, travel services unlimited, farmers customer service, job evening data entry, designing a label, data entry services for hire, query creation, legal work, label designing, label creation, in process access, i need some workers for data entry, Grapes, farmers

About the Employer:
( 2 reviews ) Fairfax, United States

Project ID: #7612997

Awarded to:

DavidJohnson9590

Greetings, I am an expert in MS Access and your project is well within my skill set. I can deliver your project within your budget and perfectly to your specifications. I build MS Access databases on a regular bas More

$25 USD in 1 day
(0 Reviews)
0.0

10 freelancers are bidding on average $36 for this job

mnurunnabi93

Hi, Got your job description, the tasks which you are looking for those can be done easily because I can follow instructions perfectly. It may create a win win situation for both of us. How? 1. If you give me the ch More

$30 USD in 2 days
(11 Reviews)
3.3
hosadek

Hello, I understand you require the import of your data into Access (with relationships) then the creation of 5 queries. I have over 3 years experience as an Access application developer. I have completed simila More

$25 USD in 1 day
(4 Reviews)
2.2
Neno585

Hello, I am employed MS Access developer. I briefly went through your 6 task and all are easy and I can do them perfectly if you are interested of course, so feel free to contact me. Thank you for the consideration in More

$30 USD in 1 day
(2 Reviews)
1.8
Mugheesali

Hello, Greetings, I will be happy to this task with minimum time, maximum accuracy and according to guideline you provide. Can I have more details about this project I am currently free and will be more than happy to More

$25 USD in 0 days
(0 Reviews)
0.0
RadhadeviKR

Hi i am a honest and hardworking women. I will complete your task with 100% accuracy and in time limit also i have great experience about you task. So if you interested please contact me. looking for hearing from More

$25 USD in 1 day
(1 Review)
0.0
purushothamnitk

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
jaynanavati

A Sun Certified Java Programmer here. I've been teaching Java,RDBMS, MS Access in PG/UG classes since last 11 years.

$25 USD in 1 day
(0 Reviews)
0.0
cscinstructor

I have read and fully understood your requirements. Please open chat to discuss further….. =================+++++++++++++++++++++++++==================

$138 USD in 2 days
(0 Reviews)
2.4
ggsuryaud

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0