MS Access MCQ

Test your knowledge with important MS Access MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more MS Access MCQs at Bissoy

• How can you display sales grouped by country, region, and salesperson, all at the same time?
  ক

  Use the Sort Descending command.

  খ

  Use the Pivot table view command

  গ

  Use the find command on specified groups

  ঘ

  All of above
• Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
  ক

  File menu

  খ

  View menu

  গ

  Database menu

  ঘ

  Tools menu
• Which of the following is not a form style available in the form wizard dialog box.
  ক

  Blends

  খ

  Standard

  গ

  Stone

  ঘ

  Highlights
• Which function extracts the name of the month from a date/time value?
  ক

  Month

  খ

  MonthName

  গ

  MonthLabel

  ঘ

  MonthValue
• how do you update pivot table report data after changes are made to the source data?
  ক

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

  খ

  Select the pivot table worksheet and press f9 on the keyboard

  গ

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

  ঘ

  All of the above
• Which part of the IIF expression is the action performed if the true condition exists?
  ক

  inner

  খ

  first

  গ

  second

  ঘ

  third
• The report footer section is most useful for displaying:
  ক

  grand totals

  খ

  Column headings

  গ

  subtotals

  ঘ

  page numbers
• It is a sign or symbol that specifies, operator, and values that produce a result
  ক

  operator

  খ

  query

  গ

  expression

  ঘ

  None of the above
• Which of the following is the default join between two recordsets?
  ক

  Inner join

  খ

  Left outer join

  গ

  Right outer join

  ঘ

  Self join
• It is a database object to view, change, and analyze data in different ways
  ক

  query

  খ

  form

  গ

  report

  ঘ

  None of the above
• How many relations may exist between tables in databases?
  ক

  4

  খ

  3

  গ

  2

  ঘ

  1
• Which is the valid data type in Access?
  ক

  Number

  খ

  Text

  গ

  Currency

  ঘ

  All of the above
• To enter the input mask wizard
  ক

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

  খ

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

  গ

  Click on the input mask toolbar

  ঘ

  Click on the three dots to the right of the input mask entry field
• An application that executes on separate PCs like this is called a(n) __________ application.
  ক

  enterprise

  খ

  distributed

  গ

  tier

  ঘ

  global
• Which of the following store command to retrieve data from database?
  ক

  Forms

  খ

  Reports

  গ

  Queries

  ঘ

  Tables
• Primary key is
  ক

  Uniquely identifies each record

  খ

  Cannot be repeated

  গ

  AutoNumber is example of Primary key

  ঘ

  All of the above
• In Access to Open a combo box
  ক

  F4 or ALT+DOWN ARROW

  খ

  DOWN ARROW

  গ

  PAGE DOWN

  ঘ

  F9
• A small button with three dots usually displayed at the right of field properties box
  ক

  Make button

  খ

  Expression button

  গ

  Build button

  ঘ

  None of above
• Which is NOT a method of creating a table?
  ক

  Datasheet View

  খ

  Design View

  গ

  Layout View

  ঘ

  Template
• A database object in MS Access that stores a question about the data in database?
  ক

  Table

  খ

  Form

  গ

  Query

  ঘ

  Report
• Referential integrity means
  ক

  Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

  খ

  Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table

  গ

  Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table

  ঘ

  All of above
• the executive responsible for the data processing function in an organization is
  ক

  Pm

  খ

  Dbms

  গ

  Dp

  ঘ

  Dpm
• A __________ enables you to view data from a table based on a specific criterion
  ক

  Form

  খ

  Query

  গ

  Macro

  ঘ

  Report
• Which major database object stores all data?
  ক

  Field

  খ

  Query

  গ

  Record

  ঘ

  Table
• Which of the following is a standard file format language for web documents?
  ক

  HTML

  খ

  XML

  গ

  XSD

  ঘ

  XSL
• In the second subform wizard dialog box you specify the table to use as the data source and the
  ক

  Records from the selected form

  খ

  Form from the selected table

  গ

  Fields from the selected table

  ঘ

  Content from the selected form
• In the Field List of a table, the primary key appears _______________.
  ক

  bold

  খ

  italicized

  গ

  underlined

  ঘ

  with key icon
• The __________ is used to access one record at a time.
  ক

  query

  খ

  filter

  গ

  form

  ঘ

  report
• A _______ often display summary data such as totals or counts.
  ক

  Group Header

  খ

  Group Footer

  গ

  Report Header

  ঘ

  Page Footer
• The key uniquely identifies each record in a table.
  ক

  primary key

  খ

  key word

  গ

  filed name

  ঘ

  All of above