Find Jobs
Hire Freelancers

Access Work -- 3

$10-30 USD

Cerrado
Publicado hace más de 7 años

$10-30 USD

Pagado a la entrega
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) .
ID del proyecto: 12207271

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
17 freelancers están ofertando un promedio de $25 USD por este trabajo
Avatar del usuario
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 Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$25 USD en 1 día
4,9 (160 comentarios)
6,9
6,9
Avatar del usuario
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 with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$25 USD en 0 día
4,9 (129 comentarios)
6,3
6,3
Avatar del usuario
Hi there, if you'd really like to have a professional Ms Access software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$30 USD en 1 día
4,6 (46 comentarios)
6,1
6,1
Avatar del usuario
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I'm a tutor for several college students take IS and Database classes across the globe. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details. I'm looking forward to hear from you. Regards,
$23 USD en 1 día
4,9 (72 comentarios)
5,8
5,8
Avatar del usuario
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 administration and maintenance with Linux/Unix and Windows Networking.
$25 USD en 1 día
4,9 (30 comentarios)
4,4
4,4
Avatar del usuario
I am available
$25 USD en 1 día
5,0 (22 comentarios)
4,0
4,0
Avatar del usuario
Hello, Thank you for consideration for this project. I have a passion for Microsoft Access, and have used it to develop simple to complex databases in my current and previous companies. I've developed databases to help track shipping exceptions as well as databased used for tracking and managing customer order fulfillment. As an additional benefit, I was born and raised in the US. This means that my primary language is English, and my response times do not require overnight or multiple day delays. Please feel free to contact me if you have any questions. I look forward to hearing from you! Sincerely, Ken Braverman
$30 USD en 1 día
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
please share the excel sheet referred. It is a very easy database to develop and only a few hours job for me.
$25 USD en 1 día
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
A proposal has not yet been provided
$18 USD en 3 días
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
Hello this is shah Alam as I am a freelancer and trainee SEO consultant and a content writer also. I had done work for customer support associate with 1-year experience
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
tell me the details of intruction then we can work
$35 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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. I should hopefully have it completed quicker than I've indicated on my quote
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi . l have great experiences dealing with MS Access l looking forward to working with you . thanks .
$10 USD en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde nov 20, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.