Computer/MS Access MCQ Questions Part 3 Sample Test,Sample questions

Question:
  What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

1.display all customers with CustID from 10 to 100

2.display all customers with CustID above 10

3.display all customers with CustID below 100

4.display all customers with CustID from 11 to 99


Question:
 How to make a date field DOB store the dates like “2002/10/17” ?

1.By setting the input mask property to “yyyy/mm/dd”

2.By setting the format property to “yyyy/mm/dd”

3.By entering dates in yyyy, mm, dd order

4.none of the above


Question:
 In a datasheet, what does each column represent?

1.Record

2.Field

3.Database

4.Table


Question:
 In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

1. zipcode, firstname, lastname

2.firstname, lastname, zipcode

3.zipcode, lastname, firstname

4. can’t sort by multiple fields


Question:
 What is an intersection of a row and a column?

1.Form

2.Cursor

3.Cell

4.Record


Question:
 Which criteria do not return the position “Officer” as a match?

1.position = “*ff*”

2.position = “O??icer”

3.position = ” ?ff*”

4.position = “O#r”


Question:
 Which is the valid data type in Access?

1.Number

2.Text

3.Currency

4.All of the above


Question:
 Which leads you through the process of creating a table?

1.wizard

2.assistant

3.relation

4.coach


Question:
 Which object is used to create a form?

1.Tables and Queries

2.Tables only

3.Tables and reports

4. Queries and reports


Question:
 Which of the following is not a database application?

1.dBase

2.Flash

3.FoxPro

4.Access


Question:
 Which of the following is not an action query?

1.add

2.delete

3.make-table

4.update


Question:
 Which tool do you use to create a query object?

1.Database wizard

2.Simple filter wizard

3.Simple query wizard

4.Table query wizard


Question:
 You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

1.By setting required to ‘Yes’

2.By using default value

3.By defining validation rule

4. By using forma


Question:
A ________ is a unit of information in a ________

1.record, field

2. field, record

3.data source, field

4.record, data source


Question:
After right click the field selector button, which do you choose to delete a field in design view?

1.Delete field

2.delete rows

3.remove field

4.remove rows


Question:
How many relations may exist between tables in databases?

1.4

2.3

3.2

4.1


Question:
HSAM stands for ________ 

1.Hierarchic Sequential Access Method

2.Hierarchic Standard Access Method

3.Hierarchic Sequential and Method

4.Hierarchic Standard and Method


Question:
In a datasheet, what does each row represent?

1.Record

2.Field

3.Database

4.Table


Question:
In an application created using the database wizard, the main menu is presented as a

1.form, called a switchboard

2.report, called a menu

3.table, called a switchboard

4. query, called a menu


Question:
In databases, Locking level is also called as

1.Granularity

2. S lock

3.X lock

4.Dead lock


Question:
In MS Access, Text Data type may contain maximum character of

1.255Character

2.256 Character

3.1064 Character

4.No Limit


Question:
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

1.datasheet border

2.datasheet underline

3. Column Header underline

4.vertical gridline


Question:
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?

1.Referential integrity is enforced

2.Referential integrity isn’t enforced

3.An inner join is set

4.An outer join is set


Question:
 An organized collection of logically related data is known as 

1.Data

2.Meta data

3.Database

4.Information


Question:
The basic elements of a form or a report are called

1.Controls

2.Objects

3.Windows

4.Properties


Question:
The report footer section is most useful for displaying

1.grand totals

2.Column headings

3.subtotals

4.page numbers


Question:
What do you call a collection of records matching parameters of a query?

1.Field

2.Record

3.Query

4.Dynaset


Question:
What do you call a primary key field included in another table?

1.Foreign key

2. Parent key

3.Child key

4.Index


Question:
What do you call the process of restricting the display of records in a table to those matching a particular criterion?

1.filtering

2.restricting

3.sorting

4.sifting


Question:
What does the expression [detail] ! [product] * 1.30 do?

1.multiplies the contents of detail and product fields by 1.3

2.First divides detail by product and then multiplies by 1.3

3. multiplies the contents of detail in the product table by 1.3

4.multiplies the contents of product in the detail table by 1.3


Question:
What is the full form of SQL?

1.Sophisticated Question List

2.Structured Question List

3.Structured Query Language

4.Small Query Length


Question:
What is the purpose of indexing?

1.To reduce table size

2. To speedup data search

3.both A and B

4.none of the above


Question:
Which control type do you use to create a calculated control?

1.command button

2.combo box

3. text box

4.list box


Question:
Which control types is most often associated with a bound control?

1. command button

2.label

3. text box

4.list box


Question:
Which criteria return only those addresses beginning with the letter “K”?

1.address = “K”

2. address = “K*”

3.address = “K?”

4.address = “K#”


Question:
Which data type is better to use for storing phone number in the following format “977-1-1234567”?

1.Text

2.AutoNumber

3.Number

4.Currency


Question:
Which data type is better to use for storing the price of an item?

1.Text

2.AutoNumber

3.Number

4.Currency


Question:
Which do you click to display the table’s primary key and indexes in a separate window?

1.indexes button

2.primary key button

3.view datasheet button

4.view design button


Question:
Which function can not be used for calculated controls in a report?

1.SUM

2.AVG

3.MPT

4.COUNT


Question:
Which is not a command that is selectable from right click menu of a field column?

1.Hide columns

2.Rename columns

3.freeze columns

4.sort descending


Question:
Which is not a view for displaying a report object?

1.Datasheet view

2.Design view

3.Print preview

4.Layout preview


Question:
Which is not an option for customizing a datasheet window?

1.change one row’s height

2.hide one column

3.change one column’s width

4.freeze one column


Question:
Which of the following is not a legitimate section for form objects?

1.Form detail

2.Group header

3.Form header

4.Page footer


Question:
Which of the following is not a logical database structure?

1.Chain

2.Network

3.Tree

4.Relational


Question:
Which of the following is not a view for interacting with a form object?

1.Datasheet view

2.Design view

3.Form view

4.Layout view


Question:
Which query do you use to answer the question “What is the average salary of the employees”?

1.Search query

2.Cross tab query

3.Select query

4.Update query


Question:
Which query do you use to answer the question “Which employees earn more than $5000 a month?

1.Search query

2.Cross tab query

3.Select query

4. Update query


Question:
Which setting you must modify to print a report using letterhead? 

1.Group

2.Margin

3.Section

4.Orientation


Question:
Which tool is used to generate printout of a table’s structure?

1.Analyzer

2.Designer

3.Documenter

4.Generator


Question:
Which type of field is incremented automatically?

1.Auto Elevate

2.AutoNumber

3. Auto Increment

4.Auto Value


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. Data Structures and algorithms MCQ Questions
  67. Computer Communication and Networking Quiz
  68. Computer Graphics MCQ Quiz Questions and Answers
  69. Computer Basics Quiz Questions
  70. Computer Quiz Questions with Answers
  71. Computer Hardware MCQS Quiz
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!