Home/Tests/Test/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

Please wait...

Question 1 of 14

Computer Science

1. Which of the following is not one of the methods available in the New Query dialog box to create queries?

1.Design View

2.Simple Query Wizard

3.Datasheet view

4.Cross tab Query Wizard

Question 1 of 14

Question 2 of 14

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

1.Filters

2.Records

3.Fields

4.Tables

Question 2 of 14

Question 3 of 14

3. This query wizard will create a select query

1.Simple

2.Find Duplicates

3.Cross tab

4.Design View

Question 3 of 14

Question 4 of 14

4. The result of a query is displayed in a

1.Form

2.Record

3.Query table

4.Query datasheet

Question 4 of 14

Question 5 of 14

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

1.None of these

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

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

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

Question 5 of 14

Question 6 of 14

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

1.Tables with fields and relationships between tables

2.Name of fields, field type and size

3.Sorting check boxes

4.Criteria

Question 6 of 14

Question 7 of 14

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

1.Query

2.Report

3.Form

4.Macro

Question 7 of 14

Question 8 of 14

8. DBMS stands for

1.Database Model System

2.Datasheet Management System

3.None of these

4.Database Management System

Question 8 of 14

Question 9 of 14

9. Which of the following statement is true?

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

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

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

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

Question 9 of 14

Question 10 of 14

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

1.Formulated field

2.Formula field

3.Numeric field

4.Calculated field

Question 10 of 14

Question 11 of 14

11. To create queries in Access

1.You can type the SQL command in SQL view

2.All of above

3.You can drag and drop fields on query builders

4.You can use query wizard or design view

Question 11 of 14

Question 12 of 14

12. Queries in Access can be used as

1.Only a

2.Both a and b

3.A source of records for forms and reports

4.View, change and analyze data in different ways

Question 12 of 14

Question 13 of 14

13. What is the full form of SQL?

1.Structured Question List

2.Sophisticated Question List

3.Small Query Length

4.Structured Query Language

Question 13 of 14

Question 14 of 14

14. 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.Select query

4.Update query

Question 14 of 14

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.

Other Related Tests

Punjab 11th Class Chemistry State of Matter (S...
Punjab 11th Class English It’s Country F...
Punjab 11th Class Biology Immunity Mcqs Test O...
Punjab 10th Class Physics Chapter 1 Simple Har...
Punjab 9th class Urdu Ghazal Hasti Apni Habab ...
Punjab 9th Class Physics Chapter 7 Properties ...
Punjab 10th Class Computer Science Chapter 3 I...
Punjab 10th Class Islamic Studies Chapter 2 Sa...
Punjab 10th Class English Chapter 3 Try Again ...
Punjab 9th Class Urdu Chapter 1 Hijrat e Nabwi...

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

Test Name

Subject

Test Type

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