Chapter - 3
Forms, Queries and Reports
WORSHEETS
Worksheet 1 Multiple Choice Questions (MCQs.) Tick the correct answer.
1. We can generate Reports and Queries from:
a. Tables
b. Form
c. Auto Format data
d. Cells
2. Which Tab do you need to click to create the Form?
a. Home
b. Create
c. External data
d. Database Tools
3. Where are the previous, first, next and last record buttons located?
a. Title bar
b. Menu bar
c. Navigation bar
d. Show table Window
4. What are the screens used for displaying data and entering/updating data in tables known as?
a. Tables
b. Forms
c. Reports
d. Queries
5. What is a small graphical representation of an organization or theme?
a. Logo
b. Form
c. Design
d. Button
6. Which button allows us to select an attractive layout from many readymade available layouts?
a. Design
b. Navigation
c. Auto Format
d. Form button
Worksheet 2 Write True and False against the statements.
1. You set the criteria for a Query so that only those records which meet the criteria are displayed. TRUE
2. If you want to add all the fields of the table in your Query, double click on the Asterisks(*) displayed with the table fields in the query grid. TRUE
3. you can specify a criteria for a report. TRUE
4. The Themes button contains various types of styles and layout which can be applied to the Report which has been generated, it cannot be customized. TRUE
5. Once a Report has been generated, it cannot be customized. FALSE
Worksheet 3 Select the suitable words and fill in the blanks
Create Form Navigation bar Criteria Report Query
1. Using a Form data can be entered more conveniently and in a user-friendly manner.
2. Below the Form, you will see the Navigation bar to go to previous, next, first or last record.
3 When you run the Query, only those records, which match the Criteria mentioned, will be displayed.
4. To generate a basic Report, click on the Create tab and click on the Report button.
5. To generate a Query, click on the Create tab and click on the Query button.
Worksheet 4 Answer in one Words/Sentence.
1. What helps us to retrieve the required information in a quick and formatted manner?
Answer: Simple Query
2. From where can we generate Reports and queries?
Answer: Create tab
3. Which Tab and option will you use to create a form in Microsoft Access?
Answer: Create tab -> form button
4. What is the use of navigation bar?
Answer: To go to previous, next and last record.
5. What helps us to quickly view the selective data?
Answer: Query
6. What is Criteria for a Query?
Answer: you can add fields to display and criteria for the query in the grid.
7. What is the use of Themes option in creating reports?
Answer: It allows us to select an attractive layout from many readymade available layouts.