Exercise Answers
A. Multiple choice questions:
1. We can generate reports and queries from:
a. Tables
b. Forms
c. AutoFormat data
d. Cells
Ans. b. Form
2. Which Tab do you need to click to create the Form?
a. Home
b. Create
c. External data
d. Database tools
Ans. b. Create
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
Ans. c. Navigation bar
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
Ans. b. Forms
5. Report are :
a. Methods of presenting information in a formatted and organised manner, using the Table or Query as its source.
b. Screens displaying data and entering/updating data in the tables.
c. Used to store data
d. Used to display the records that match a certain criteria, sort the data etc.
Ans. a. Methods of presenting information in a formatted and organised manner, using the Table or Query as its source.
6. What is a small graphical representation of an organisation or theme?
a. Logo
b. Form
c. Design
d. button
Ans. a. Logo
7. Which button allows us to select an attractive layout from many readymade available layouts?
a. Design
b. Navigation
c. AutoFormat
d. Form button
Ans. c. AutoFormat
B. Write true or false against the statements:
1. You set the criteria for a query so that only those records which meet the criteria are displayed.
Ans. 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.
Ans. False
3. You can specify a criteria for a report.
Ans. False
4. The Auto format button contains various types of styles and layouts which can be applied to the Report which has been generated.
Ans. True
5. Once a Report has been generated, it cannot be customised.
Ans. False
C. Select the suitable and fill the blanks.
1. Using a __________ data can be entered more conveniently and in a user - friendly manner.
Ans. Form
2. Below the form you will see the __________ to go to the previous, next, first or last record.
Ans. Navigation bar
3. When you run the query, only those records, which match the __________ mentioned, will be displayed.
Ans. Criteria
4. To generate a basic report, click on the ________ tab and click on the _________ button.
Ans. Create. Report.
5. To generate a query, click on the create tab and click on the ______ button.
Ans. Query
D. Match the following:
Ans.
1. (e)
2. (c)
3. (b)
4. (a)
5. (d)
E. Answer in one word/sentence.
1. What helps us to retrieve the required information in a quick and formatted manner?
Ans. Reports and Queries
2. From where can we generate Report and Queries?
Ans. Microsoft Access
3. Which tab and option will you use to create a form in Microsoft Access?
Ans. Create tab
4. What is the use of navigation bar?
Ans. The navigation bar is used to go to previous, next, first or last record.
5. What helps us to quickly view the selected data?
Ans. Queries
6. What is Criteria for a Query?
Ans. Please the cursor in the field for which you want to set the criteria and type the condition for which you want to obtain the results.
7. What is the use of AutoFormat option in creating reports?
Ans. AutoFormat button allows you to select an attractive layout for many readymade available layouts.
Previous << "3 Microsoft Office Access"
Next >> "5 Tables and Hyperlinks in HTML"
0 Comments