Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Homework
This answer was rated:

Knowledgeable with Microsoft Access

Josie, did you just respond...

Josie, did you just respond?  I tried accessing your response here but no luck.


 


 


Hi, I need someone who is knowledgeable with Microsoft Access to do what my teacher didn't, which is write down an explanation/solutions for how to do a fairly simple assignment. I can copy and paste it here. I'm using Office 2013.


 


 

Show More
Show Less
Ask Your Own Homework Question
Answered in 4 hours by:
7/7/2013
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
Experience: M.S. in Internet Information Systems
Verified
Hello and thank you for your question. It would be my pleasure to assist you with this.

Please zip up any files you have any upload them to http://ge.tt

Once uploaded, you will be given a link on the right. Click on the 'Copy Link' option and then paste it here.

Thank you
Ask Your Own Homework Question
Customer reply replied 4 years ago

Hi Doc,


 


I just uploaded it. Can you let me know if you receive ok? What I'm looking for is a step-by-step. We did the assignment in class, but I learn better by reading than by watching the steps.


 


Thanks,


 


Jaon

Hello again, Jason.

As mentioned in my previous reply, you must paste the download link into this thread. The site I gave you is a third-party sharing site. Without the download link, there is no possible way that I can access your files.

When you upload, there will be a small link on the right. Click on the 'Copy Link' option and then paste that link here so that I can retrieve the files.

Thank you
Ask Your Own Homework Question
Customer reply replied 4 years ago

Does this work?


 


http://ge.tt/3lwE1Cl/v/0


 


 

Yes, that works.

Please also send me the Northwind database. The assignment says "Using Northwind database"

I need that database in order to provide you with instructions.

Thank you
Ask Your Own Homework Question
Customer reply replied 4 years ago

Ok, thanks again. Here's the new link:


 


http://ge.tt/3lwE1Cl

Thank you.

I will contact you once this is ready.
Ask Your Own Homework Question
Customer reply replied 4 years ago

Ok, thanks.

Hello again Jason!

You can download step-by-step instructions for each question here:

Attachment: 2013-07-08_015654_databaseinstructions.docx



Let me know if you have any questions. I'm here to help.

If you require assistance in the future, please feel free to request me directly by starting your question with **For TheDoctor**

Please remember to rate my answer. Thank you so much and have a wonderful day!
Ask Your Own Homework Question
Customer reply replied 4 years ago

Hi again Doctor,


 


Thanks for doing this so quickly. We've got a test in a few weeks & Access will be a part of it.


 


If it's ok with you, I'll likely have some questions on some of these. Is it ok to email these? One in particular was regarding the items under $5. The list that the query generated had several duplicates. I tried everywhere to find out how to hide the duplicates but couldn't find a clear answer.


 


Thanks again,


 


Jason


 

Hello again,

If you followed the instructions that I sent correctly, there are absolutely no duplicates. I ran each query myself. If you are getting duplicates, then you didn't do something correctly. You can zip up your modified database file and send it to me. Tell me what the query is called and I will take a look at it.

Please remember to rate my answer. You may ask follow up questions before or after leaving a positive rating.


Thank you

Ask Your Own Homework Question
Customer reply replied 4 years ago

Ok, thanks again. Give me a day and I'll rate and pay the balance.


 


Jason

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
Experience: M.S. in Internet Information Systems
Verified
TheDoctor and 87 other Homework Specialists are ready to help you
Ask your own question now
Customer reply replied 4 years ago

Hi Doctor,

I've been so busy that I haven't even had time to review. I've got 2 full-time jobs and my time is not my own! I will look it over today though. Will you be around for a question or two?

Thanks,

Jason

Hello again Jason,

If the questions are directly related to this specific Microsoft Access assignment, yes; I will be available.
Ask Your Own Homework Question
Customer reply replied 4 years ago

 


Hi Doctor,


 


Thanks again for your help. I'd benefit with screenshots of some of the steps you've outlined.


 


Here's mine for #4. I'm following your directions as written but getting error messages. Here's a link to the screenshot:


 


http://ge.tt/30IIckl/v/0


 


Also, can this email be set up instead to accept attachments? My files aren't large and the extra step of the cloud is creating more work.


 


Thanks again,


 


Jason

Your screenshot is does not remotely follow the directions.

4) Find top 3 employees that generated most sales.

Steps:
1.) Select "Create" in the menu
2.) Select "Query Design" from the ribbon
3.) Double click on Employees and Orders
4.) Click on "Close" to close the list of tables
5.) In the employees table in the query designer, double click on EmployeeID, LastName, FirstName
6.) In the ribbon, under design, select "Totals" – it is the big Sigma sign
7.) In the first available "Field" in the bottom boxes, type in Sales : OrderID and press enter.
8.) Under Total for that field, select "Count". The first three fields should automatically be set to Group By
9.) For this new field, select Sort – Descending
10.) In the ribbon, under design, change Returns from All to 5
11.) Save the query
12.) Run the query


In the first available FIELD. As in the cell labeled "Field". Not in the "Or" field. You placed it in the "Or" field, which would definitely cause errors. Then, every step after that is not followed correctly.

There should be four fields. You didn't use the next available fields. You only have three fields and you placed what I told you to place in the next available field into the or value of the first field.

Your query should look almost exactly like the screenshot that I already sent for #5, since #4 and #5 are almost identical.

You stated that this assignment was already completed. If you follow the instructions correctly, they all work perfectly.
Ask Your Own Homework Question
Customer reply replied 4 years ago

Hey -- you know what? I've had about all I can take of your sniveling condescension for one lifetime.


 


I followed your directions and tried entering Sales : OrderID in the 4th field from the left. It gave me an error message, so I tried entering it in table #1.


 


 

Hello again, Jason. I apologize if you read any kind of condescension. I assure that there was none intended.

As I stated before, if you send me your Microsoft Access file and tell me what you named the query, I can take a look at it and make any corrections. I can then send it back to you and let you know exactly what was done.

The instructions are correct, and I ran each one myself. If you would like me to send you a completed file, I can do that as well. Since you stated that the assignment was already completed, I had assumed that you already had the completed queries and did not need them. If you do need them, just let me know and I will send them.

Also, I could take a screen cast of any single question, showing how to do each step, and showing that each one works.

Finally, if you take a look at the screen shot that I sent you for #5, you can see exactly what #4 should look like.

Again, if you would like the database file with all of the queries completed let me know. Or if you would like to send me your file, please do.
Ask Your Own Homework Question
Customer reply replied 4 years ago

No thanks -- I would like someone else to assist.

Hello again Jason,

I am sorry that you feel that way.

You can download the database file here:

http://wikisend.com/download/175792/northwind(1).mdb

In the file there is a query called QUERY4-DONE.

You will see the query in question, exactly as the instructions state. Simply press the run button in the ribbon and you will see that it runs without an error.

You asked for instructions on 10 queries and received accurate, step-by-step, instructions for each. If you need each of the 10 queries completed for you, simply state so.

I apologize that you are frustrated and read a tone into my text that was absolutely not there. I am more than willing to help you and have, from the beginning, offered many different options for you to send me what you have done so that I can provide feedback.

I have offered the completed file. I have offered to review your file. I have offered to take a screen cast of each step being completed. I thank you for sending a screen shot, but there is not much I can do with that. You stated that you tried to follow the instructions before and then moved the Sales : OrderID after it didn't work. But I never had an opportunity to see that "not work" or what you could have done wrong. That is why I have suggested multiple times that you save your files with the issue in it and send it to me so that I can provide you with feedback.

 

Why I have offered a couple different times to send you the file with all of the queries completed is so that you could see the steps completed. This has the same affect as a screen shot, but you would also be able to play around with the queries, view the SQL, change conditions and see what happens, etc. You could still complete everything in your file, but have a file to go to and see if you got it right or what you need to do when you get stumped.

 


In any case. I again apologize that you appear to be frustrated. If you would like the completed file, just let me know. I would be happy to send that to you.

 

Thank you so much and have a wonderful day.

Ask Your Own Homework Question
Customer reply replied 4 years ago
Relist: Answer quality.
The best way to do this is probably using either screenshots or a simple webinar that shows the steps. JustAnswer should set it up so that the Expert can record their own problem-solving steps. This back and forth and discourteous treatment negates the whole purpose of this website and its purported services.

Hello again Jason,

I wanted to send you these couple files:

http://wikisend.com/download/314926/northwind.zip

In that zip is the instruction file with screen shots for every question. And in the accdb file, you will find every query completed. They are named Query3-Done, Query4-Done, Query5-Done, etc.

You can, of course, work with a different professional. I just wanted to make sure that you had these files.

Thank you so much for your question and have a wonderful day!

Ask Your Own Homework Question
Josie-Mod
Category: Homework
Satisfied Customers: 5
Verified
Hi, I’m Josie a moderator for this topic. It seems the professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.

I was checking to see if you had already found your answer or if you still needing assistance from an other one of our professionals?

Please let me know if you wish to continue waiting or if you would like for us to close your question.

Also remember that JustAnswer has a multitude of categories to help you with all your needs from Pet to Legal.

Thank you,

Josie~Moderator
Ask Your Own Homework Question
Customer reply replied 4 years ago

Hi Josie,


 


No unfortunately, I still would like the assistance that wasn't provided. I paid the $60 and am not asking for a refund, but I would appreciate the help from someone else who provide what I asked for on 7/14. Can someone please do this? I work full-time and have been looking forward to this assistance, especially after calling in an sending a seaparate email as requested.

Hello Jason,

Thank you, XXXXX XXXXX continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait.

Best,
Josie~Moderator
Ask Your Own Homework Question
Angela--Mod
Category: Homework
Satisfied Customers: 8
Verified
We appreciate your patience, your business is very important to us, we are waiting on the professional with the right expertise to come online. Please let us know if you would like us to continue searching for a professional or if you would like us to close your question. Thank you for your understanding!

Best,

Angela


Ask Your Own Homework Question
Ask TheDoctor Your Own Question
TheDoctor
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
1,757 Satisfied Customers
Experience: M.S. in Internet Information Systems

TheDoctor is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

5,672 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,549 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,635 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,158 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
I cannot get started with this assignment in my DBM 381
I cannot get started with this assignment in my DBM 381 class … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
BusinessTutor: HELP ME. I need you to do the problem solved.
BusinessTutor: HELP ME. I need you to do the problem solved. Look below: http://www.mediafire.com/?ojdihu5x6eyofne http://www.mediafire.com/?aeb9wdeb2o374yl (problems questions & answers) Its due asap… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
Foundation classes for MBA
4,549 satisfied customers
Smallest unit of matter that has all the properties of an element
Please help I only have one hour: 1. Which of the following is the smallest unit of matter that has all the properties of an element? (Points: 4) molecule element atom compound electron 2. Isotopes of… read more
Bizhelp
Bizhelp
CPA
Bachelor's Degree
1,887 satisfied customers
Random variable is normally distributed with a mean
Random variable is normally distributed with a mean of μ = 50 and a standard deviation of σ = 5. What is the probability the random variable will assume a value between 45 and 55 (to 4 decimals)? What… read more
R.R. Jha
R.R. Jha
Bachelor\u0027s Degree
150 satisfied customers
HEALTH, SAFETY, AND NUTRITION FOR THE CHILD 605844RR -
HEALTH, SAFETY, AND NUTRITION FOR THE YOUNG CHILD 605844RR - Preventing Illness and Injuries When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorde… read more
GLENN
GLENN
Master of Mathematics
330 satisfied customers
I need the following flowchart for Car Class in MS Word. The
I need the following flowchart for Car Class in MS Word … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
191 satisfied customers
FOR Discussion Question 1 • Due Date: Day 2 [post to the
FOR ANGELA Discussion Question 1 • Due Date: Day 2 [post to the Main forum] • Post your response to this question: Consider the statement “psychology has a long past but a short history.” What do you … read more
Seanna
Seanna
Tutor
1,781 satisfied customers
When I open a word document it has a character string 20 and
When I open a word document it has a character string 20 and places that character after I type each line. This is just a recent problem and. How can have work not insert that character?… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
I need help regarding javascript with custom objects and
I need help regarding javascript with custom objects and constructors. I am having trouble calling an onclick function in a form to an array.… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
Fiscal restraint is defined as: a. Tax hikes or spending
Fiscal restraint is defined as: a. Tax hikes or spending cuts intended to reduce aggregate demand. b. Tax hikes or spending cuts intended to increase aggregate demand. c. Tax cuts or spending hikes in… read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,635 satisfied customers
Explain the types purpose and function of materials and
Explain the types purpose and function of materials and equipment needed for the administration of medication via the different routes … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
191 satisfied customers
I have a couple of basic java questions i need answered.
I have a couple of basic java questions i need answered … read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
The Use case diagram for a tracking system using clusters of
The Use case diagram for a tracking system using clusters of sensors. I am now in phase 3 and I did all the documentation but I need to deeply understand the logic behind the IoT to proceed correctly … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
191 satisfied customers
This week you'll be making the following refinements to the
This week you'll be making the following refinements to the class that you wrote in the last assignment. All the requirements from that class are still in force. For example, all MyStrings must always… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
I asked a question and will pay but the site asks me to
hi i asked a question and will pay but the site asks me to verify an ammount below 200 usd which i want to but it does not give me the option to do so, please help… read more
GLENN
GLENN
Master of Mathematics
330 satisfied customers
Which if the following is not included unpaid-in capital?
which if the following is not included unpaid-in capital? common stock pain-in capital-donations stock dividend distributable appropriation per loan agreement … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
A rifle with a longer barrel can fire bullets with a larger
A rifle with a longer barrel can fire bullets with a larger velocity than a rifle with a shorter barrel. A. Explain this using the impulse momentum theorem B. Explain this using the work energy theore… read more
GLENN
GLENN
Master of Mathematics
330 satisfied customers
This question is just for Dr. Kakonge. This purpose is to
Hello. This question is just for Dr. Donna Kakonge.This purpose is to pay the payment to Dr. Donna Kakonge on 06/16/2017 again because of something wrong about payment on 06/16/2017.The question on 06… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
191 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x