MS Access (Database Management System)

20 Questions | Total Attempts: 190

SettingsSettingsSettings
Please wait...
Management Quizzes & Trivia

This online quiz is intended for the Merry Child School Students.


Questions and Answers
  • 1. 
    The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables.
  • 2. 
    In a database table, the category of information is called ____________.
  • 3. 
    Computerized database is __________; since records stored in filing cabinets can be stored in  just a single  floppy disk.
  • 4. 
    Data definition is the stage when one gathers and list all necessary ___________ for our database.
  • 5. 
    In creating an effective database management system, careful _____________ is crucial.
  • 6. 
    This key uniquely identifies each record  in table.
    • A. 

      Primary key

    • B. 

      Key record

    • C. 

      Unique key

    • D. 

      Field name

  • 7. 
    It is an association established between common  fields (columns) in two tables.
    • A. 

      Line

    • B. 

      Relationship

    • C. 

      Primary key

    • D. 

      Records

  • 8. 
    It is stage where we break down some fields to more specific fields so we can store information in the smallest logical parts.
    • A. 

      Data definition

    • B. 

      Data refinement

    • C. 

      Establishing relationship

    • D. 

      None of the above

  • 9. 
    This is the stage in database design where one gathers and list all the necessary fields for the database project.  
    • A. 

      Data definition

    • B. 

      Data refinement

    • C. 

      Establishing relationship

    • D. 

      None of the above

  • 10. 
    A column in a table is called a _________________.
    • A. 

      Record

    • B. 

      Column

    • C. 

      Field

    • D. 

      Horizontal

  • 11. 
    It refers to row in a database table.
    • A. 

      Record

    • B. 

      Column

    • C. 

      Vertical

    • D. 

      Horizontal

  • 12. 
    It is a type of database where one or more tables are connected to other tables in the database, such as in the library system .
    • A. 

      Relational database

    • B. 

      List database

    • C. 

      Flat-file database

    • D. 

      None of the above

  • 13. 
    What do you call the database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file?
    • A. 

      Relational database

    • B. 

      List database

    • C. 

      Flat file database

    • D. 

      None of the above

  • 14. 
    It stands for POS in a checkout counter.
    • A. 

      Point-of-System

    • B. 

      Proof-of-Sales

    • C. 

      Point-of-Sales

    • D. 

      None of the above

  • 15. 
    It is a collection of data that is related to a particular subject or purpose.
    • A. 

      Database

    • B. 

      List

    • C. 

      Table

    • D. 

      Group

  • 16. 
    It is used to copy a text.
  • 17. 
    It is used to undo text.
  • 18. 
    It is used to create new file.
  • 19. 
    It is used to close single file.
  • 20. 
    It is used to close a program application.
Back to Top Back to top