Computer Worksheet Class 8 : Queries, Forms, and Reports in Access 2023
Computer Worksheet Class 8 English Medium. This page’s topic is Queries, Forms, and Reports in Access 2023. We have given here several types of questions, i.e., MCQ, Very Short, Long, Application-Based Questions, Full Forms, Fill in the Blanks, True and False, and many more.
Q1) Name the following :- (5 marks)
1) It displays specific records from a table that meets a certain criteria. Query
2) It is a graphical representation of a table. Form
3) The effective way to present your data in a printed format. Report
4) The view which is used to enter or edit the data. Form View
5) The command from the Queries group of Create tab which is used to create a query in Access 2016. Query Design
Q2) State whether the following statements are True or False :- (5 marks)
1) A query is nothing more than a graphical representation of a table. False
2) A report is an effective way to present your data in a printed format. True
3) A query always displays the specific records from a table that meets a certain criteria. True
4) Table row displays the name of the table. True
5) Layout view is used to enter or edit the data. False
Q3) Answer the following questions two or three sentences each :- (10 marks)
1) What is a Report?
Answer: – Report is the best method to present the data (information) into the printed form.
2) What is a Form?
Answer: – It is the displaying of the data in a graphical tabular form.
3) What is the difference between AND and OR condition.
Answer: – The difference between AND and OR condition are as followed :-
a) AND condition :- If the two criteria are been typed on the same line and hence the both criteria meets will get displayed. This is called AND condition.
b) OR condition :- When the first criteria is typed on the criteria row and the second criteria on the OR row, the meeting point of the both criteria are displayed. This is called OR criteria.
4) How can one create a query in Access 2016?
Answer: – The queries in Access 2016 can be created by using the command of Query Design from the Queries group of Create tab.
5) Name the four views in which the reports can be displayed?
Answer: – The reports can be displayed in four views which are Report view, Print Preview, Layout View and Design View.
Q4) Answer the following questions in brief :- (20 marks)
1) What do you understand by a Query? Explain the steps to create a query.
Answer: – As we know that there are number of records in a table, if the user needs to find/pick out a particular record then it is very difficult to do so. In this matter Query plays a vital role in showing only the records from the table which meets a certain criteria/the information/records that you want.
The steps for creating a query are as :-
i) Make a click on the CREATE tab.
ii) From the Queries group click on Queries group, after which the show table dialog box appears.
iii) Now select the table, in which you wants to create a query.
iv) Now click on Add button. You’ll notice that the selected table gets added in the Query window.
v) Click on Close button.
2) Explain the Query window in detail?
Answer: – The Query window is divided into two panes/parts which are top pane and bottom pane. The top pane is used for showing the tables which are selected for query whereas the bottom pane will display the design grid where in query you can add the fields and we can specify the criteria. Below we will study about the design grid in detail and check what does it show (headings):
Field: – It is used for showing the fields of the selected tables.
Table: – It is used for showing table name.
Sort: – It is used to filter the data in ascending and descending order.
Show: – It shows the check mark which is used for indication that the field visibility when the query will be executed.
Criteria: – It is used to specify the condition on the basis of which the records filtration will be done.
Or: – It is used for specifying multiple criteria.
3) What do you understand by Form? Explain the steps to create a form?
Answer: – In simple terms form is nothing but it is representation of the table in the graphical form. It is similar to a job application form which has fill in the blanks sheet and you need to complete/fill it by your hand. It’s the simplest method of entering data into the database. Microsoft Access performs the task of linking the form with the table and helps in storing the information i.e is stored into the form of the table. When you have various fields in a table, then using the form is a very nice option. This helps in viewing all the fields in one screen and table view helps in scrolling till we get the desired field. The steps for creating a form are:
i) Make a click on the create tab.
ii) From the form group make a click on Form option. After which access creates a form and places all the selected fields/contents of the table in the form.
Note: – If you wish to move through the records in the field, then make use of the Navigation bar.
By the way there are three ways in which you can display your form which are Form view, Layout view, Design view.
Though the names of the table and form are different from each other, but the data into them are the same. For ex :- if you wish to make a change in a record of the form immediately you’ll notice the same change in the record of table.
4) Explain the steps to create a Report?
Answer: – The steps to create the report are as followed:-
First of all select or make a click on the table or query where you wish to create a report.
a) On the Ribbon make a click on the Create tab.
b) From the Reports group click on Report.
You will notice that access will create a report and place all the fields and the corresponding records on the selected tables on the report.
5) Explain the three views in which the form can be displayed?
Answer: – The three different views in which the form can be displayed are :
a) Form view: – This view is used when we want to enter or edit the data.
b) Layout view: – In this view, we can preview of the data’s appearance after using the form. This view is also used for changing the design of the form. When the form is viewed in layout view, the form runs.
c) Design view: – This view will give the brief descriptional view of the form’s structure. In this view, you may notice the form is divided into three sections/parts which are Form Header Detail and Form Footer. The form does not gets runned when the form is previewed in this Design view.