Chapter 3: MS Access 2016 – Queries, Form, and Report
---
MULTIPLE-CHOICE QUESTIONS (1 mark each)
1. How many panes are there in the Query Design window?
b. Three
2. Which view allows you to change the appearance of a form?
b. Layout view
3. Which tab contains the commands to create a report?
a. Create tab
4. Which of these is used to define a relationship between two tables?
a. Primary key
5. Conditions in the Query Design window are given in the:
a. Criteria row
---
FILL-IN-THE-BLANKS, TRUE/FALSE, MATCHING (2 marks each section)
A. Fill in the Blanks
1. A Form is a user-friendly database object used to add and delete records in a table one at a time.
2. Queries are created on the data given in a Table.
3. In Design view, the Query window has two parts.
4. You can set the criteria in a query using the Criteria row of the Query Design window.
5. A Report is an effective way to organise and summarise data for viewing or printing.
B. True (T) or False (F)
1. T – You can use the Criteria row in the Query Design window to specify multiple criteria.
2. F – Once you set up a relationship between two tables it cannot be deleted.
3. T – MS Access provides you with two types of queries.
4. F – A form cannot be used for editing records in a table.
5. T – The Query Design window is divided into two parts.
C. Match the Following
Column A Column B
1. Primary Key c. A unique field to establish a link between multiple tables.
2. Query e. It helps extract data from a database based on a criterion/condition.
3. Form d. Allows viewing, adding or deleting records in a table.
4. Report b. It organises and summarises data for viewing or printing.
5. Criteria a. A condition applied to extract selective data in a query.
A. Short Answers
1. Advantages of setting up a relationship between tables ?
- Maintains data integrity, avoids duplication, enables efficient retrieval from related tables.
2. Difference between Query and Form ?
- Query: Filters/extracts specific data from tables using criteria.
- Form: Provides a user-friendly interface to add, edit or view records.
3. Describe the various Navigation buttons in a Form window ?
- First record, Previous record, Next record, Last record, New (blank) record.
4. What is the use of setting up a query criteria ?
- To display only those records that satisfy the specified condition(s).
5. Write the general Steps to set a query condition in a field?
- Open query in Design view → type the condition in the Criteria row under the required field → Run the query.
6. What are Reports in MS Access?
- Database objects that organise/present data from tables/queries in a printable format for analysis or sharing.