8th Class Computers Science Microsoft Access Question Bank

done Introduction to MS-Access 2010 Total Questions - 25

• question_answer1)
  ________is the complete list of the Access objects.
  A)
  Tables, forms, queries, fields done clear
  B)
  Queries, reports, forms, tools done clear
  C)
  Records, queries, reports, forms done clear
  D)
  Tables, forms, queries, reports done clear
  View Solution play_arrow

• question_answer2)
  _____ is the primary means by which you can view and access all your database objects.
  A)
  Document Tabs bar         done clear
  B)
  Navigation pane done clear
  C)
  Objects pane      done clear
  D)
         Ribbon done clear
  View Solution play_arrow

• question_answer3)
  In Access, rows are referred to as ______, and columns are referred to as _____ respectively.
  A)
  Lines, Records    done clear
  B)
  Records, Fields done clear
  C)
  Fields, Records done clear
  D)
         Objects, Types done clear
  View Solution play_arrow

• question_answer4)
  A ______ is a collection of related records.
  A)
  DataBank         done clear
  B)
  Table done clear
  C)
  Database       done clear
  D)
  Field done clear
  View Solution play_arrow

• question_answer5)
  The main feature of a relational database is that ______.
  A)
  It provides a logical relationship between numbers done clear
  B)
  It consists of separate tables of related Data done clear
  C)
  It provides relationship between numbers and date done clear
  D)
  It provides a relationship between text and memo data done clear
  View Solution play_arrow

• question_answer6)
  _________ allow you to enter data directly into tables.
  A)
  Menus               done clear
  B)
         Objects done clear
  C)
  Forms                            done clear
  D)
  Reports done clear
  View Solution play_arrow

• question_answer7)
  Sorting records in A\[\to \]Z order is arranging it in ________ order.
  A)
  Ascending          done clear
  B)
         Descending done clear
  C)
  Filtered              done clear
  D)
         Unfiltered done clear
  View Solution play_arrow

• question_answer8)
  When you want to view records/fields from more than one table, you should specify the criteria in which of the following database object?
  A)
  Report               done clear
  B)
         Query done clear
  C)
  Field                  done clear
  D)
         Forms done clear
  View Solution play_arrow

• question_answer9)
  Identify the given icon.  
  A)
  Sort                              done clear
  B)
  Filter done clear
  C)
  Selection                        done clear
  D)
  View done clear
  View Solution play_arrow

• question_answer10)
  A ______ is a drop-down list you can add to your form.
  A)
  Field Box                       done clear
  B)
  Option Box done clear
  C)
  Combo Box       done clear
  D)
  Tab Box done clear
  View Solution play_arrow

• question_answer11)
  You can use Queries in Access________.
  A)
  To view, change and analyze data in different ways done clear
  B)
  As a source of records for forms and Reports done clear
  C)
  Both [A] and [B] done clear
  D)
  None of these done clear
  View Solution play_arrow

• question_answer12)
  What is a form?
  A)
  It is a printed page on which users write their data and fill it up. done clear
  B)
  It is an input tool/interface designed to simplify, viewing and entering data. done clear
  C)
  It is a vital part of a database used by analysts to draw conclusions. done clear
  D)
  All of these done clear
  View Solution play_arrow

• question_answer13)
  Which of the following is a type of relationship that can be applied in Access database?
  A)
  One to-One                    done clear
  B)
  One to-Many done clear
  C)
  Many-to-Many  done clear
  D)
         All of these done clear
  View Solution play_arrow

• question_answer14)
  To create relationship between two tables __________.
  A)
  The primary key of one table should be dragged into the foreign key of another table done clear
  B)
  Select a field from parent table and make it the foreign key of the child table done clear
  C)
  Drag the foreign key of one table in all tables that are used done clear
  D)
  All of these done clear
  View Solution play_arrow

• question_answer15)
  _____ is NOT a valid data type.
  A)
  Number             done clear
  B)
         Text done clear
  C)
  Memo               done clear
  D)
         Left/Right done clear
  View Solution play_arrow

• question_answer16)
  Which data type allows alphanumeric characters and special symbols?
  A)
  Text                  done clear
  B)
         Memo done clear
  C)
  AutoNumber      done clear
  D)
         Both [A] and [B] done clear
  View Solution play_arrow

• question_answer17)
  In Text data type, we can store a maximum of ______characters.
  A)
  255           done clear
  B)
  512 done clear
  C)
  1024                 done clear
  D)
                     2048 done clear
  View Solution play_arrow

• question_answer18)
   is used to ___________.
  A)
  Launch the Query Wizard done clear
  B)
  Launch the Report Wizard done clear
  C)
  Launch the Label Wizard done clear
  D)
  Refresh All done clear
  View Solution play_arrow

• question_answer19)
  represents _______ View.
  A)
  Datasheet          done clear
  B)
  Design done clear
  C)
  Layout              done clear
  D)
  Form done clear
  View Solution play_arrow

• question_answer20)
  Which of the following data types is used to store pictures, graphs, sounds, video, etc. in a field?
  A)
  Meta                             done clear
  B)
  OLE object done clear
  C)
  Currency            done clear
  D)
         Memo done clear
  View Solution play_arrow

• question_answer21)
  What is the maximum number of characters that can be used to define a table name?
  A)
  64 characters including letters, numbers and spaces. done clear
  B)
  64 characters excluding letters, numbers and spaces. done clear
  C)
  128 characters including letters, numbers and spaces. done clear
  D)
  128 characters excluding letters, numbers and spaces. done clear
  View Solution play_arrow

• question_answer22)
   is used to ________.
  A)
  Insert or create portions of a database or an entire database application done clear
  B)
  Create a new blank table in Design view done clear
  C)
  Publish a query of the current database done clear
  D)
  Refresh all done clear
  View Solution play_arrow

• question_answer23)
   is used to ______.
  A)
  Show the report wizard which helps you create simple and customized reports done clear
  B)
  Show the form wizard which helps you create simple and customizable forms done clear
  C)
  Add logic to your database to automate repetitive tasks done clear
  D)
  Show the query wizard done clear
  View Solution play_arrow

• question_answer24)
  Which of the following is used to view the replies to data collected in e-mail messages?
  A)
                     done clear
  B)
    done clear
  C)
          done clear
  D)
    done clear
  View Solution play_arrow

• question_answer25)
  Which of the following statements is CORRECT?
  A)
  Reports can be used to retrieve data from tables. done clear
  B)
  Queries can be printed and presented as the information. done clear
  C)
  Queries can include calculated fields that may not exist in table. done clear
  D)
  Reports and forms are more or less similar. Only difference being, forms are printed, reports are viewed online. done clear
  View Solution play_arrow