Class 8th Chapter 3: MS Access 2016 – Queries, Form, and Report

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 Crit…