IT 1010 Exam 4 Access 2016 Part II (50 points) 1. Using the Jobs table, create a

Question

IT 1010 Exam 4 Access 2016 Part II (50 points) 1. Using the Jobs table, create a new query for each of the tollowing tasks a. (4 points) Display all fields for all the records in the Jobs table b. (4 points) Display the Job ID, Customer ID, and Job Status for all records in the Jobs table c. (6 points) Display the Job ID, Customer ID, Job Status, and Quote for al jobos d. (6 points) Display the Job ID, Customer ID, Job Status, and Completion e. (6 points) Display the Job ID, Customer ID, Job Status, and Quote for all jobs f (6 points) Display the Job ID, Customer ID, Job Status, and Completion g. (6 points) Display the Job ID, Customer ID, Completion Date, and Quote for h (6 points) Display the Job ID, Customer ID. Job Description, and Quote for with a job status of C Date for all jobs with a completion date ater Jure 1 2017 with a job status of I and a guote of more than $2000 Date for all jobs with a job ID that beains wieh M all jobs with a guote of less than $500 the jobs with a guate creater than 5500 and less than $2.000 (Hint Enter a cniteria of 500 And -2000 for Quote) i (6 points) Display the Job ID. Customer ID, Job Status, and Completion Date of all records in the Jobs table soted n ascending sequence by customer ID 2 Close the Repair Shop database and ouit Access 3 Submit your database mough the Blackboard ink

Explanation / Answer

Ans a) SELECT * FROM JOBS_TABLE;

Ans b) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS FROM JOBS_TABLE;

Ans c) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS,QUOTE FROM JOBS_TABLE WHERE JOB_STATUS = 'C'

Ans d) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS,COMPLETION_DATE FROM JOBS_TABLE WHERE COMPLETION_DATE > '2017-06-01'

Ans e) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS,QUOTE FROM JOBS_TABLE WHERE JOB_STATUS = 'l' AND QUOTE>2000

Ans f) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS,COMPLETION_DATE FROM JOBS_TABLE WHERE JOB_ID LIKE 'M*'

Ans g) SELECT JOB_ID,CUSTOMER_ID,COMPLETION_DATE,QUOTE FROM JOBS_TABLE WHERE QUOTE < 500

Ans h) SELECT JOB_ID,CUSTOMER_ID,JOB_DESCRIPTION,QUOTE FROM JOBS_TABLE WHERE QUOTE BETWEEN 500 AND 2000

Ans i) SELECT JOB_ID,CUSTOMER_ID,JOB_STATUS,COMPLETION_DATE FROM JOBS_TABLE ORDER BY CUSTOMER_ID ASC

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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