CS 100 Databases

Unit 3: Advanced Data Entry and Viewing

Objectives

At the end of this unit you will be able to:

• Create a database form.
• Create a database report.

Lecture

Advanced Data Entry and Viewing

Skills

This unit's objectives are the following database skills:

• Lesson 6: Creating a Database Form
• How do you create a simple form?
• How do you use a form to enter and view data?
• How do you edit a form from the Form Design view?
• Lesson 7: Creating a Database Report
• How do you create a simple report?
• How do you edit a report from the Report Design view?

You can, of course, complete the lessons in any order.

Concepts

An understanding of certain concepts is necessary for success in the lessons. The following concepts are defined where applicable in the lesson text. You may also click on any concept listed here to see it defined.

1. What is a form?
2. What are the different options for creating a form?
3. What is a report?
4. What are the different options for creating a report?
5. What is a control?
6. What is the difference between filters, forms and reports?
7. When do I use a report instead of a form?
8. What are the parts of a report?
9. What is a summary?
10. What are the different kinds of summaries?
11. What are groups and sub-summaries?

Self-Check

Do you know the difference between a form and report? The following self-check will test your understanding of this and other concepts:

• DB Self-Check #3

Assignments & Quizzes

You must complete the following assignment associated with the lessons above to receive credit for this unit:

• Database Assignment 3

Copyright 1997 by the Curators of the Universityof Missouri