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

Question:
 a computer language for informing the dbms regarding the data structure used is

1.Pascal

2.Ddl

3.Prolog

4.Fortran


Question:
 a computer language for informing the dbms regarding the data structure used is

1.Pascal

2.Ddl

3.Prolog

4.Fortran


Question:
 A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

1.Tables

2.Relations

3.Tuple

4.Both a and b


Question:
 a subset of characters within a data field is known as

1.Record

2.File

3.Data string

4.Byte


Question:
 How can you add a table to the relationship window?

1.Select tools>add table from the menu

2.Select the table from the table list on the toolbar

3.Click the show table button on the toolbar

4.Select edit>add table from the menu


Question:
 If a piece of data is stored in two places in the database then a

1.Storage space is wasted

2.Changing the data is one spot will cause data inconsistency

3. It can be more easily accessed

4. Both a and b


Question:
 In relational database schema each tuple is divided into fields known as?

1.Relations

2.Queries

3.Records

4.Domains


Question:
 the complete picture of data stored in database is known as

1.Record

2.Scheme

3.System flowchart

4.Dbms


Question:
 What data type should yo choose for a zip code field in a table?

1.Text

2.Number

3.Memo

4.All of above


Question:
 What is the first step in creating a form or report with the form wizard or report wizard?

1.Selecting the fields that you want to appear in the form or report

2.Selecting the underlying table or query on which you want to base the form or report

3.Reading several screens of mostly useless information and clicking next

4.Selecting how the form or report should be formatted


Question:
 What is the memo data type field used for?

1.To add table

2.To store objects created in other programs

3.For long text entries

4.For shout text entries of no more than 255 characters


Question:
 What type of control in a form can display data from database table?

1.Bound control

2.Unbound control

3.Both of above

4.None of above


Question:
 Which of the following database objects asks a question of information in a database and then displays the result?

1.Tables

2.Reports

3.Queries

4.Forms


Question:
 which of the following is a database management system?

1. Ms-word

2.Lotus 1-2-3

3.Oracle

4.None of above


Question:
 which of the following is not a type of Microsoft Access database object?

1.Queries

2.Workbooks

3.Forms

4.Tables


Question:
 which of the following terms does not describe a database structure used by a dbms to link data from several files?

1.Relational

2.Structural

3.Network

4.All of above


Question:
 which program do you use to edit code for data access pages?

1. Microsoft script editor

2.Microsoft code editor

3.Microsoft data access pages editor

4.None of above


Question:
a file containing relatively permanent data is

1.Random file

2.Transaction file

3.Master file


Question:
A list consists of last names first names address and pin codes if all people in the list have the same last and the same pin code a useful key would be

1.The pin code

2.The last name

3.A compound key consisting of the first name and the last name

4.All of above


Question:
According to access help what’s a good way to design a database?

1.Start from data access pages and work backward

2.Sketch the design of your database using a pencil and paper

3.Use the table analyzer to reverse-engineer your flat source data.

4.None of the ablve


Question:
data items groped together for storage purposes are called a

1.Record

2.Title

3.List

4.String


Question:
How can you display the related records from other tables in datasheet view?

1.Click on the expand indicator next to the record

2.Double click on the record to expand it

3.Apply filter by command to display related records

4.All of above


Question:
how do you filter by selection?

1.Right click the field value and select filter by selection from the shortcut menu

2.Find and double click the value on which you want to base the filter

3.Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

4.None


Question:
how do you update pivot table report data after changes are made to the source data?

1.Save your changes close the workbook and then reopen it.

2.Select the pivot table worksheet and press f9 on the keyboard

3.Click the report and on the pivot table toolbar click the refresh data button

4.All of above


Question:
in a relational schema each tuple is divided into fields called

1.Relations

2.Domains

3.Queries

4.All of above


Question:
In access the best types of queries to use for data analysis are

1.Select queries

2.Parameter queries

3.Action queries

4.All of above


Question:
In order to use dbms it is important to understand

1.The physical schema

2.All sub schemas that the sytem supports

3.One sub schema

4.Both a and b


Question:
 The file extension for an access 2003 database is

1.Exe

2.Doc

3.Exc

4.Mdb


Question:
The arranging of data in a logical sequence is called

1.Sorting

2.Classifying

3.Reproducing

4.Summarizing


Question:
the executive responsible for the data processing function in an organization is

1.Pm

2.Dbms

3.Dp

4.Dpm


Question:
The filter by selection feature allows you to filter

1.Those records that match an entity in a field

2. Records based on a criterion you specify

3.Records that meet any of several criteria you specify

4.All of above


Question:
the way a particular application views the data from the database that the applicaton uses is a

1.Module

2.Relational model

3.Schema

4.Sub-schema


Question:
To display value from table for a label control

1. Set teh control source and record source prom property panel

2.Choose the databse table field and select data value to display

3. Look at the table and type value in the caption

4.Set the record source property and then control source


Question:
what are the columns in a Microsoft Access table called?

1.Rows

2.Fields

3.Cell

4.Records


Question:
What happens when you add the asterisk (*) from any field list ot a query?

1.The table will not include any fields from the table

2.The query sorts the table’s record in the order you specify

3.The query will include every field from the table

4.The query uses the records from the table without displaying them


Question:
what is a fast way t adjust the width of a column?

1. Right click the left side of the column heading

2.Double click the left side of the column heading

3.Double click the right side of the column heading

4.Select tools>adjust column width from the menu


Question:
what is the corresponding text for the <#1/1/95# validation rule setting?

1.Neter a value less or more than 1195

2.Value must be less than 95 characters

3.Enter a date before 1995

4.All of above


Question:
what is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?

1.Object viewer

2.Object browser

3.Type library spy

4.None of above


Question:
What is the purpose of the description column in table design view?

1.To define the data type applied to each field within the table

2.To describe the data that should be entered in each field

3.To enter lookup data that the field should refer to.

4.None of the ablve


Question:
What is the type of query that extracts data from a table and puts them into separate table?

1.Parameter query

2.Make table query

3.Update query

4.Put table query


Question:
What is the use of description field in table design window?

1.The description will be displayed on status bar when entering data in datasheet view

2.The description will be displayed on status bar when entering data in form

3.Both of above

4.None of a the above


Question:
Which action will optimize your database performance?

1.Set the record set type to snapshot

2. Use the compact and repair database tool

3. Create a replica of the database

4.All of above


Question:
Which control does access use to link data access page components to Access data?

1.Microsoft dynamic data control

2.Microsoft data connection control

3. Microsoft office data source control

4.None of above


Question:
Which editor was provided for use with access basic?

1. The visual basic 1.0 editor

2.Notepad

3.The quickbasic editor

4.All of above


Question:
Which of the following best describes the grouped report?

1. A part of report that can be generated by the report wizard

2.A report that displays data that has been sorted in ascending or descending order

3.A report that displays data grouped by fields you specify

4.None of a the above


Question:
Which of the following columns does not exist in macro design window? 

1.Arguments

2.Comments

3.Conditions

4.Actions


Question:
Which of the following is a database management system?

1.Ms word

2.Ms excel

3.Oracle

4.Lotus 1-2-3


Question:
Which of the following is not a section in report design window?

1.Report header section

2. Page header section

3. Summary section

4.Report footer section


Question:
Which of the following query type is best suitable to analyze data?

1.Cross tab queries

2.Parameter queries

3.Action queries

4. None of above


Question:
You can not import data into access database from

1.Dbase iii database files

2. Excel spreadsheets

3.Comma delimited text files

4.None of above


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!