Computer/Query of MS Access MCQS Part 1 Sample Test,Sample questions

Question:
 In the form wizard dialog box the fields from the selected table are displayed in this list box.

1.All fields

2.All records

3.Available records

4.Available fields


Question:
 In the form wizard dialog box the fields from the selected table are displayed in this list box.

1.All fields

2.All records

3.Available records

4.Available fields


Question:
 It is a query that when run displays its own dialog box prompting you for information such as

1.Select

2.Crosstab

3.Parameter

4.Append


Question:
 Saving a database in access is done

1. At the beginning of the database

2.The first time you save data

3.When closing the application

4.During auto save


Question:
 This is not one of the sections of the form design window

1.Form footer

2. Form content

3.Form header

4.Form detail


Question:
 To set a password for the database select ____________ in the Microsoft Access open window.

1. Open read only

2. Open write only

3.Open explicit

4.Open exclusive


Question:
 Which of the following database object is created first before any other created?

1.Table

2.Form

3.Report

4.Query


Question:
 Which of the following is not one of the methods available in the new query dialog box to create queries?

1.Design view

2. Crosstab query wizard

3.Simple query wizard

4.Datasheet view


Question:
A collection of related records in database is known as a

1.Table

2.Database

3.File

4. None of above


Question:
A part of database that stores complete information about an entity such as employee sales orders etc.

1.File

2.Record

3.Field

4.Query


Question:
A query that uses information from two or more tables to get the results is called a(n)

1.Informal query.

2.Optional query.

3.Complex query.

4.Multitable query.


Question:
A(n) _____ is an association that is created in a query between a field in one table or query and a field of the same data type in another table or query.

1.Join

2.Link

3.Connector

4.Identifier


Question:
Changing the order of this in the query datasheet does not affect the field order in the table.

1.Record

2.Row

3.Column

4.Sort


Question:
Database access levels are specified so as to define who can access what in a database. It is identified through

1.User id

2.Password

3.Status

4. None of above


Question:
If you make an invalid entry in the input mask wizard dialog box this will display to advise you that the entry is not correct

1.Text error

2.Validation error

3. Literal error

4.Entry error


Question:
If you write “Like Su*” in criteria cell of FirstName field it will display

1.All the names that are like Su such as Bunu Kunal Purna

2.All the names that begin with Su such as Suresh Sunita Sumit

3.Blank recordset

4.Error message


Question:
In a query when you have multiple conditions and each of them must satisfy to return the result use

1.AND

2.OR

3.NOT

4.XOR


Question:
In access this displays the results of a calculation in a query

1.Lookup field

2. Calculated field

3. Source field

4.Child field


Question:
In access this operation copies a backup file from the storage medium back onto the computer 

1.Recreate

2.Restore

3.Copy

4.Structure


Question:
In access this view is used to create and modify the structure of a form.

1.Normal

2.Datasheet

3. Form design

4.Control


Question:
In MS Access query which of the fields is derived field? Query: SELECT product.qty AS Quantity product.rate AS Rate product.qty*product.rate AS Amount FROM product

1. Quantity

2.Rate

3.Amount

4.Product


Question:
In the second subform wizard dialog box you specify the table to use as the data source and the. 

1.Records from the selected form

2.Form from the selected table

3. Fields from the selected table

4.Content from the selected form


Question:
In this form a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

1.Datasheet

2.Tabular

3.Justified

4.Columnar


Question:
It is a sign or symbol that specifies operator and values that produce a result

1.Operator

2.Query

3.Expression

4.None of the above


Question:
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum

1.Parameter

2.Select

3.Crosstab

4.Append


Question:
 Which statement does not hold true?

1.A relationship establishes the association between common fields in two tables.

2.An AutoNumber field can be related to a field of either type AutoNumber or type Text.

3.Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.

4.Access will automatically create a join only if the field names in both tables are the same.


Question:
Microsoft Access uses Jet Query Engine which uses

1.MS SQL Server

2.Full fledged SQL

3.Dialect of SQL

4.None of above


Question:
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:
Some rules are set in databases to check and permit only correct values. What is this feature called?

1.Data verification

2.Auditing

3.Data filtering

4. Data validation


Question:
The ascending order of data hierarchy is?

1.Bit – byte – field – record – file – databse

2.Bit – byte – record – field – file – database

3.Byte – bit – field – record – file – database

4.Bit – byte – field – record – database – file


Question:
The ‘filter by selection’ allows you to filter those records

1.That match the selected field

2.That match the criteria specified

3.That meet any of several criteria specified

4. All of above


Question:
The operation of checking input data against specified criteria is known as?

1.Data verification

2. Data validation

3.Cross check

4.Data control


Question:
The quickest way to add a field to the selected fields list is to double-click its field name in this list.

1.Find fields

2.Search fields

3. Search record

4.Available fields


Question:
The result of a query is displayed in a

1.Record

2. Query datasheet

3.Query table

4.Forms


Question:
This form displays multiple records one per row in the form window

1.Datasheet

2.Tabular

3.Columnar

4.Justified


Question:
This form displays the field name labels down the left side of the column with the data for each field just to the right of its corresponding label.

1.Tabular

2.Justified

3.Columnar

4.Datasheet


Question:
This query wizard will create a select query.

1.Crosstab

2.Find duplicates

3.Simple

4.Design view


Question:
This type of database contains multiple tables that are connected to produce combined output from all tables.

1.Bound

2.Linked

3.Relational

4.Joined


Question:
This type of query summarizes large amounts of data in easy-to-read row-and-column format.

1.Crosstab

2.Columnar

3.Select

4.Action


Question:
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. Numeric field

3. Formula field

4.Calculated field


Question:
To enter the input mask wizard

1.Click on the three dots to the right of the caption entry field

2.Click on the three dots to the right of the format entry field

3.Click on the input mask toolbar

4.Click on the three dots to the right of the input mask entry field


Question:
What it is called to present information in a particular order based on numeric or alphabetical value?

1.Sorting

2.Searching

3. Arranging

4.Cropping


Question:
When you need to restrict the records that meets certain conditions you can mention them in

1.Filter cell

2.Sort cell

3.Show cell

4.Criteria cell


Question:
When you select this control its associated text control is also selected and the two controls will act as one when manipulated.

1.Text

2.Form

3.Label

4.Field


Question:
Which of the following database object can be used if you need to mail the invoice to customers?

1. A form

2.A query

3.A report

4.A table


Question:
Which of the following is not a form style available in the form wizard dialog box. 

1.Blends

2.Standard

3.Stone

4.Highlights


Question:
Which of the following SQL query deletes Product table from Store database?

1.DEL Product FROM Store

2.DROP Product

3. DROP TABLE Product

4.Any of b or c


Question:
You can enclose the prompt within square braces in criteria to create

1.Parameter query

2. Select query

3.Action query

4.Crosstab query


Question:
You can move between fields in a form by using any of these keys except

1.Tab

2.Enter

3.Shift+tab

4.Page up


More MCQS

  1. Computer fundamentals
  2. Computer Basic MCQS
  3. CCC MCQ Sample Paper 1
  4. CCC Exams MCQS Sample Paper Test 2
  5. Computer Basics MCQS Paper 1
  6. Computer Basics MCQS Paper 2
  7. FUNDAMENTALS OF COMPUTERS MCQs PART 2
  8. FUNDAMENTALS OF COMPUTERS MCQs PART 1
  9. FUNDAMENTALS OF COMPUTERS MCQs PART 3
  10. Computer mcqs smaple paper 1
  11. Computer mcqs smaple paper 2
  12. Computer mcqs smaple paper 3
  13. Fundamentals of Computers
  14. Fundamentals of Computers (New) Part 1
  15. Fundamentals of Computers (New) Part 2
  16. Computer Networks MCQ Questions
  17. Computer Networks Transition from IPV4 to IPV6
  18. Computer Fundamentals (New) Part 1
  19. Computer Fundamentals (New) Part 2
  20. Computer Fundamentals (New) Part 3
  21. Computer Fundamentals (New) Part 4
  22. Computer Fundamentals (New) Part 5
  23. Computer Fundamentals (New) Part 6
  24. Computer Fundamentals (New) Part 7
  25. Computer Fundamentals (New) Part 8
  26. Operating Systems MCQs Part 1
  27. Operating Systems MCQs Part 2
  28. OS(Computer Operating Systems) Part 1
  29. OS(Computer Operating Systems) Part 2
  30. OS(Computer Operating Systems) Part 3
  31. OS(Computer Operating Systems) Part 4
  32. OS - Computer Operating Systems Part 5
  33. OS - Computer Operating Systems Part 6
  34. OS - Computer Operating Systems Part 7
  35. MS Word MCQ Questions Part 1
  36. MS Word MCQ Questions Part 2
  37. MS Word MCQ Questions Part 3
  38. MS Word MCQ Questions Part 4
  39. MS Word MCQ Questions Part 5
  40. MS Word MCQ Questions Part 7
  41. MS Word MCQ Questions Part 6
  42. Microsoft Excel MCQ Questions Part 1
  43. Microsoft Excel MCQ Questions Part 2
  44. Microsoft Excel MCQ Questions Part 3
  45. Microsoft Excel MCQ Questions Part 4
  46. Microsoft Excel MCQ Questions Part 5
  47. Microsoft Excel MCQ Questions Part 6
  48. Microsoft Excel MCQ Questions Part 7
  49. MS PowerPoint MCQ Questions PART 1
  50. MS PowerPoint MCQ Questions PART 2
  51. MS PowerPoint MCQ Questions PART 3
  52. MS PowerPoint MCQ Questions PART 4
  53. MS PowerPoint MCQ Questions PART 5
  54. MS PowerPoint MCQ Questions PART 6
  55. MS PowerPoint MCQ Questions PART 7
  56. MS Access MCQ Questions Part 1
  57. MS Access MCQ Questions Part 2
  58. MS Access MCQ Questions Part 3
  59. MS Access MCQ Questions Part 4
  60. MS Access MCQ Questions Part 5
  61. MS Access MCQ Questions Part 6
  62. MS Access MCQ Questions Part 7
  63. MS Access MCQ Questions Part 8
  64. Query of MS Access MCQS Part 1
  65. Query of MS Access MCQS Part 2
  66. Computer Communication and Networking Quiz
  67. Computer Graphics MCQ Quiz Questions and Answers
  68. Computer Basics Quiz Questions
  69. Computer Quiz Questions with Answers
  70. Computer Hardware MCQS Quiz
  71. MCQ Computer Organization & Architecture
  72. MCQ Computer Organisation - Input & output Organisation SET1
  73. MCQ Computer Organisation - Input & output Organisation SET2
  74. MCQ Computer Organisation - Input & output Organisation SET3
  75. MCQS on addressing modes SET 1
  76. MCQS on addressing modes SET 2
  77. Software Engineering MCQs SET 1
  78. Software Engineering MCQs SET 2
  79. Software Engineering MCQs Set 3
  80. Software Engineering MCQs Set 4
  81. Software Engineering MCQs Set 5
  82. Software Engineering MCQs Set 6
  83. Software Engineering MCQs Set 7
  84. mcqs data structures
  85. CCC Exam Sample MCQ Paper
  86. Computer MCQ Questions set-1
  87. Computer MCQ Questions set-2
  88. Computer MCQ Questions set-3
  89. Current affairs mcq Database management
  90. Programming arcitecture
  91. Computer Graphics MCQ Questions part 1
  92. Computer Graphics MCQ Questions part 2
  93. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 1
  94. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 2
  95. Computer Science MCQs
  96. Computer Mcq Question
  97. MCQs based on Fundamentals of Computer 1 set
  98. Computer Mcq Question set 2
  99. MCQ Encoding Schemes
  100. Data Entry and Keyboarding Skills MCQ
  101. Computer Science Number System
  102. Computer Network MCQ
  103. MCQ Questions on Tally
  104. MCQ Questions on Tally Set 2
  105. MCQ Questions on Tally Set 3
  106. MCQ Questions on Tally Set 4
  107. Internet Technology MCQ Questions for Competitive Exams
  108. Computer Software MCQ GK Questions
  109. Computer Organization and Architecture MCQs
  110. Basic Computer GK Questions
  111. Computer Graphics MCQ Set 1
  112. Operating System MCQ Set 1
  113. Operating System MCQ Set 2
  114. Operating System MCQ Set 3
  115. Operating System MCQ Set 4
  116. Operating System MCQ Set 5
  117. Operating System MCQ Set 6
  118. Operating System MCQ Set 7
  119. Operating System MCQ Set 8
  120. Operating System MCQ Set 9
  121. Operating System MCQ Set 10
  122. Operating System MCQ Set 11
  123. Operating System MCQ Set 12
  124. Operating System MCQ Set 13
  125. Operating System MCQ Set 14
  126. Operating System MCQ Set 15
  127. Operating System MCQ Set 16
  128. Operating System MCQ Set 17
  129. Operating System MCQ Set 18
  130. Operating System MCQ Set 19
  131. Operating System MCQ Set 20
  132. Operating System MCQ Set 21
  133. Computer Graphics MCQ Question Set 1
  134. Computer Networks MCQs
  135. Computer Networks MCQs Set-2
  136. Computer Networks MCQs Set-3
  137. Computer Networks MCQs Set-4
  138. Bachelor of Computer Applications MCQs set-1
  139. Bachelor of Computer Applications MCQs set-2
  140. NET Programming MCQ
  141. Artificial Intelligence and Robotics (AIR) Set 1
  142. Artificial Intelligence and Robotics (AIR) Set 2
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!