BTAC 165 - Access: Use Queries to Produce Information

Credits: 1
Introduces users to queries using Microsoft’s Access database application. Uses queries to retrieve data and extract records meeting criteria stored within the tables of a database. Students customize, analyze, and summarize query data to make decisions.

Recommended: Basic knowledge of computer, keyboarding, and Access skills.

Course Fee: $5.00

Course Outcomes:
Students who successfully complete this class will be able to:

Create a calculated field in a query.
Create expressions with the Expression Builder.
Demonstrate the order of precedence.
Create and edit Access functions.
Perform date arithmetic.
Create and work with data aggregates.

Program Outcomes

Implement calculator/computer technology to solve problems.
Integrate Microsoft Office software applications to present information in a meaningful manner.

College-wide Outcomes

Critical Thinking - Critical thinking finds expression in all disciplines and everyday life. It is characterized by an ability to reflect upon thinking patterns, including the role of emotions on thoughts, and to rigorously assess the quality of thought through its work products. Critical thinkers routinely evaluate thinking processes and alter them, as necessary, to facilitate an improvement in their thinking and potentially foster certain dispositions or intellectual traits over time.
Responsibility - Responsibility encompasses those behaviors and dispositions necessary for students to be effective members of a community. This outcome is designed to help students recognize the value of a commitment to those responsibilities which will enable them to work successfully individually and with others.