Chapter 4 :- Access – Query & Report

July 12, 2023 chinu

Chapter 4 :- Access - Query & Report

Q.1 Tick the correct answer.

1. A question respresented in a way that access can understand is called a __________

(a) Form
(b) Query
(c) Datasheet

2. _______ query displays the same data , but groups the data both horizantally and vertically.

(a) Cross tab
(b) Simple
(c) Duplicate

3._________ window display the feilds for the table you selected to apply query.

(a) Select query
(b) Show table
(c) Show query

4. While sorting more than one feild, the more important feild is called __________

(a) Minor key
(b) Enter key
(c) Major key

5.The two special wild cards for Query provided by Access are ____________

(a) * and /
(b) * and ?
(c) + and ?

6. A database object for displaying data from a table in an appealing way is known as __________

(a) Report
(b) Query
(c) Datasheet

Q.2 Write True and False for Statement.

1.In Microsoft Access there are mainly four types of queries. True
2.You cannot remove the table from the query once it is added. True
3.You can sort data in a specified sequence -alphabetically , numerically or by data. True
4.Wildcards are conditions that identify the records we want to find. True
5.Page reader provides the data for creating reports. False

Q.3 Fill in the blanks.

1.A query can be created using Design view and criteria
2.The conditional that identify the records you want to find are called criteria
3. Wildcard are symbols that represent any character or combination of characters.
4.The feild on which the records are sorted is called the sort key.
5.The lines that are printed for each record are called detail line in Report.
6.Blank Report is the quick way of building a report.

Q.4 Define the following terms .

1. Simple Query :- Simple query is used to ask some particular question about data in the database.
2. Unmatched Query :- It is used to find the record from one table that do not have corresponding values in the second table.
3.Duplicate Query :- Duplicate is used to display the record that have for one or more of specified feild.

Q.5 Answer in 1-2 sentence.

Q.1 What do you understand by query?
Ans :- Query is simple a question represented in a way that access can understand and give response to the user.

Q.2 What do you mean by running a query?
Ans :- You need to run the query for producing the result after the query is created by user.

Q.3 Why do need sorting?
Ans :- To sort the record to order them in the answer a particular query called sorting.

Q.4 What do you mean by report?
Ans :- A report is a database object used to display data from query and/or table in an appealing way.

Q.5 Answer Briefly.

Q.1 What is the use of wildcards in a query?
Ans :- Wildcards are symbols that represent and character or combination of characters . Access provide two wildcards
(1)asterisk (*) (2) Question mark(?)

Q.2 Explain the components of Reports.
Ans :- (1) Page header :- It contains custom title at the top of the report.
(2) Detial lines :- Lines contains only those feilds which you specify.
(3) Records source :- Tables/Queries that provide the underlying data of the reports.