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

Please wait...

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

 

Question 1 of 14

Computer Science

1. 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 is to be used or not

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

Question 1 of 14

Question 2 of 14

2. What is the full form of SQL?

1.Small Query Length

2.Sophisticated Question List

3.Structured Query Language

4.Structured Question List

Question 2 of 14

Question 3 of 14

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

1.Macro

2.Report

3.Query

4.Form

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.Formulated field

2.Calculated field

3.Numeric field

4.Formula field

Question 4 of 14

Question 5 of 14

5. 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 5 of 14

Question 6 of 14

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

1.Filters

2.Tables

3.Records

4.Fields

Question 6 of 14

Question 7 of 14

7. Queries in Access can be used as

1.Both a and b

2.A source of records for forms and reports

3.Only a

4.View, change and analyze data in different ways

Question 7 of 14

Question 8 of 14

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

1.Tables with fields and relationships between tables

2.Sorting check boxes

3.Name of fields, field type and size

4.Criteria

Question 8 of 14

Question 9 of 14

9. To create queries in Access

1.You can use query wizard or design view

2.All of above

3.You can type the SQL command in SQL view

4.You can drag and drop fields on query builders

Question 9 of 14

Question 10 of 14

10. DBMS stands for

1.Database Model System

2.Database Management System

3.Datasheet Management System

4.None of these

Question 10 of 14

Question 11 of 14

11. Which of the following statement is true?

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

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

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

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

Question 11 of 14

Question 12 of 14

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

4.Update query

Question 12 of 14

Question 13 of 14

13. This query wizard will create a select query

1.Design View

2.Simple

3.Find Duplicates

4.Cross tab

Question 13 of 14

Question 14 of 14

14. The result of a query is displayed in a

1.Query table

2.Form

3.Query datasheet

4.Record

Question 14 of 14

 Loading...

 

Other Related test

• Punjab 12th Class Chemistry Chapter 12 Aldehydes and Ketones Mcqs Test Online
• Punjab 9th Class English Chapter 1 The Saviour of Mankind Mcqs Test Online
• Punjab 10th Class Biology Chapter 3 Coordination and Control Mcqs Test Online
• Punjab 9th Class Chemistry Chapter 6 Solutions Mcqs Test Online
• Punjab 12th Class English The Man who was a hospital Chapter 6 MCQs Test Online
• Punjab 10th Class Math Chapter 8 Projection of Sides of a Triangle MCQs Test Online
• Punjab 10th Class Biology Chapter 2 Homeostasis Mcqs Test Online
• Punjab 9th Class English Model Paper 5 MCQs Test Online
• Punjab 9th Class Math Chapter 1 Matrices and Determinants Mcqs Test Online
• Punjab 12th Class Biology Chapter 25 Ecosystem MCQs Test Online