Untitled document
Students will:
1. Create or modify an existing database using a switchboard
2. Add popup forms
3. Create conditional queries
4. Create conditional macros
5. Create multi-page tabbed forms
6. Create specialized reports
Untitled document
1. Create or modify an existing database using a switchboard
A. List the principle behind a switchboard
B. Create multiple switchboard pages
C. Add graphic image to switchboard
D. Describe how to work with properties
2. Add popup forms
A. Define the use of a popup form
B. Create a popup form
C. Use popup form while entering information in database
3. Create conditional queries
A. Explain when/how to use a conditional query
B. Create conditional queries
C. Use conditional queries to create reports
4. Create conditional macros
A. Create macros that will run based on conditions supplied upon
execution of the macro
B. Run macros to create specialized reports
C. Create macros that will automate printing of specific records
5. Create multi-page tabbed forms
A. Design and create forms without using the wizard
B. Create forms that have multiple pages
6. Create reports
A. Create label reports that will print automatically based on
macros
B. Create reports that have running sums
C. Create reports based on specific conditions using macros and
queries
| Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing. | Writing
0 - 0% |
| None | |
| This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments and skill demonstrations are more appropriate for this course. |
|
| Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills. | Problem Solving
20 - 50% |
| Quizzes, Application problems | |
| Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams. | Skill Demonstrations
30 - 60% |
| Software functions | |
| Exams: All forms of formal testing, other than skill performance exams. | Exams
20 - 50% |
| Multiple choice, True/false, Production exams | |
| Other: Includes any assessment tools that do not logically fit into the above categories. | Other Category
0 - 0% |
| None | |
Untitled document
Microsoft Access 2000, Course Technology, 2000
