CLASS 10 UNIT 3 SESSION 5 IMPORTANT NOTES
CLASS 10 UNIT 3 SESSION 5 IMPORTANT NOTES
SESSION 5: CREATE FORMS AND REPORTS USING WIZARD
FORM:
A form provides the user a systematic way of storing information into the database. It is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
Creating Form Using Wizard:
1.Click Use Wizard to Create Form… option under Tasks group. The Form Wizard dialog box appear.
2. Select selective fields to be sent onto the form by selecting the field name and clicking >button and Click Next.
3. Select the option Add Subform if you need to insert the contents in the table in a separate form and Click Next.
4. Arrange selected fields in a form and click Next. You can use different styles from the list.
5. Select the data entry model and click Next.
6. Specify the styles to be used in the form and click Next.
7. Specify the name of the form. Click Finish.
Reports:
A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format. You can create reports in the database.
Creating Reports using wizard:
1.Click on Use Wizard to Create Report… option available under Tasks.
2. Select all the table fields by selecting the >> button.
3. Redefine the label of the fields in the reports or else you can set the default name and click Next.
4. Define grouping for the fields of the table if required and click Next.
5. Sort the field in the report by selecting the appropriate field name and sorting method and click Next.
6. Select the layout of the report and click Next.
7. Define a name for the report and click Finish.
ASSESSMENT
Fill in the blanks:
- To create a form you need to select __FORM__ option available under Database section.
- A ___QUERY_______ is helps to collect specific information from the pool of data in the database.
- _REPORT___ is used to display the display the summary of data.
- __FORMS________ are the interfaces with which the user interacts.
- Data from multiple tables can be stored in _Relational Database____.
Short Answer Questions:
1.Why there is a need to create Forms?
Answer : A form provides the user a systematic way of storing information into the database. It is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
2. What is the purpose of creating Reports?
Answer: A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.
3. What are the prerequisites to create a Form and Reports?
Answer: To create a form , you need to create a Database then you need to create table according to
your requirements.
To create report you must have at least one table with records under your database.
4. Differentiate between Forms and Reports.
Answer: Form: A form provides the user a systematic way of storing information into the database. It is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
Reports: A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.
5. Can a form displays data from queries?
ANSWER: Yes , A form can displays data from queries.
6.In how many ways Forms and Reports can be created in a database?
ANSWER: Forms can be created in two ways:
- Create Form in Design view
- Use Wizard to create form.
Reports can be created in one way:
- Use Wizard to create reports.
One thought on “CLASS 10 UNIT 3 SESSION 5 IMPORTANT NOTES”