8th Class Computers Science Microsoft Access Question Bank

done Microsoft Access Total Questions - 42

• question_answer1)
  What is the program that enables you to create, access and manage a database called?
  A)
   Database done clear
  B)
   Data structure done clear
  C)
   Operating system done clear
  D)
   Database Management System done clear
  View Solution play_arrow

• question_answer2)
  Which of the following is a popular software that supports DBMS?
  A)
   MS-Access           done clear
  B)
        MS-Word           done clear
  C)
          MS-Excel              done clear
  D)
          MS-Paint                            done clear
  View Solution play_arrow

• question_answer3)
  What was the initial code name of MS-Access?
  A)
   Omega                done clear
  B)
          Cirrus                   done clear
  C)
           Deco                    done clear
  D)
          Boston done clear
  View Solution play_arrow

• question_answer4)
  When an Access file is saved, what file format does it take?
  A)
   .MDB                    done clear
  B)
          .PST      done clear
  C)
          .RLS      done clear
  D)
          .ODP done clear
  View Solution play_arrow

• question_answer5)
  In MS-Access, what do the rows in. a table represent?
  A)
   fields                                    done clear
  B)
   records                done clear
  C)
          data                      done clear
  D)
          tables                   done clear
  View Solution play_arrow

• question_answer6)
  In MS-Access, what defines the information of each type of detail in a record?
  A)
   Tables                                  done clear
  B)
   Files                      done clear
  C)
          Documents        done clear
  D)
          Fields                   done clear
  View Solution play_arrow

• question_answer7)
  In MS-Access, what is the function of the primary key?
  A)
   To identify each row of a table. done clear
  B)
   To relate tables to each other using a foreign key. done clear
  C)
   "To maintain reference and referential integrity. done clear
  D)
   All of the above done clear
  View Solution play_arrow

• question_answer8)
  What is the correct path to start MS-Access?
  A)
   Start\[\to \]Programs\[\to \]Microsoft Office\[\to \] MS\[\to \]Access done clear
  B)
   Start\[\to \]Programs\[\to \]Accessories\[\to \]MS-Access done clear
  C)
   Start \[\to \] Run \[\to \]MS-Access done clear
  D)
   Start\[\to \] Accessories\[\to \]Microsoft Office\[\to \] MS-Access done clear
  View Solution play_arrow

• question_answer9)
  What is the maximum characters a field name can contain in MS- Access?
  A)
   32                          done clear
  B)
   64          done clear
  C)
   255       done clear
  D)
          100                                        done clear
  View Solution play_arrow

• question_answer10)
  Which program in MS-Access is used to automate a repetitive task?
  A)
   Reports               done clear
  B)
          Forms                  done clear
  C)
          Macros                done clear
  D)
          Pages                   done clear
  View Solution play_arrow

• question_answer11)
  Which shortcut key will open the task pane in MS-Access?
  A)
   Ctrl + F1                               done clear
  B)
   Ctrl + F5               done clear
  C)
          Shift + F1            done clear
  D)
          Shift + F5 done clear
  View Solution play_arrow

• question_answer12)
  What is the shortcut key that helps you insert the current date in access?
  A)
   Ctrl + semicolon done clear
  B)
           Alt + semicolon done clear
  C)
                          Shift + semicolon done clear
  D)
             Semicolon                          done clear
  View Solution play_arrow

• question_answer13)
  What is the DEFAULT SIZE of text data type in MS-Access?
  A)
   20                          done clear
  B)
   255        done clear
  C)
          50          done clear
  D)
          256        done clear
  View Solution play_arrow

• question_answer14)
  Which of the following characters cannot be used while naming a file in MS-Access?
  A)
   []         done clear
  B)
   ?             done clear
  C)
   - (dash)    done clear
  D)
   , (comma) done clear
  View Solution play_arrow

• question_answer15)
  Which one of the following is NOT a valid MS-Access field data type?
  A)
   Number                              done clear
  B)
   Memo                 done clear
  C)
          Text                      done clear
  D)
          Character done clear
  View Solution play_arrow

• question_answer16)
  Which of the following data types is used for lengthy text and numbers?
  A)
   Text                                      done clear
  B)
   Memo                                 done clear
  C)
   Currency             done clear
  D)
          Numbers done clear
  View Solution play_arrow

• question_answer17)
  What does the given window represent?
  A)
   Design view         done clear
  B)
          Datasheet view done clear
  C)
   Database window           done clear
  D)
   File task pane window done clear
  View Solution play_arrow

• question_answer18)
  Which view gives more control over the table or query?
  A)
   Design view               done clear
  B)
   Datasheet view               done clear
  C)
   Both (a) and (b) done clear
  D)
   Neither (a) nor (b)                                          done clear
  View Solution play_arrow

• question_answer19)
  ___ creates tables, modifies and organizes bulk data.
  A)
   Word processor done clear
  B)
   Presentation software done clear
  C)
   Animation software done clear
  D)
   Data Base Management System (DBMS) done clear
  View Solution play_arrow

• question_answer20)
  The  icon of the field indicates that r
  A)
   this field is the primary key with a unique value. done clear
  B)
   you are currently entering data into this row or field. done clear
  C)
   you are deleting the field. done clear
  D)
   you are inserting a new column into the table. done clear
  View Solution play_arrow

• question_answer21)
  The Iconindicates that
  A)
   this field is the primary key with a unique value. done clear
  B)
   you are currently entering data into this row or field. done clear
  C)
   you are deleting the field. done clear
  D)
   you are inserting a new column into the table. done clear
  View Solution play_arrow

• question_answer22)
  ___ uniquely identifies a record of the table.
  A)
   Data view sheet       done clear
  B)
   Design view done clear
  C)
   Primary key            done clear
  D)
   Forms done clear
  View Solution play_arrow

• question_answer23)
  Which of these icons will help you enter the data into a table?
  A)
   Data sheet view sheet done clear
  B)
   Design view done clear
  C)
   Primary key done clear
  D)
            Forms done clear
  View Solution play_arrow

• question_answer24)
  Which of the following options will you choose to design the format of your table and the data types?
  A)
   Data view sheet       done clear
  B)
   Design view done clear
  C)
   Primary key done clear
  D)
             Forms done clear
  View Solution play_arrow

• question_answer25)
  Which of these is/are DBMS?
  A)
   MS Access                          done clear
  B)
   Oracle  done clear
  C)
          Fox pro                 done clear
  D)
          All of these                        done clear
  View Solution play_arrow

• question_answer26)
  When you right click on any field of the table, you will find a menu. What is it called?
  A)
   Shortcut menu                 done clear
  B)
   Edit menu          done clear
  C)
          File menu             done clear
  D)
          Help menu                         done clear
  View Solution play_arrow

• question_answer27)
  Which of these menu options must be chosen to set the primary key using the menu bar?                                  
  A)
   Shortcut menu   done clear
  B)
          Edit menu done clear
  C)
   File menu             done clear
  D)
          Help menu done clear
  View Solution play_arrow

• question_answer28)
  Two or more columns which are set as primary keys are called _­­­_________ primary keys.                                      
  A)
   unique                                 done clear
  B)
   report                  done clear
  C)
          form                                     done clear
  D)
   composite          done clear
  View Solution play_arrow

• question_answer29)
  Which of these objects provides the accessibility of data through internet?
  A)
   Reports               done clear
  B)
          Macros                done clear
  C)
          Pages                   done clear
  D)
          Query                  done clear
  View Solution play_arrow

• question_answer30)
  Which objects of MS Access interconnects two or more tables of Access?
  A)
   Reports                               done clear
  B)
   Macros                done clear
  C)
          Pages                   done clear
  D)
          Query done clear
  View Solution play_arrow

• question_answer31)
  The printouts of the Access database are called ________.
  A)
   pages                    done clear
  B)
          reports                done clear
  C)
          forms                    done clear
  D)
          tables done clear
  View Solution play_arrow

• question_answer32)
  Which of the following statements is/are false?
  A)
   Macros are small, user - written programs to automate repetitive tasks. done clear
  B)
   Forms are the printouts of the Access files.        done clear
  C)
   Queries interrelates two or more tables. done clear
  D)
   All of these done clear
  View Solution play_arrow

• question_answer33)
  Which of the following windows represents the last step in the creation of a table?
  A)
    done clear
  B)
  done clear
  C)
  done clear
  D)
    done clear
  View Solution play_arrow

• question_answer34)
  Which of the following displays sample tables?
  A)
   Blank Access database      done clear
  B)
   Table wizard done clear
  C)
   Both (a) and   done clear
  D)
            Neither (b) nor done clear
  View Solution play_arrow

• question_answer35)
  Which of these icons will you click to insert a new column?
  A)
                                      done clear
  B)
       done clear
  C)
                                              done clear
  D)
                         done clear
  View Solution play_arrow

• question_answer36)
                                                  Which icon will you choose to delete a row from a table?
  A)
      done clear
  B)
                               done clear
  C)
                                                             done clear
  D)
                         done clear
  View Solution play_arrow

• question_answer37)
                                                  The ___ icon helps you insert a new row into the table.
  A)
                                      done clear
  B)
      done clear
  C)
                                                                             done clear
  D)
                         done clear
  View Solution play_arrow

• question_answer38)
                                                  Which of these icons should you click to delete a column from the table?
  A)
                                       done clear
  B)
       done clear
  C)
                                                                              done clear
  D)
                         done clear
  View Solution play_arrow

• question_answer39)
                                                  Which icon will you click on to switch to design view from Datasheet view?
  A)
                                     done clear
  B)
       done clear
  C)
                             done clear
  D)
         done clear
  View Solution play_arrow

• question_answer40)
                                                  Which icon of the standard tool bar will you click, to switch on to Data sheet view from Design view?
  A)
                                      done clear
  B)
     done clear
  C)
                                                             done clear
  D)
                         done clear
  View Solution play_arrow

• question_answer41)
                                  What is the function of freeze column option?                 
  A)
   Inserts a new column      done clear
  B)
   Inserts a new row          done clear
  C)
   Deletes a row      done clear
  D)
          Freezes the selected column done clear
  View Solution play_arrow

• question_answer42)
  Which of the following is NOT true about primary key?
  A)
   Primary key field can have a character value. done clear
  B)
   Primary key field helps to check redundancy of data. done clear
  C)
   Primary key field can have a null value. done clear
  D)
   Primary key field can have zero value. done clear
  View Solution play_arrow