Punjab 12th Class Computer Chapter 12 Using Queries in Access Mcqs Test Online Punjab 12th Class Computer Chapter 12 Using Queries in Access Mcqs Test Online 1234567891011121314Show paginator Hide paginator Question 1 of 14Computer Science 1. This query wizard will create a select query 1.Simple 2.Find Duplicates 3.Design View 4.Cross tab Question 1 of 14Question 2 of 14 2. Which of the following is not one of the methods available in the New Query dialog box to create queries? 1.Datasheet view 2.Cross tab Query Wizard 3.Simple Query Wizard 4.Design View Question 2 of 14Question 3 of 14 3. DBMS stands for 1.Database Management System 2.Database Model System 3.None of these 4.Datasheet Management System Question 3 of 14Question 4 of 14 4. Query design window has two parts. The upper part shows 1.Sorting check boxes 2.Name of fields, field type and size 3.Criteria 4.Tables with fields and relationships between tables Question 4 of 14Question 5 of 14 5. Which of the following statement is true? 1.Queries can include calculated fields that do not exist in table 2.Reports and forms are similar but forms are use to print but reports to display on screen only 3.Queries can be printed in well formatted manner and presented as the information 4.Reports can be used to retrieve data from tables and calculate Question 5 of 14Question 6 of 14 6. What is the full form of SQL? 1.Structured Question List 2.Sophisticated Question List 3.Small Query Length 4.Structured Query Language Question 6 of 14Question 7 of 14 7. Queries in Access can be used as 1.View, change and analyze data in different ways 2.Both a and b 3.A source of records for forms and reports 4.Only a Question 7 of 14Question 8 of 14 8. To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values. 1.Formula field 2.Numeric field 3.Calculated field 4.Formulated field Question 8 of 14Question 9 of 14 9. To create queries in Access 1.You can use query wizard or design view 2.You can drag and drop fields on query builders 3.You can type the SQL command in SQL view 4.All of above Question 9 of 14Question 10 of 14 10. What does the show check box in query design window indicate? 1.It indicates whether the field is to be used or not 2.It indicates whether the field names to be displayed in query result or not 3.It indicates whether the field is to be displayed in query result or not 4.None of these Question 10 of 14Question 11 of 14 11. A _________ enables you to view data from a table based on a specific criterion. 1.Form 2.Report 3.Query 4.Macro Question 11 of 14Question 12 of 14 12. Which query do you use to answer the question “Which employees earn more than Rs. 5000 a month”? 1.Cross tab query 2.Search query 3.Update query4.Select query Question 12 of 14Question 13 of 14 13. Queries are based on this, allowing you to use a query as the source for forms and reports: 1.Records 2.Fields 3.Filters 4.Tables Question 13 of 14Question 14 of 14 14. The result of a query is displayed in a 1.Form 2.Query table 3.Record 4.Query datasheet Question 14 of 14 Loading... Test By Subject Punjab Test By Topics 12th Class Computer You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.