CBSE SOLUTIONS-2025-26
CLASS-8
CHAPTER-3 Queries, Forms and Report in MS Access
A. Tick the correct answer:
1. How many views does Access provide to display a form?
a. Two b. Three c. Four d. Five
Answer: Three
2. Which of the following is not a view for working with a form object?
a. Form view b. Datasheet view c. Design view d. Layout view
Answer: Datasheet view
3. Which of the following is not a view for displaying a report?
a. Print Preview b. Design view c. Layout view d. Datasheet view
Answer: Datasheet view
4. The Query Design option is present on the ________ tab.
a. Home b. Create c. External data d. Database tools
Answer: Create
5. A report has _____________ views.
a. Two b. Threeq c. Four d. Five
Answer: Four
B. Write T for true and F for false:
1. We can create query by using the Query wizaard only.
Answer: F
2. The form option is present in the forms group on the create tab.
Answer: T
3. The Design view of the form displays only the structure of the form.
Answer: T
4. We can print reports using the Print option.
Answer: T
5. The Query wizard option is present in the Queries group.
Answer: T
C. Fill in the blanks:
1. The _________ view is used to enter, edit and view data of the form.
Answer: Form
2. __________ view displays only the structure of your form.
Answer: Design
3. A ____________ is a method of getting answers to questions.
Answer: Query
4. Queries, forms and reports are _________ of Access.
Answer: Object
5. A __________ is an effective way to present your data in printed form.
Answer: Report
D. Answer the following questions.
1. What is a Query?
Answer: A Query is a method of getting answers to questions about the data. The query involve a single table or multiple tables to answers a questions about the data.
A query is used to retrieve selective data based on specific criteria.
2. What are forms and Reports.
Answer:
Forms: Forms provide an easy way to enter, edit, delete and view data in a table. Forms are made up of elements such as text boxes and lables. These elements are called controls. It allows we to add and update data in a table, one record at a time.
Report: Reports are an effective way to present your data in printed format. We can customize the appearance of tabular data on a report. Thus we can display the information the way we want to see it.
3. What is the use of the Print Preview and Design view of a report?
Answer:
Print Preview: This view displays the report as it will apear after printing.
Design View: This view displays only the structure of our report. In this view, we cannot see the underlying data, but we can perform some tasks that we cannot perform in Layout View.
4. Write the steps to print a report.
Answer: Steps to print a report:
Step 1: Click on the down arrow under the view option in the views group on the Home tab.
Step 2: Clic on the Print preview option. The report displayedin the manner in which it would appear on a page.
Step 3: Select the appropriate values for page size, margins and orientation from the Ribbon.
Step 4: Clic on the Print option to print the report.
5. What is the use of the layout view and Design view of a form?
Answer:
Layout View: You can view the data and make changes in the form, such as changing the size of the various controls.
Design View: Design view displays only the structure of your form. In this view, you cannot see the underlying data, but you can perform some tasks that cannot be performed in layout view such as viewing header and footer.
SOME OTHER LINKS:
.png)
No comments:
Post a Comment