Outcome Summary Introduction to Microsoft Access
Title
Introduction to Microsoft Access
Course Number
10103103
Credits
1
Organization
Western Technical College
Developers
Barb Truax
Development Date
5/4/2005
Revised by
Revised date
Instructional Level
Associate Degree Courses
Instructional Area
Computer Software - 103
Division
Business
Department
Business Data Processing
| Instructional Type | Contact Hours | Outside Hours | Credits |
| Lecture | 18 | 0 | 1 |
Description
Designed to introduce the student to the basic features of Microsoft Access. Specific features include creating database structures; adding editing and deleting records; running queries; and printing database objects. Working knowledge of Windows, basic computer knowledge, and touch keyboarding skills are essential.
Prerequisites
- None
Supplies
- 2 3 1/2" high density diskettes
Core Abilities
- Demonstrate ability to think critically
Competency
1. Use the basics of Microsoft Access
Criteria - Performance will be satisfactory when:
- learner successfully starts and exits Access
- learner defines database software and recognizes database terminology
- learner identifies components of the database window
- learner utilizes the Access help function
Learning Objectives
- Define database applications
- Identify and demonstrate the components of the Access user interface
- Discuss database terminology
- Explain and demonstrate the Access Help function
2. Construct table data
Criteria - Performance will be satisfactory when:
- learner correctly adds information to a table
- learner correctly selects and edits table data
- learner correctly prints table data
Learning Objectives
- Demonstrate table data manipulation
- Illustrate Access editing functions
3. Modify table structure and design
Criteria - Performance will be satisfactory when:
- learner distinguishes between datasheet and design view
- learner changes the table appearance by modifying the table design
Learning Objectives
- Explain datasheet and design view formats
- Discuss data types
- Discuss and develop data property assignments
4. Develop forms
Criteria - Performance will be satisfactory when:
- learner creates a simple, columnar form
- learner prints a form
Learning Objectives
- Create a simple form
- Use a simple form
- Switch between Form View and Datasheet View
5. Query and filter database records
Criteria - Performance will be satisfactory when:
- learner identifies and applies filters to data
- learner correctly creates and executes queries
- learner creates a calculated field within a query
Learning Objectives
- Explain and demonstrate data filtering
- Discuss query use
- Convert calculation scenarios to Access syntax
- Demonstrate query development
6. Develop reports
Criteria - Performance will be satisfactory when:
- learner creates reports using Access tools
- learner correctly modifies report design
Learning Objectives
- Discuss report types and formats
- Demonstrate the Report Wizard
- Identify report controls and control property modification
