BTECA 143 Microsoft Access (3 credits)
Course Description
Students will learn how to navigate MS Access and create customizable database applications.
Course Content
A. Store information: users can create tables to store data about customers, products, orders, and more
B. Manage data: users can create relationships between tables to bring data together in queries, forms, and reports
C. Analyze data: users can use queries to find and retrieve data, and to perform calculations
D. Report data: users can use reports to present data in print or other forms
E. Update data: users can use queries to update or delete multiple records at once
Student Outcomes
- Apply skills and concepts to manage data input when creating personal, academic, and workplace databases in Microsoft Access.
- Identify the use of queries, tables, and forms in Microsoft Access Database.
- Design and modify queries, tables, and forms in a Microsoft Access Database.
Degree Outcomes
Program Outcome: Demonstrate proficiency in efficiently performing a variety of administrative tasks. (Including answering phones, managing schedules, handling correspondence using common office software such as word processing, spreadsheet, presentation, and email/calendar management programs.)
Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.
Lecture Contact Hours 30
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 30
Potential Methods
1. Discussion, in class or online
2. Instructor assessment
3. Objective test
4. Peer assessment
5. Production test
6. Computerized test
7. Self-assessment
8. Individual project
9. Completed documents
Add to Portfolio (opens a new window)
|
