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

Question:
 A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

1. format row

2.criteria row

3.aggregate function

4.format layout

Posted Date:-2021-02-19 15:14:11


Question:
 Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.

1.queries

2.fields

3.records

4.tables

Posted Date:-2021-02-19 15:14:11


Question:
 The Search tool is best used when searching for ______ data.

1.simple

2.multiple

3.unique

4.formatted

Posted Date:-2021-02-19 15:14:11


Question:
 The ______ is a wild card that represents one or more characters.

1.question mark

2.asterisk

3. exclamation mark

4.dollar sign

Posted Date:-2021-02-19 15:14:11


Question:
 To apply an AutoFormat to an entire Form, what must you select first?

1.Form Selector

2. Document tab

3.Detail section

4.Any control

Posted Date:-2021-02-19 15:14:11


Question:
 What happens when a user selects a record in a form and presses Delete?

1.The record is deleted in the form and from its source table.

2. The record is deleted in the form, but not from its source table.

3.The record is neither deleted in the form, nor from its source table.

4.The record is not deleted in the form, but is deleted from its source table.

Posted Date:-2021-02-19 15:14:11


Question:
 When increasing the Control Padding, space is added where?

1. Between the content of the controls and the outside edge of then controls

2.Between all controls

3.Between the control and the Form’s edge

4. Between controls and gridlines

Posted Date:-2021-02-19 15:14:11


Question:
 Which Form tool creates a new form that show both a form and datasheet views?

1.Form

2. Form Wizard

3.Multiple Item Form

4.Split Form

Posted Date:-2021-02-19 15:14:11


Question:
 Which is NOT a method of creating a table?

1.Datasheet View

2.Design View

3.Layout View

4.Template

Posted Date:-2021-02-19 15:14:11


Question:
 Which of the following database objects can have more than one Group Header/Footer section?

1.Forms

2.Queries

3.Reports

4.Tables

Posted Date:-2021-02-19 15:14:11


Question:
 Which of the following properties identifies the type of information stored in a field?

1.Data type

2.Field description

3.Field name

4.Field properties

Posted Date:-2021-02-19 15:14:11


Question:
 Which of the following statements about the Label Wizard is NOT true?

1.Adding groups can help organize the labels.

2. It helps users to create package labels.

3.It allows users to select a label type and size.

4.It allows users to sort the labels.

Posted Date:-2021-02-19 15:14:11


Question:
 Which of the following views displays the field name, description, and properties of a table?

1.Datasheet View

2.Design View

3.Layout View

4.Table View

Posted Date:-2021-02-19 15:14:11


Question:
 ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

1.Design View

2.Layout View

3.Print Preview

4. Report View

Posted Date:-2021-02-19 15:14:11


Question:
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

1.1

2.?

3.r

4.None

Posted Date:-2021-02-19 15:14:11


Question:
A relationship is created between how many tables?

1.One

2.Two

3.Three

4. Any number

Posted Date:-2021-02-19 15:14:11


Question:
A ____ is a major database object used to display information in a printable page format.

1.form

2.query

3.report

4.table

Posted Date:-2021-02-19 15:14:11


Question:
A ____ is a major database object used to display information in an attractive, easy-to-read screen format.

1.form

2.query

3.report

4.table

Posted Date:-2021-02-19 15:14:11


Question:
A ____ often display summary data such as totals or counts.

1. Group Header

2.Group Footer

3.Report Header

4. Page Footer

Posted Date:-2021-02-19 15:14:11


Question:
Access file operations can be found by clicking the ____.

1. Access Button

2.Database Button

3.Office Button

4.Window Button

Posted Date:-2021-02-19 15:14:11


Question:
Any report, including a basic report, can be modified in __.

1.Print Preview

2.Report View

3.Form View

4.Layout View

Posted Date:-2021-02-19 15:14:11


Question:
Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.

1. Design View

2.Datasheet View

3.Office View

4. Print Preview

Posted Date:-2021-02-19 15:14:11


Question:
Database properties do NOT include ___________. 

1.title

2.author

3.company

4.size

Posted Date:-2021-02-19 15:14:11


Question:
In a query, using the keyword _______________ will return records in which the field value is between two numbers.

1.Between

2. Is Null

3.Like

4.Not

Posted Date:-2021-02-19 15:14:11


Question:
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.

1.formula

2.format

3.layout

4.record

Posted Date:-2021-02-19 15:14:11


Question:
In Datasheet View, new records are added to a table ____.

1.in alphabetical order

2. at the end of the table

3.at the beginning of the table

4.in numerical order

Posted Date:-2021-02-19 15:14:11


Question:
In Datasheet View, what appears at the top of each column?

1.Data type

2.Description

3.Field name

4.Primary key

Posted Date:-2021-02-19 15:14:11


Question:
In the Field List of a table, the primary key appears _______________.

1.bold

2.italicized

3.underlined

4.with key icon

Posted Date:-2021-02-19 15:14:11


Question:
In the Relationship window, related fields from each table are connected by a(n) _______________.

1.default field

2. linking tables

3.index

4.join line

Posted Date:-2021-02-19 15:14:11


Question:
Print options can be changed in the Print ____.

1.tab

2.layout mode

3. setup routine

4.dialog box

Posted Date:-2021-02-19 15:14:11


Question:
Referential integrity cannot be set for _______________ relationships.

1.One-To-One

2.Indeterminate

3.One-To-Many

4.Many-To-Many

Posted Date:-2021-02-19 15:14:11


Question:
Relationships between tables can be graphically viewed in the _______________ window.

1.Design

2.Joins

3.Relationships

4.Tables

Posted Date:-2021-02-19 15:14:11


Question:
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

1.primary, foreign

2.primary, common

3.foreign, primary

4.foreign, common

Posted Date:-2021-02-19 15:14:11


Question:
The content and application of the Search tool CANNOT be retained when you ______.

1.format an object

2.resize a column

3.use Datasheet View

4.close an object

Posted Date:-2021-02-19 15:14:11


Question:
The Input Mask wizard does NOT include the ability to do which of the following?

1.Force all uppercase

2.Define placeholder

3.Store symbols with data

4.Use preset masks

Posted Date:-2021-02-19 15:14:11


Question:
The insertion point looks like a(n) ____.

1. H-pointer

2. I-pointer

3.H-beam

4.I-beam

Posted Date:-2021-02-19 15:14:11


Question:
The Search tool CANNOT be used on which major Access object?

1.Forms

2.Queries

3.Reports

4.Tables

Posted Date:-2021-02-19 15:14:11


Question:
The Table _______________ Wizard analyzes a database and recommends changes for normalization.

1.Analyzer

2.Documenter

3.Cleanup

4.Normalization

Posted Date:-2021-02-19 15:14:11


Question:
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?

1.Datasheet

2.Justified

3.Stacked

4.Tabular

Posted Date:-2021-02-19 15:14:11


Question:
To remove all Sorts in a table you can click the ______ command.

1. Clear All Sorts

2.Delete All Sorts

3.Eliminate All Sorts

4.Remove All Sorts

Posted Date:-2021-02-19 15:14:11


Question:
Using the keyword _______________ will return records in which the field value equals a defined text.

1.Between

2. Is Null

3.Like

4.Not

Posted Date:-2021-02-19 15:14:11


Question:
What is one of the advantages for using a form over other Access objects?

1.Utilizes field placement to improve the efficiency of data entry.

2.Forms store information more efficiently.

3.Forms show the summary of all the records.

4.Forms cannot be edited.

Posted Date:-2021-02-19 15:14:11


Question:
What is the keyboard shortcut to move to the last records in a table?

1.Tab

2.Shift+Tab

3.Ctrl+Home

4. [Ctrl]+[End]

Posted Date:-2021-02-19 15:14:11


Question:
What is the process of eliminating redundant fields by separating data into tables called?

1.Renormalizations

2.Filtering

3.Normalization

4.Sorting

Posted Date:-2021-02-19 15:14:11


Question:
What type of controls are text boxes when data from the recordset is visible?

1.Align

2.Bound

3.Calculated

4.Unbound

Posted Date:-2021-02-19 15:14:11


Question:
What type of relationship is created when you select a primary key in both related tables?

1.One-To-One

2.Indeterminate

3.One-To-Many

4. Many-To-Many

Posted Date:-2021-02-19 15:14:11


Question:
Which is not an option for Filter on a text field?

1.Begins With

2.Between

3.Contains

4. End With

Posted Date:-2021-02-19 15:14:11


Question:
Which is NOT an option of the Picture Size Mode property?

1.Clip

2.Fit

3.Stretch

4.Zoom

Posted Date:-2021-02-19 15:14:11


Question:
Which major database object stores all data?

1.Field

2.Query

3.Record

4.Table

Posted Date:-2021-02-19 15:14:11


Question:
Which mode sizes an image to fit the control while maintaining the proportions of the original image?

1.Clip

2.Fit

3.Stretch

4.Zoom

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following can a Report Wizard NOT do?

1.Add summary functions

2.Create groups

3.Group fields into more than one Control Layout

4. Select fields

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following CANNOT be done to data using a Form?

1.Store

2.Sort

3.Edit

4.Print

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following data types automatically generates a consecutive number?

1.Autonumber

2.Memo

3.Number

4.Text

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following database objects extracts information from one or more tables or queries? 

1.Forms

2.Queries

3.Reports

4.Tables

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following field properties displays a model or pattern for entering data?

1.Field Size

2.Format

3.Input Mask

4.Validation Rule

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following field properties enforces the use of parentheses when keying an area code?

1. Field Size

2.Format

3.Input Mask

4.Validation Rule

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following field properties is an expression that specifies criteria or requirements for entering data?

1.Field Size

2.Format

3. Input Mask

4.Validation Rule

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?

1.Match Case

2.Match: Whole Field

3.Match: Start of Field

4.Match: Any Part of Field

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following functions CANNOT be used in the Totals row?

1.Average

2.Count

3.Maximum

4.Round

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following is NOT possible when printing Forms?

1.Print page 1, 3, and 5

2.Print pages 1 through 5

3. Print selected records

4.Print only the third record

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following search criteria is invalid?

1.$45*

2.*cal*

3.D*m??

4.AS150*

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following statements about calculated fields is NOT true?

1.A calculated field does not store data in a recordset.

2.Calculated fields use an expression or formula as its data source.

3.Data contained in a calculated field is created the first time a query is run.

4.A calculated field can be created using the Expression Builder dialog box.

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following statements about criteria in a query is NOT true?

1.Criteria can contain wildcard characters.

2. Criteria in a query selects or excludes certain records.

3.Criteria cannot be specified as an expression.

4.Multiple criteria can be specified using AND, OR, and relational operators.

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following statements about PivotChart View is NOT true?

1. It is used to graphically summarize and analyze data in a table, query, or form.

2.It can be used to view different levels of detail or to specify custom layout.

3. It displays field values that can be switched for different views of data.

4.. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following statements about tab order setting is NOT true?

1.The actual tab order setting for a form can be used in the Form View.

2.The tab order setting determines the movement of the insertion point through a form.

3.The tab order setting is usually right-to-left and top-to-bottom.

4. The default tab order setting can be altered by moving the controls in the Design View.

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following statements does NOT hold true for the Top Values property?

1.The Top Values property displays only the highest values from the query.

2.The Top Values property requires the fields to have a defined sort order.

3.The Top Values property finds a specified number of records.

4.The Top Values property finds a specified percentage of records.

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following views enables users to create and modify the sections of a form?

1.Datasheet

2.Design

3.Form

4.Layout

Posted Date:-2021-02-19 15:14:11


Question:
Which of the following views is used to graphically summarize and analyze data in a recordset?

1.Datasheet

2.Form

3.PivotChart

4.PivotTable

Posted Date:-2021-02-19 15:14:11


Question:
Which report section only prints one time at the end of the report?

1.Report Header

2.Page Header

3.Report Footer

4. Page Footer

Posted Date:-2021-02-19 15:14:11


Question:
Which report section prints once at the bottom of every printed page?

1.Detail

2.Page Header

3.Page Footer

4.Report Header

Posted Date:-2021-02-19 15:14:11


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!