To receive credit, you must complete the competency assessment. You may contact your professor if you have any questions.
This competency assessment (CA) assesses your level of performance on the specific Outcome(s) that are the focus of this module. The CA requires you to demonstrate your knowledge, understanding, and proficiency of the Outcome(s). Be sure to use the other activities in this module prior to attempting the CA. You may attempt the CA multiple times within the term. However, the CA must be completed successfully by the end of the term to earn credit. Refer to your Syllabus for additional information regarding the number of attempts permitted.
Be sure to review the Competency Assessment Rubric to understand the criteria on which you will be evaluated.
Instructors will provide feedback on the CA. If you expect to receive feedback, revise, and resubmit this CA near the end of the term, be sure to follow the guidelines and deadlines for submission in your Syllabus.
Please refer to your Syllabus for additional competency assessment requirements.This competency assessment assesses the following Outcome(s):
IT163-4: Use structured query language (SQL) to manage data.
GEL-8.03: Apply critical thinking to formulate a logical solution to a problem.
Module Outcomes:
Describe simple SELECT statements with one table.
Use SELECT statements to retrieve data from one table.
Describe SELECT statements using more than one table.
Use SELECT statements to retrieve data from more than one table.
Address the role of joins in multi-table queries.
Discover built-in functions.
Use calculations to manipulate data.
Demonstrate parameters for interactive querying.
Examine action queries.
Explanation
This assessment is divided into 3 parts with multiple file submissions. Please read all directions, including submission directions for each part, and submit as directed.
Module 4 Assessment Part 1
Purpose
You will practice using SQL in the Access environment. You will examine data from a sample database using simple, single table select queries.
Assessment Instructions
Using the model car sample database provided, create queries to demonstrate a variety of simple, single table select query functionality to include selecting more than one field, using the where clause, using alias’, working with dates, sorting and using relational and logical operators.
Open the sample database.
For this assessment, you will use this sample database: IT163_ModelCarSampleDatabase.accdb
Create the five queries as detailed below. You may create these queries using the query design view or you may manually write the SQL code in the SQL view.Select the Company field from the Customers table.
Save as QueryA. Run the query to see the subset of data produced. Verify that the results are correct.
Reference:
Alexander, M.,