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 (because of recent Executive Action to reduce the number of undocumented foreign workers). 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: HW 6 _ Unlimited Packers_data.) Specifically they need for you to do the following: 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 pt)Create the relationship(s) between/among the tables, as appropriate. (1 pt)Label the database with your last name and HW#6Create 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 July 2011 – First Picking Query. (1 pt)Create a query that will select customers who had less than 50 pounds of produce picked for Grapes, Apples, Strawberries or Watermelon.The query should include the Service Date, Customer Number, Business Name, and the Weight fields from those attributes. Sort into descending order by Business Name.Save the query as Low Volume Query. (1 pt)Create a query to determine the total weights (summation) for each type of produce (five products-grapes, apples, grapefruit, watermelon, strawberries) picked by each customer.Sort by Business Name.Save the query as Customer Total Weight Query. (1 pt)Create a query to calculate the payment for each picking for grapefruit and strawberries.Include the Business Name, Picking Date (descending), the weight and product payment for both types of produce.Value should be in currency.Save the query as Produce Value Query. (1 pt)Create a query and a report to calculate the total payment (e.g. total by company) for grapes and watermelon (two columns) for each customer.Include the Business Name (ascending) and the payments (in currency format).In the report, break it out by state. Save the query as Grapes-Watermelon Query.The report should subsequently also be named.In the report, execution a summation by state (2 pts) .Homework #6/Access HW #2– Unlimited Pickers – 9 Points
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 (because of recent
Executive Action to reduce the number of undocumented foreign workers).
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 paperbased business records and placed into a spreadsheet for you to use in designing and building the
database. (The spreadsheet file is: HW 6 _ Unlimited Packers_data.)
Specifically they need for you to do the following:
1. 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 pt)
2. Create the relationship(s) between/among the tables, as appropriate. (1 pt)
3. Label the database with your last name and HW#6
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 July 2011 – First Picking
Query. (1 pt)
5. Create a query that will select customers who had less than 50 pounds of produce picked for
Grapes, Apples, Strawberries or Watermelon. The query should include the Service Date,
Customer Number, Business Name, and the Weight fields from those attributes. Sort into
descending order by Business Name. Save the query as Low Volume Query. (1 pt)
6. Create a query to determine the total weights (summation) for each type of produce (five
products-grapes, apples, grapefruit, watermelon, strawberries) picked by each customer. Sort
by Business Name. Save the query as Customer Total Weight Query. (1 pt)
7. Create a query to calculate the payment for each picking for grapefruit and strawberries.
Include the Business Name, Picking Date (descending), the weight and product payment for
both types of produce. Value should be in currency. Save the query as Produce Value Query.
(1 pt)
8. Create a query and a report to calculate the total payment (e.g. total by company) for grapes
and watermelon (two columns) for each customer. Include the Business Name (ascending) and
the payments (in currency format). In the report, break it out by state. Save the query as
Grapes-Watermelon Query. The report should subsequently also be named. In the report,
execution a summation by state (2 pts)
.
Purchase answer to see full
attachment
We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
