Find Jobs
Hire Freelancers

Create access database with reports and queries

$10-60 CAD

Terminado
Publicado hace casi 10 años

$10-60 CAD

Pagado a la entrega
Sylvester’s Bike Shop has stored its data in Excel for many years but has experienced some data quality issues. As you can see from the Excel file for this assignment, Sylvester’s Excel spreadsheet stores the company’s products and suppliers. Some of the data quality issues Sylvester’s has experienced are errors in supplier names and addresses that have resulted from these being repeated several times in the data. Changes to supplier addresses are not always made consistently. As well, Sylvester’s is planning to grow its product line dramatically over the next year and therefore feels that they should position themselves for this growth by moving to Access. One of the things they would like to be able to do is move to “Category Management,” in which one category manager is assigned to each product category and is responsible for managing that category to achieve specific performance goals. Initially, all they are interested in adding to the database is a way to add the salesperson name for each product category. The first step in your assignment is to design and build an Access database to house Sylvester’s current data. Use the information on database design in Chapter 6 of the textbook (“Designing Databases,” p. 186) as well as Chapter 2 in the Access e-text. As is always required in these kinds of projects, you will need to correct any data problems you find. Wherever there is inconsistent data, you should change the incorrect value to the one that is on the rest of the records for that supplier. Since you have not been given the Category Manager names, you can make these up for your database. The customer will have to update these once you give them the final database structure, so make sure that your database design makes this easy for them to do. Keep in mind as well that you do not want to retype all of this data. First, doing so will not be the best use of your time (and will be quite boring); second, it introduces the problem of data errors. You need to make sure that the data in the Access databases matches the Excel data (except for the obvious data inconsistencies). You can import the data directly from an Excel spreadsheet (Assignment 2 Source Data). The steps to do so are explained on pages 134-138 in the Access e-text (see the Learning Materials page if you haven't yet accessed the e-text) . The next step is to create queries and reports for each of the three reports requested on page 199 of the textbook. As well, you should create a query and a report that lists each product category with their salesperson and the products which they manage. This report should be sorted alphabetically by product category. Products in each category should be sorted by descending price. You do NOT need to answer the last question on page 199. Important notes about this assignment: The e-text authors advocate using Calculated Data Fields in Access 2010. While these do solve many of the problems that used to exist with calculated fields (because Access does the calculation automatically for you), for this assignment, do NOT use the Calculated Data Field functionality. You will find one database design for this assignment on the textbook companion website. Keep in mind that this is NOT necessarily the best solution, the data is not the same, and your assignment has an additional element not found in the textbook version. Therefore, while you might consider some elements of what they have done, you should create your OWN database design.
ID del proyecto: 6104940

Información sobre el proyecto

23 propuestas
Proyecto remoto
Activo hace 10 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
Adjudicado a:
Avatar del usuario
Hi, I have gone through details of your project which involves an assignment work of developing MS Access database on basis of Excel details. I feel comfortable in taking up the task as I have worked on several MS Access projects of various complexities and can deliver you required solution. However, in the text written in description there are several references mentioned which you will need to share to get complete requirement. Waiting for your response to talk further in detail and start the work. Thanks.
$50 CAD en 2 días
4,9 (29 comentarios)
4,9
4,9
23 freelancers están ofertando un promedio de $82 CAD por este trabajo
Avatar del usuario
I am a professional full time academic research writer fully proficient in HARVARD, APA, MLA, Chicago and Oxford writing styles. I am competent in writing dissertations, thesis, reports, case studies, personal development plans, personal statements, marketing plans, comparative studies (companies/countries), review of literature and systemic literature review. I am able to carry out research utilizing mixed method, qualitative or quantitative research. My services range from undergraduate to Ph.D. academic level and I have written papers on management (organizational/business management including but not limited to Organizational/Business strategy, Strategic analysis etc.), HRM (Strategic HRM, IHRM etc.), Operations management, Marketing (plans, positioning etc.), Chemistry, Nursing, Psychology, Political Science, History, Geography, World Affairs and Religion. My work is tailor-made to suit my client's needs and is written from an analytical and critical perspective utilizing up to date peer-reviewed sources of academic literature and books.
$120 CAD en 3 días
4,8 (226 comentarios)
7,0
7,0
Avatar del usuario
Quality writer at your service,please consider my bid for high quality work on time. Hi, Are you little worried and finding freelancer for your task, i am here to deliver beyond your expectations. Award me project without wasting your precious time and allow me to start right away, i am fully capable to complete your task within deadline. I assure you 100% quality work on time. I am a vigilant, hard-working, reliable and smart working writer who delivers project according to clients requirement. i am confident you will get best from me. hope you will consider me,thanks
$120 CAD en 4 días
4,8 (185 comentarios)
6,9
6,9
Avatar del usuario
A proposal has not yet been provided
$120 CAD en 3 días
4,9 (123 comentarios)
6,7
6,7
Avatar del usuario
Hi mate, My aim is to establish myself as one of the most reliable providers and I believe that the only way to achieve this is by Buyer Satisfaction.I assure you the quality of the work will be beyond your expectations. Thanks
$120 CAD en 3 días
4,7 (87 comentarios)
6,3
6,3
Avatar del usuario
I am a competent academic writer, with high lead times and turnaround time, proposal writer, masters level dissertation writer, PHD level dissertation and thesis writer, PHD defense PowerPoint presentation writer, argumentative essays, comparative analysis, company analysis, business strategy development, conversant with all international citations, marketing, management, business studies, advertising, procurement, strategy development, marketing plans, marketing strategy, communication strategies, stakeholder man. I have good reviews and record of writing excellent quality and a PhD level Essay, Thesis, dissertation. I can assure you about ZERO Plagiarism work. Give me a chance to join your team and i will prove myself. I believe in Quality … Let’s Discuss.
$105 CAD en 1 día
4,5 (66 comentarios)
5,6
5,6
Avatar del usuario
I am an accomplished graduate and master’s level academic writer who has delivered on over 2000 academic papers and dissertations. I am familiar with Harvard, APA,MLA,Chicago and Oxford Reference Style I have been writing all sorts of scholastic and professional documents for many years. Some scholastic documents that I have written are *Reports *Essays *Research papers *Dissertations *Theses I am also adept at writing professional documents like *Business plans *Business proposals *Business cases *Resumes *Cover letters If you award me this project, I can guarantee the turnaround I have listed or possibly faster, and the document will be error and plagiarism free. I hope to have the opportunity to work with you. I have extensive experience in financial analysis, marketing and data analysis. I assure that I will deliver first class tasks that will satisfy you at all times. Look forward to working with you.
$150 CAD en 5 días
4,9 (49 comentarios)
5,5
5,5
Avatar del usuario
I'm 100% sure I can serve my best capabilities to complete your target and work opportunities...... So, I can just say that; "I am honest for achieving your work requirements and everything wants’ trust !!! Make trust in me!!!! I take you to the gate of success!!
$105 CAD en 3 días
4,8 (21 comentarios)
4,8
4,8
Avatar del usuario
Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access and VBA to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,
$105 CAD en 5 días
5,0 (8 comentarios)
4,8
4,8
Avatar del usuario
Dear Sir, I'm expert at access, and ready for help, and interested in helping you. Kind Regards, NourElDeen
$49 CAD en 3 días
5,0 (40 comentarios)
4,7
4,7
Avatar del usuario
Happy to help you out. I am experienced in MS Access development. Communicate to discuss the project Thanks Dobre
$60 CAD en 1 día
4,9 (29 comentarios)
4,6
4,6
Avatar del usuario
Hi, I am placing my bid on your project because I am confident enough with my database and design skills. I am focused mostly on doing computer science homework here in freelancer.com and I would like to help you get this project done if you would give me the opportunity. I am a computer science professor and practitioner and this assignment is one of the fields that I teach very well so I can assure you an accurate result. Let me know if you are interested so I can have further details. Thanks.
$40 CAD en 1 día
5,0 (26 comentarios)
4,3
4,3
Avatar del usuario
I am ready to work on your data base design , message me Thank you
$40 CAD en 1 día
5,0 (19 comentarios)
4,3
4,3
Avatar del usuario
Hi - I have a degree in IT from the University of Manchester and I could quickly finish this assignment. Let me know if you are interested in working with me.
$60 CAD en 5 días
5,0 (7 comentarios)
4,2
4,2
Avatar del usuario
Aucune proposition n'a encore été fournie.
$100 CAD en 3 días
4,8 (6 comentarios)
3,9
3,9
Avatar del usuario
Greetings, I am BS-CS graduate having majors in DATABASE. I can do this task with perfection as I have experience with forms, queries and reports in MS-ACCESS. Hoping to hear soon from you with more details.
$90 CAD en 3 días
5,0 (12 comentarios)
3,4
3,4
Avatar del usuario
Hello Sir, I believe I am the best candidate for this project and that you will be amazed by the high quality paper, properly referenced and grammatically correct paper I will deliver to you. If you want I will send you some sample paper I have delivered to my client who received a distinction in the subject. Award me the project, sit back, relax and wait to be delivered high quality writing. Regards
$80 CAD en 3 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
experienced software professional with 20 years in design, development and maintenance of applications
$60 CAD en 5 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
Dear Sir/Madam I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have more ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects. Thank you in anticipation.
$40 CAD en 1 día
5,0 (2 comentarios)
1,7
1,7
Avatar del usuario
Hi, I have +10 years experience with MS Access, so I am person for your task. Please see my portfolio. Best regards, Kosta
$50 CAD en 3 días
4,2 (1 comentario)
0,8
0,8
Avatar del usuario
hello i can do this, check my feedbacks i have experience with this. let me know if you are interested. Jose Luis Mendoza. Software Ing.
$60 CAD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Gatineau, Canada
5,0
1
Forma de pago verificada
Miembro desde feb 17, 2014

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.