Microsoft Office Access 2007- Mcs High School

20 Questions | Total Attempts: 113

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

To my 3rd year students


Questions and Answers
  • 1. 
    An organized collection of data that is related to a particular subject or purpose.
    • A. 

      Database

    • B. 

      DBMS

    • C. 

      Table

    • D. 

      Primary Key

  • 2. 
    A computerized or electronic database is more commonly known as a database management system.
    • A. 

      Database

    • B. 

      DBMS

    • C. 

      Table

    • D. 

      Primary Key

  • 3. 
    A table is divided and structure into attributes, which known as:
    • A. 

      Field

    • B. 

      Book Table

    • C. 

      Ribbon

    • D. 

      Title

  • 4. 
    It is commonly used in the grocery or department store checkout counter. It records your transaction and generates updates reports for the store owner or manager.
    • A. 

      Point-of-sales

    • B. 

      Automated Teller Machine

    • C. 

      Flight Reservation System

    • D. 

      Computerized Inventory System

  • 5. 
    Allows you to conduct banking transaction such as withdrawing and depositing money using your account or transferring money from your savings to your checking account or vice verse.
    • A. 

      Point-of-sales

    • B. 

      Automated Teller Machine

    • C. 

      Flight Reservation System

    • D. 

      Computerized Inventory System

  • 6. 
    Allows you to see the details or description of flights, customers, bookings, and reservation.
    • A. 

      Computerized Inventory System

    • B. 

      Flight Reservation System

    • C. 

      Automated Teller Machine

    • D. 

      Point-of-sales

  • 7. 
    It is often used in warehouse operations to monitor the quantity, locations, and status of product.
    • A. 

      Computerized Inventory System

    • B. 

      Flight Reservation System

    • C. 

      Automated Teller Machine

    • D. 

      Point-of-sales

  • 8. 
    It is often used for school to automate the computation of tuition and other school fees.
    • A. 

      Automated Teller Machine

    • B. 

      Enrollment System

    • C. 

      Payroll Payment

    • D. 

      None of the above

  • 9. 
    Keeping track of addresses and telephone numbers using a wall calendar can be form as:
    • A. 

      Manual Database

    • B. 

      Electronic Database

    • C. 

      DBMS

    • D. 

      Data Management

  • 10. 
    Simple notes on the refrigerator can be considered as:
    • A. 

      Manual Database

    • B. 

      Electronic Database

    • C. 

      DBMS

    • D. 

      Data Management

  • 11. 
    It is designed to put all of your information in one table.
    • A. 

      Flat-file database

    • B. 

      Relational database

    • C. 

      Table

    • D. 

      Record

  • 12. 
    It is a set of field for a specific item, it represent one entry in a table.
    • A. 

      Flat-file database

    • B. 

      Relational database

    • C. 

      Table

    • D. 

      Record

  • 13. 
    It is a type of database wherein one or more tables are linked or related to other tables in a database, such as in the library system.
    • A. 

      Flat-file database

    • B. 

      Relational database

    • C. 

      Table

    • D. 

      Record

  • 14. 
    It is the stage where you gather and list all the necessary fields for the database.
    • A. 

      Data Definition

    • B. 

      Data Refinement

    • C. 

      Primary Key

    • D. 

      Relationship

  • 15. 
    After defining the necessary data needed for the database, some fields might have to be broken down to even more specific fields.
    • A. 

      Data Definition

    • B. 

      Data Refinement

    • C. 

      Primary Key

    • D. 

      Relationship

  • 16. 
    In this stage, we analyze the table more tables more closely and think on how relationships between tables can be established so that viewing and accessing of records across tables can be made possible.
    • A. 

      Data defining

    • B. 

      Establish relationship between tables

    • C. 

      Primary Key

    • D. 

      Relationship

  • 17. 
    It is an associated established between common fields in two tables. It can be one-to-one, one to many, or many-to-many.
    • A. 

      Data defining

    • B. 

      Relationship

    • C. 

      Establish relationship between tables

    • D. 

      Primary Key

  • 18. 
    It is database management software used to create small and midsize computer-base database.
    • A. 

      Microsoft Office Access

    • B. 

      Microsoft Excel

    • C. 

      Microsoft Paint

    • D. 

      Facebook.com

  • 19. 
    It works like the database window which displays all the database objects such as tables, forms, queries, reports, and macros.
    • A. 

      New UI look

    • B. 

      Navigation Pane

    • C. 

      Attachment Data type

    • D. 

      Ribbon

  • 20. 
    It allows you to easily store any supported type of file, including pictures, charts, text files, and so on.
    • A. 

      New UI look

    • B. 

      Navigation Pane

    • C. 

      Attachment Data type

    • D. 

      Ribbon