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. This query wizard will create a select query

1.Find Duplicates

2.Simple

3.Design View

4.Cross tab

Question 1 of 14

Question 2 of 14

2. 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.None of these

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 2 of 14

Question 3 of 14

3. Queries in Access can be used as

1.Both a and b

2.Only a

3.View, change and analyze data in different ways

4.A source of records for forms and reports

Question 3 of 14

Question 4 of 14

4. Which of the following statement is true?

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

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

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

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

Question 4 of 14

Question 5 of 14

5. To create queries in Access

1.All of above

2.You can use query wizard or design view

3.You can type the SQL command in SQL view

4.You can drag and drop fields on query builders

Question 5 of 14

Question 6 of 14

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

1.Cross tab Query Wizard

2.Datasheet view

3.Design View

4.Simple Query Wizard

Question 6 of 14

Question 7 of 14

7. DBMS stands for

1.Database Management System

2.Datasheet Management System

3.Database Model System

4.None of these

Question 7 of 14

Question 8 of 14

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

1.Update query

2.Search query

3.Cross tab query

4.Select query

Question 8 of 14

Question 9 of 14

9. What is the full form of SQL?

1.Structured Question List

2.Small Query Length

3.Structured Query Language

4.Sophisticated Question List

Question 9 of 14

Question 10 of 14

10. The result of a query is displayed in a

1.Query table

2.Query datasheet

3.Form

4.Record

Question 10 of 14

Question 11 of 14

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

1.Records

2.Tables

3.Filters

4.Fields

Question 11 of 14

Question 12 of 14

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

1.Macro

2.Report

3.Form

4.Query

Question 12 of 14

Question 13 of 14

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

1.Criteria

2.Name of fields, field type and size

3.Tables with fields and relationships between tables

4.Sorting check boxes

Question 13 of 14

Question 14 of 14

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

1.Calculated field

2.Numeric field

3.Formula field

4.Formulated field

Question 14 of 14

 Loading...

 

Other Related test

• Punjab 11th Class Islamiat Chapter 2 Islami Tashakhus Mcqs Test Online
• Punjab 11th Class Physics Chapter 1 Measurements Mcqs Test Online
• Punjab 10th Class Math Chapter 11 Chords and Arcs MCQs Test Online
• Punjab 9th Class Physics Chapter 5 Gravitation Mcqs Test Online
• Punjab 12th Class English Hitch Hiking across the Sahara Chapter 12 MCQs Test Online
• Punjab 10th Class Urdu Chapter 1 Hamd Mcqs Test Online
• Punjab 10th Class Urdu Chapter 10 Naam Dev Maali Mcqs Test Online
• Punjab 9th Class Urdu Model Paper 5 Mcqs Test Online
• Punjab 12th Class Pak Study Chapter 10 Foreign Policy of the Islamic Republic of Pakistan Mcqs Test Online
• Punjab 9th Class Math Chapter 7 Linear Equations & Inequalities Mcqs Test Online