hi I SENT YOU A QUESTION ABOUT access how to . and job Query and filer our searc

Question

hi I SENT YOU A QUESTION ABOUT access how to . and job Query and filer our search to specific records .. but I receive unclear answer and I don't what to write for example the picture below asking for job ID that begins with M and when I enter the letter M and press the ran bottom it gives blank table like in this picture

it gives me a blank result and it happened with the rest of the tables would you pls explain step by step how to enter the data to give me the right result and the picture below is the instructions for this homework

Explanation / Answer

1.

a.

Select * from jobs;

b.

Select JobID,CustomerID,Job_Status from jobs;

c.

Select JobID,CustomerID,Job_Status,Quote from jobs where Job_Status = 'C';

d.

Select JobID,CustomerID,Job_Status,CompletionDate from jobs where CompletionDate > 'June-01-2007';

e.

Select JobID,CustomerID,Job_Status,Quote from jobs where Job_Status = 'I' and Quote > 2000;

f.

Select JobID,CustomerID,Job_Status,CompletionDate from jobs where JobID LIKE 'M%';

Use LIKE for pattern matching , JobID first character is M followed by any number of characters.

g.

Select JobID,CustomerID,Job_Status,CompletionDate,Quote from jobs where Quote < 500;

h.

Select JobID,CustomerID,Job_Status,Job_Description,Quote from jobs where Quote > 500 and Quote < 2000;

i.

Select JobID,CustomerID,Job_Status,CompletionDate from jobs rder by CustomerID;

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.