Reference no: EM131300688
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: HW 6 - 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
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.
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.
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.
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.
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.
Attachment:- data.xlsx
Why micromanagement is consider trap that leaders encounter
: Which leadership style do you feel would be more beneficial in the long-term: authoritarian or democratic? Explain your answer. Discuss why micromanagement is considered a "trap" that many leaders encounter.
|
Down payment on their first house
: Jim and Ester have saved $25,000 for a down payment on their first house which costs $100,000. The FHA loans for which they qualify requires them to put $10,000 down. A FHA mortgage will be 5.5%. A conventional 30-year mortgage will be 4.5% intere..
|
What is the maximum allowable power dissipation per board
: If the maximum allowable board temperature is 77°C, what is the maximum allowable power dissipation per board?
|
Critique e business operations from given perspectives
: Critique e-business operations from the perspective of making on-line payments, the perspective of customer satisfaction in dealing with an e-business site.
|
Create a query to determine the total weights
: Create the database, including loading the data from the spreadsheet into Access and establishing the Relationships - Create a query that will select records for customers who had their first pickup in July 2011. Sort into alphabetical order by Bu..
|
Scholarly activity-research methods
: Research how qualitative research is used in your field. Write an essay that describes how qualitative research tools can be used to aid in decision making within your field. Be sure your essay addresses the following questions/topics:
|
Write a comment about the role of nurses
: Write a comment about the role of nurses.The nurse plays an important role in a patient's state of well-being by providing health education to promote a healthy lifestyle. One model that can assist the nurse to educate a person to improve their hea..
|
How actions of the executive have personally affected life
: The executive and judicial branches of the U.S. national government often seem to operate independently and with little conflict. Explain how the actions of the executive and/or judicial branches have personally affected your life.
|
Determine the window heat loss and associated weekly cost
: Determine the window heat loss and associated weekly cost with the ill-fitting insulation in place. The insulation will significantly reduce the radiation losses through the window. Losses will be due almost entirely to convection.
|