Punjab 12th Class Computer Chapter 12 Using Queries in Access Mcqs Test Online

• <<
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• >>

 

Question 1 of 14

Computer Science

1. Which of the following statement is true?

1.Reports can be used to retrieve data from tables and calculate

2.Reports and forms are similar but forms are use to print but reports to display on screen only

3.Queries can include calculated fields that do not exist in table

4.Queries can be printed in well formatted manner and presented as the information

Question 1 of 14

Question 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.Design View

2.Cross tab Query Wizard

3.Simple Query Wizard

4.Datasheet view

Question 2 of 14

Question 3 of 14

3. What is the full form of SQL?

1.Sophisticated Question List

2.Structured Query Language

3.Small Query Length

4.Structured Question List

Question 3 of 14

Question 4 of 14

4. To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values.

1.Numeric field

2.Formula field

3.Formulated field

4.Calculated field

Question 4 of 14

Question 5 of 14

5. Which query do you use to answer the question “Which employees earn more than Rs. 5000 a month”?

1.Search query

2.Cross tab query

3.Update query

4.Select query

Question 5 of 14

Question 6 of 14

6. This query wizard will create a select query

1.Find Duplicates

2.Simple

3.Cross tab

4.Design View

Question 6 of 14

Question 7 of 14

7. The result of a query is displayed in a

1.Record

2.Form

3.Query datasheet

4.Query table

Question 7 of 14

Question 8 of 14

8. What does the show check box in query design window indicate?

1.It indicates whether the field is to be displayed in query result or not

2.It indicates whether the field is to be used or not

3.It indicates whether the field names to be displayed in query result or not

4.None of these

Question 8 of 14

Question 9 of 14

9. DBMS stands for

1.Database Model System

2.None of these

3.Datasheet Management System

4.Database Management System

Question 9 of 14

Question 10 of 14

10. Query design window has two parts. The upper part shows

1.Name of fields, field type and size

2.Sorting check boxes

3.Tables with fields and relationships between tables

4.Criteria

Question 10 of 14

Question 11 of 14

11. A _________ enables you to view data from a table based on a specific criterion.

1.Query

2.Macro

3.Report

4.Form

Question 11 of 14

Question 12 of 14

12. To create queries in Access

1.You can type the SQL command in SQL view

2.You can drag and drop fields on query builders

3.You can use query wizard or design view

4.All of above

Question 12 of 14

Question 13 of 14

13. Queries in Access can be used as

1.A source of records for forms and reports

2.View, change and analyze data in different ways

3.Only a

4.Both a and b

Question 13 of 14

Question 14 of 14

14. Queries are based on this, allowing you to use a query as the source for forms and reports:

1.Records

2.Filters

3.Fields

4.Tables

Question 14 of 14

 Loading...

 

Other Related test

• Punjab 12th Class Physics Chapter 5 A.C. Circuit Mcqs Test Online
• Punjab 12th Class Chemistry Chapter 8 Aliphatic Hydrocarbons Mcqs Test Online
• Punjab 9th Class Chemistry Chapter 1 Fundamentals of Chemistry Mcqs Test Online
• Punjab 12th Class Urdu Shuhrat-e-Aam Aur Baqa-e-Dawam Ka Darbar Mcqs Test Online
• Punjab 10th Class Math Chapter 7 Introduction to Trigonometry Mcqs Test Online
• Punjab 11th Class Computer Science Chapter 3 Central Processing Unit Mcqs Test Online
• Punjab 9th Class Computer Science Chapter 6 Computer Security and Ethics Mcqs Test Online
• Punjab 9th Class Pak Study Chapter 2 Making of Pakistan Mcqs Test Online
• Punjab 9th Class Urdu Chapter 10 Mulki Parinday aur Doosray Janwar Mcqs Test Online
• Punjab 10th Class Computer Science Chapter 3 Input and Output Handling Mcqs Test Online