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.Datasheet view

2.Simple Query Wizard

3.Design View

4.Cross tab Query Wizard

Question 1 of 14

Question 2 of 14

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

Question 3 of 14

3. The result of a query is displayed in a

1.Query datasheet

2.Record

3.Form

4.Query table

Question 3 of 14

Question 4 of 14

4. To create queries in Access

1.All of above

2.You can type the SQL command in SQL view

3.You can use query wizard or design view

4.You can drag and drop fields on query builders

Question 4 of 14

Question 5 of 14

5. Queries in Access can be used as

1.Both a and b

2.View, change and analyze data in different ways

3.Only a

4.A source of records for forms and reports

Question 5 of 14

Question 6 of 14

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

1.Criteria

2.Sorting check boxes

3.Name of fields, field type and size

4.Tables with fields and relationships between tables

Question 6 of 14

Question 7 of 14

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

1.Update query

2.Select query

3.Search query

4.Cross tab query

Question 7 of 14

Question 8 of 14

8. This query wizard will create a select query

1.Simple

2.Find Duplicates

3.Cross tab

4.Design View

Question 8 of 14

Question 9 of 14

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

1.It indicates whether the field names 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 is to be displayed in query result or not

4.None of these

Question 9 of 14

Question 10 of 14

10. DBMS stands for

1.Database Model System

2.Database Management System

3.None of these

4.Datasheet Management System

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.Fields

2.Filters

3.Records

4.Tables

Question 11 of 14

Question 12 of 14

12. What is the full form of SQL?

1.Sophisticated Question List

2.Structured Question List

3.Structured Query Language

4.Small Query Length

Question 12 of 14

Question 13 of 14

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

Question 14 of 14

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

1.Query

2.Report

3.Macro

4.Form

Question 14 of 14

Can't find what you're looking for? Search below:

More Online Tests

Punjab 11th Class English Chapter 4 Thank You Ma’m Mcqs Tes...
Punjab 9th Class Computer Science Chapter 4 Data Communication Mc...
Punjab 9th Class English Model Paper 2 MCQs Test Online
Punjab 9th Class Physics Model Paper 5 MCQs Test Online
Punjab 12th Class Physics Chapter 2 Current Electricity Mcqs Test...
Punjab 12th Class Urdu Siah Faam Mcqs Test Online
Punjab 9th Class English Model Paper 6 MCQs Test Online
Punjab 12th Class Biology Chapter 22 Variation and Genetics MCQs ...

Prepare Subjective:

Read Short Questions

Test By Class

Punjab

Test By Subject

12th Class Computer