Database Concepts 4

9 Questions | Total Attempts: 658

SettingsSettingsSettings
Please wait...
Database Concept Quizzes & Trivia

Tests concepts of database and knowledge of MS Access


Related Topics
Questions and Answers
  • 1. 
    Mary has created a database which has two tables, a categories table and a products table. For a particular category there can be many products. She wants to find out for which category there are no products. Which type of query should she use?
    • A. 

      Simple Query Wizard

    • B. 

      Crosstab Query Wizard

    • C. 

      Finding Duplicates Query Wizard

    • D. 

      Finding Unmatched Query Wizard

  • 2. 
    A field that is a primary key in another table is called a ____________________
    • A. 

      Special key

    • B. 

      Foreign key

    • C. 

      Simple key

    • D. 

      Composite key

  • 3. 
    Which of the following is not a function of a form?
    • A. 

      Allows you to change the data type of a field

    • B. 

      Browse the contents of a table

    • C. 

      Enter data in a table

    • D. 

      Modify data in a table

    • E. 

      Delete data from a table

  • 4. 
    _______________ controls on a form are not linked to the fields in a table.
    • A. 

      Bound

    • B. 

      Unbound

    • C. 

      Boundary

    • D. 

      Calulated

  • 5. 
    _________________ controls are linked to a field in a table.
    • A. 

      Bound

    • B. 

      Unbound

    • C. 

      Boundary

    • D. 

      Calulated

  • 6. 
    _________________ controls are used to display a calulated value based on one or more fields in a table.
    • A. 

      Bound

    • B. 

      Unbound

    • C. 

      Boundary

    • D. 

      Calulated

  • 7. 
    John Smith sells computer parts. He maintains a database of inventory items with their respective names and prices. A customer wants to know the most expensive sound speakers in Smith's store. Which query wizard can John Smith run to answer the customer's query?
    • A. 

      Simple Query Wizard

    • B. 

      Crosstab Query Wizard

    • C. 

      Finding Duplicates Query Wizard

    • D. 

      Finding Unmatched Query Wizard

  • 8. 
    Ronald Billing wants to search for duplicate records in a table or query of a Microsoft Access database. Which of the following wizards will Ronald use to perform this operation?
    • A. 

      Simple Query Wizard

    • B. 

      Crosstab Query Wizard

    • C. 

      Finding Duplicates Query Wizard

    • D. 

      Finding Unmatched Query Wizard

  • 9. 
    Which of the following measuring unit is used to measure the font size in the forms of Access database?
    • A. 

      Points

    • B. 

      Picas

    • C. 

      Pixels

    • D. 

      Meters