Access Work

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

Hello! I need this to be done by this Wednesday 05/02. I will attach the data sheet to begin work.

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.

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 what I need for you to do is the following:

1. In Access create the table(s), field(s), data type(s), primary key(s), etc. for the database and populate it with the data provided in the Excel file.

2. Create the relationship(s) between/among the tables, as appropriate.

4. Create a query that will select records for customers who had their first pickup in May 2011. Sort into alphabetical order by Business Name. Save the query as May 2011 – First Picking Query.

5. Create a query that will select customers who had less than 15 pounds of produce picked for Grapes, Watermelons, Strawberries or Grapefruit. The query should include the Service Date, Customer Number, Business Name, and the Weight fields from those attributes. Sort into ascending order by Customer Number. Save the query as Low Volume Query.

6. Create a query to determine the total weights for each type of produce picked by each customer. Sort by Business Name. Save the query as Customer Total Weight Query.

7. Create a query to calculate the payment for each picking for apples and watermelon. Include the Business Name, Picking Date (ascending), the weight and product payment for both types of produce. Save the query as Produce Value Query.

8. Create a query and a report to calculate the total payment for grapes and strawberries (two columns) for each customer. Include the Business Name (ascending) and the payments. In the report, break it out by state. Save the query as Grapes-Strawberries Query.

Thank you so much!!!!!

Entrada de datos Procesamiento de datos Microsoft Access

Nº del proyecto: #16828391

Sobre el proyecto

8 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

Orientwork

Hello sir! How are you?? Respected sir, i can do your task e.g “Access Work" as per your requirements, please talk to me for about work, regards

$30 USD en 3 días
(53 comentarios)
4.7

8 freelancers están ofertando un promedio de $25 por este trabajo

EngrShahidul

I am experience SPSS, Minitab. Excel. Access, Presentation, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. Más

$25 USD en 1 día
(13 comentarios)
4.4
mavzbing

Dear Sir/Maam, I read the project description and understand the work you want me to do. I want to know more in details about the project. Some of my important points are given below: -I am available 30+ hours/week -w Más

$25 USD en 2 días
(2 comentarios)
1.0
MMcdermott

As a software developer, I use sql and create relational databases basically daily. Hit me up in chat and lets discuss

$25 USD en 1 día
(0 comentarios)
0.0
CaguimbagaJames

I'm working in the government for almost 10 years already. I am always assigned in rendering computer related jobs over the years which helps the company's work efficiently and effectively. My expertise includes al Más

$25 USD en 1 día
(0 comentarios)
0.0