How JustAnswer Works:

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

Ask Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 2567
Experience:  Trained in Microsoft Office from 2000 through to latest version 2010.
65126503
Type Your Microsoft Office Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

can somebody help me with my access project... http://ww

Resolved Question:

can somebody help me with my access project...
http://www.mediafire.com/view/?d728o49w2nx75c5
http://www.mediafire.com/view/?hajqrjan7ag48zu
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Steve Herrod replied 1 year ago.

Steve Herrod :

Hi, I'll be happy to do this and will complete for you as soon as possible

Steve Herrod :

Will need the StudentStart database though to begin, can you provide that?

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer: Where do i find that they just gave me that and somw other information that ill post right now thank you so much!!. :)
Steve Herrod :

These are the instructions

Steve Herrod :

The Access2010 Student Start database is found as a link in Access assignment folder in BlackboardVista.

Steve Herrod :

once I have that I can get the file to you asap

Customer:

ok... I cant send it to you but can you log in to elearning.tamu.edu my login is zarethavaldez then my passwords is 022292*Fer then you give a click on the 12 FALL INFO 209 502:Busn Info System Concept and then you click on assignments and then you click on Assignment 4, Access which is all the information on how to do everything from instructions and other helpful stuff you may need and its also includes the access2010 student start database link

Customer:

is that good?

Steve Herrod :

thank you - will check that and get started for you

Customer:

thank youu sooooo muchh!

Steve Herrod :

no problem :)

Customer:

heyy! do you have any questions?

Steve Herrod :

hey, not so far....

Customer:

perfect thank you so much for helping me

Steve Herrod :

no problem :)

Customer:

it states that this question is close can you please help me?

Customer:

Is it going to be ready by the 15?

Customer:

???

Steve Herrod :

no idea why it is saying question is closed....

Steve Herrod :

yes, will be ready by then

Customer:

ok thank youu!. I wanted to make sure!

Steve Herrod :

no problem :)

Customer:

hi I was wondering if the project is going to be done by today or buy early tomorrow? I really dont want to rush you Im justs asking

Steve Herrod :

no that's fine :) will be early tomorrow at latest

Customer:

thank youu:)

Steve Herrod :

:)

Customer:

where you able to finish it?

Customer:

???

Steve Herrod : Is almost done
Steve Herrod : meant to ask, the document says 20th november?
Customer:

I know the dumb teacher change the date bc he doesn't wants to check it over the break!

Steve Herrod : Ah ok, just wondered!
Steve Herrod : working on it for asap!
Customer:

thank you!! so muchh!! mmm can you please have all the delirables ready to print since my class is at 1 please

Customer:

deliverables

Steve Herrod : Sure
Steve Herrod :

Am having a slight issue right now - have a power cut.....

Steve Herrod :

on my phone at moment

Customer: Do you think your going to have it ready?? I dont want to rusg you i can turn it in late at 5?. I dont want to rush you
Steve Herrod :

it will be ready but not sure I will have an Internet to send it by 1

Steve Herrod :

if it is ok with you can we say 5?

Customer: Yeah thats fine just please have the deliribles ready to print
Steve Herrod :

just uploading now

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

  1. Major Assignment Labeled Query Designs and Results (MSWord document)


Note: Your name is XXXXX XXXXX left-aligned and INFO209501 or INFO209502 is to be right-aligned in the document header. The current date is to be left-aligned and ‘Page # XXXXX #s’ is to be right-aligned in the footer of this document.



  1. Major Assignment Case Load Report Design View (last page of above MSWord document or separate MSWord document). Design image is to be cropped and re-sized so that ALL design elements are easily viewed.

Customer:

are these the microsoft word document?

Steve Herrod :

yes - all in the Word document

Customer:

hey I think Query 10 is wrong because instruction state that


Create a two parameter query for the Office Name field of the Office table and Won field of of the Case table.


 


List the Office Name, Department Name, CaseID, Date, Fee, and Won fields.


 


Sort by DepartmentName in ascending order.


 


Query result fields should be labeled ‘Office', 'Department', 'Case Number', 'Date', 'Fee', and 'Status'.


 


Enter Houston and Pending in the two resultant dialogs.


 


Note:



  1. 1. Do NOT enter these values on the criteria line of the design grid

    1. 2. Watch out for multiplier effect


Customer:

and we put all of them not just houston and pending right?

Steve Herrod :

the instruction means, don't put "Houston", or "Pending"

Steve Herrod :

well, based on normal Access coding

Steve Herrod :

the two query parameter will need something in there

Customer:

I think that what he meant was just but the houston and pending because he put them in the criteria box... and then gave him that results

Steve Herrod :

if Houston and Pending are in criteria, it won't give a 2 query parameter though

Customer:

look let me send you the video where he is stated because he is not helping me at all :( Im sorry promise a great bonous...

Steve Herrod :

ok - no problem

Customer:

and in query 4 the currency its not in dollars do you thing you can change that?

Customer:

and in query 5 it states


Query 5 –


Which Case(s) charge at least $20,000 and have been Won?


 


List, in this order, the concatenated ClientFirstName and ClientLastName fields, separated by a space; and the fields Date, Fee, and Won.


 


Sort in descending order of Fee.


 


Query result fields should be labeled ‘Client’, ‘Date’, ‘Fee’, and ‘Status’.

Customer:

and we put cases with lower fees than 20000 and there status pending

Steve Herrod :

query 4 is amended now

Steve Herrod :

5 is good now

Customer:

query 7 it states that


What are the names of Clients who live in "Houston" or see lawyers from the Houston office, or see lawyers in the "Environmental Law" legal department?


 


List, in the following order, the concatenated ClientFirstName and ClientLastName fields separated by a space; City; concatenated LawyerFirstName and LawyerLastName fields separated by a space; LegalDepartmentName; and OfficeName.


 


Sort alphabetically by City.


 


Query result fields should be labeled ‘Client’, ‘City’, ‘Lawyer’, ‘Department’, ‘Office’.


 


Note: Watch out for multiplier effect but we just put Houston not environmental law then we need to put them alphabetical by city without any multiplier effect

Customer:

query 8 stated


Query 8 –


How many lawyers are there in each legal department and what is the total of their salaries?


 


Select fields LegalDepartmentName, LawyerID and Salary.


 


Sort in descending order by Salary.


 


Query result fields should be labeled ‘Department ’, “# XXXXX” and ‘Total Salary’.


 


Each department should be listed only once in the query results. Use appropriate aggregate functions for LawyerID and Salary. and we repeated the department and it should be listed only once

Steve Herrod :

checking 7 and 8

Steve Herrod :

am still confused about 10

Customer:

ok im uploading the file fot query 10 its bearly in 30 percent just uploading it Ill send the link

Steve Herrod :

ok

Steve Herrod :

what time is it there by the way?

Customer:

its 429 so i have 30 min to turn this in lol

Steve Herrod :

ah ok

Steve Herrod :

I've amended doc for 4 and 5

Steve Herrod :

checking 7 and 8 at moment

Customer:

okk.. thank you

Steve Herrod :

8 is better now

Steve Herrod :

7 should be working as they are OR statements

Steve Herrod :

....

Customer:

so 7 is right as it is?

Steve Herrod :

just rechecking

Steve Herrod :

amended 7 so it's a cleaner query as think that's what he wants

Customer:

ok... the video its almost uploaded

Steve Herrod :

shall I resend document to you now or is the video almost uploaded?

Steve Herrod :

ah ok

Steve Herrod :

will hold

Customer:

no the video its almost done it need 3 min

Steve Herrod :

ok

Customer:

http://www.mediafire.com/?ca1qfkwd4c550n2

Customer:

its at the end of the video

Steve Herrod :

ok

Customer:

last 10 min

Steve Herrod :

it's downloading now

Customer:

ok perfect

Steve Herrod :

Here is the file with everything else amended just in case

Customer:

ok

Steve Herrod :

2 mins left to download

Customer:

ok in query 1 the departments are not alphabetically in order

Customer:

disregard my message on the top

Steve Herrod :

about query 1?

Customer:

no no my felt its was right

Steve Herrod :

ok

Steve Herrod :

want me to send new doc with slight change to 10?

Customer:

yes

Steve Herrod :

ok - doing that now

Customer:

query 6 has no dollars sign

Customer:

s

Steve Herrod :

Query 6 good there

Steve Herrod :

and 10 too

Customer:

i cant download it can you send it again

Customer:

???????

Steve Herrod :

is that link ok?

Steve Herrod, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 2567
Experience: Trained in Microsoft Office from 2000 through to latest version 2010.
Steve Herrod and 2 other Microsoft Office Specialists are ready to help you

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:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • 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!!!! Alex Los 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. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, 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. Esther Woodstock, 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. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional