Computer/MS%20Access%20MCQ%20Questions%20Part%205 Sample Test,Sample questions

Question:
 A(n) _____ is a control that, when clicked, executes an action or series of actions.

1.combo box control

2.AutoFormat

3.Conditional Format

4.command button

Posted Date:-2021-02-19 15:10:43


Question:
 A(n) _____ is an image control that displays in the background of a page on a form or report.

1.legend

2.icon

3.logo

4.watermark

Posted Date:-2021-02-19 15:10:43


Question:
 A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.

1.HTML

2.XML

3.XSD

4.XSL

Posted Date:-2021-02-19 15:10:43


Question:
 A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.

1.select

2.summary

3.parameter

4.action

Posted Date:-2021-02-19 15:10:43


Question:
 According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?

1. cbo

2.cob

3.cmb

4.cbx

Posted Date:-2021-02-19 15:10:43


Question:
 HTML stands for ____.

1.High Text Mail List

2.Hyperlink Markup Language

3.HyperText Markup Language

4.Hyperlink Transfer Markup Language

Posted Date:-2021-02-19 15:10:43


Question:
 If you need a calculation in an unbound control, you can create a custom _____.

1.string

2.expression

3.relationship

4.syntax

Posted Date:-2021-02-19 15:10:43


Question:
 In Access 2007 to make changes in the Trust Center, you need to go to the ____.

1.Microsoft Office button

2.Navigation Pane

3.Quick Access toolbar

4. Database Tools command tab

Posted Date:-2021-02-19 15:10:43


Question:
 What does an inner join display?

1.Records from the second recordset and only records from the first recordset where the common fields are equal

2. Records from the first recordset and only records from the second recordset where the common fields are equal

3.Records that have the same value in the common field

4.Records from the first recordset only

Posted Date:-2021-02-19 15:10:43


Question:
 Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?

1.Edit Relationships

2.Indexes

3.Option

4. Show Table

Posted Date:-2021-02-19 15:10:43


Question:
 Which of the following functions is used to all the values in a numeric field?

1.Num

2.Count

3.Sum

4.Total

Posted Date:-2021-02-19 15:10:43


Question:
 Which of the following is the default join between two recordsets?

1.Inner join

2.Left outer join

3.Right outer join

4.Self join

Posted Date:-2021-02-19 15:10:43


Question:
 You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?

1.Detail

2.Form Footer

3.Form Header

4.Page Header

Posted Date:-2021-02-19 15:10:43


Question:
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency. 

1.standardized

2.fixed

3.delimited

4.text

Posted Date:-2021-02-19 15:10:43


Question:
A global join will be created automatically when using tables in a(n) _____.

1.form

2.report

3.query

4.field

Posted Date:-2021-02-19 15:10:43


Question:
A Smart Tag can be set using the _____ tab in the property sheet.

1.Format

2.Tag

3.View

4.Data

Posted Date:-2021-02-19 15:10:43


Question:
A summary query can be created by adding which row to the design grid of a select query? 

1.Arguments

2.Group

3.Summary

4.Total

Posted Date:-2021-02-19 15:10:43


Question:
A(n) _______________ query locates data from one or more tables.

1.select

2.summary

3.parameter

4.action

Posted Date:-2021-02-19 15:10:43


Question:
ccording to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?

1.txt

2.txb

3.tbc

4.tex

Posted Date:-2021-02-19 15:10:43


Question:
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.

1.standardized

2.fixed

3.delimited

4.shared

Posted Date:-2021-02-19 15:10:43


Question:
How can a user open the Expression Builder dialog box?

1.By clicking the drop-down arrow on the Control Source property

2.By clicking the drop-down arrow of the Input Mask property in the Data tab

3.By clicking the Build button of the Input Mask in the Data tab

4. By clicking the Build button of the Control Source property in the Data tab

Posted Date:-2021-02-19 15:10:43


Question:
If a color property contains “#336699”, how many blue units are in the color?

1.33

2.66

3.99

4.255

Posted Date:-2021-02-19 15:10:43


Question:
In a junction table, the _____ field consists of the foreign key from both the linked tables.

1.first defined

2.last defined

3.foreign key

4.primary key

Posted Date:-2021-02-19 15:10:43


Question:
In a query, what symbol is used to surround a parameter’s user prompt?

1.[ ]

2.{ }

3.” ”

4.( )

Posted Date:-2021-02-19 15:10:43


Question:
In a query, which row do you need to place wildcards to affect a parameter?

1.Arguments

2.Criteria

3.Fields

4.Tables

Posted Date:-2021-02-19 15:10:43


Question:
In a query’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

1.The join line but not the relationship between the two tables

2.The relationship between the two tables locally

3.The relationship between the two tables globally

4. The primary key of the first table

Posted Date:-2021-02-19 15:10:43


Question:
In Access 2007, to set a table to open as a document tab, you need to go to the ____.

1.Microsoft Office button

2. Navigation Pane

3.Quick Access toolbar

4. Database Tools command tab

Posted Date:-2021-02-19 15:10:43


Question:
The Allow _____ property controls whether new records can be added through the form.

1.Additions

2.Edits

3.Deletions

4.Data Entry

Posted Date:-2021-02-19 15:10:43


Question:
The page count of a report can be determined by clicking the _______ button.

1.First Page

2.Previous

3.Next

4. Last Page

Posted Date:-2021-02-19 15:10:43


Question:
The three parts of an IIF function are separated by _____.

1.dashes

2.asterisks

3.semicolons

4.commas

Posted Date:-2021-02-19 15:10:43


Question:
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.

1.Color

2.Expression

3.Palette

4.Property

Posted Date:-2021-02-19 15:10:43


Question:
The _____ function returns a string that has been converted to uppercase text.

1.AllCap

2.UCase

3.UpCase

4.Upper

Posted Date:-2021-02-19 15:10:43


Question:
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.

1.Date

2.Time

3.Calendar

4.Appointment

Posted Date:-2021-02-19 15:10:43


Question:
The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.

1.MSN Money

2.Portfolio

3.Financial

4.Stock

Posted Date:-2021-02-19 15:10:43


Question:
What is an index?

1.A wizard that creates a functional database structure based on the user’s selections

2.A widely recognized naming convention for database objects

3.A sort order for records, which is identified in the table design

4.A set of relationship rules that enforce defined database relationships

Posted Date:-2021-02-19 15:10:43


Question:
When adding an image, which size mode will change the height or width of the image fit the control?

1.Clip

2.Stretch

3.Zoom

4.Crop

Posted Date:-2021-02-19 15:10:43


Question:
When you add fields in ____, a Field List pane displays.

1. Design View

2. Layout View

3.Print Preview

4. Report View

Posted Date:-2021-02-19 15:10:43


Question:
Which colors are used to define a custom color?

1.Red, Blue, Yellow

2.Red, Green, Blue

3. Blue, Green, Orange

4.Green, Orange, Violet

Posted Date:-2021-02-19 15:10:43


Question:
Which function evaluates a “true/false” expression and then performs one of two actions?

1.Case

2.IF

3.IIF

4.IsTrue

Posted Date:-2021-02-19 15:10:43


Question:
Which function extracts the name of the month from a date/time value?

1.Month

2.MonthName

3.MonthLabel

4.MonthValue

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following is a standard file format language for web documents?

1.HTML

2.XML

3.XSD

4.XSL

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following is NOT true about background images?

1.They are similar to watermarks in Word.

2.They are displayed behind the controls in a form.

3. They do not print when a form or a report is printed.

4.They can be inserted on a form or a report.

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following is the file extension for an Extensible Markup Language?

1.EML

2.HTML

3.XML

4.XSD

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following queries can create a table?

1.Append

2.Delete

3.Make-Table

4.Update

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following queries modifies fields not records?

1.Append

2.Delete

3.Make-Table

4.Update

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following queries prompts users for input data by displaying dialog boxes?

1.Append

2.Delete

3.Parameter

4.Update

Posted Date:-2021-02-19 15:10:43


Question:
Which of the following types of joins displays records with the same value in the common field?

1.Inner join

2. Left outer join

3.Right outer join

4.Self join

Posted Date:-2021-02-19 15:10:43


Question:
Which part of the IIF expression is the action performed if the true condition exists?

1.inner

2.first

3.second

4.third

Posted Date:-2021-02-19 15:10:43


Question:
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?

1.7

2.17

3.60

4. Not enough information to tell

Posted Date:-2021-02-19 15:10:43


Question:
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

1.5

2.8

3.24

4.Not enough information to tell

Posted Date:-2021-02-19 15:10:43


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
  143. Computer Engineering Soft Computing Set 1
  144. Computer Engineering Soft Computing Set 2
  145. COMPUTERS AND IT MCQs QUESTIONS
  146. Ancient Indian History MCQ
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!