Microsoft Access

SettingsSettings
Please wait...
  • 1/20 Questions

    A database is an organized collection of information.

    • True
    • False
Please wait...
About This Quiz

This quiz is designed to ensure students are familiar with the terminology associated with the�Microsoft Access Database application.

Microsoft Access Quizzes & Trivia

Quiz Preview

  • 2. 

    Which of the following is a way to sort data?

    • Chronologically

    • Alphabetically

    • Numerically

    • All of the above

    • None of the above

    Correct Answer
    A. All of the above
  • 3. 

    If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?

    • Ascending

    • Descending

    • Incremental

    • Exponential

    Correct Answer
    A. Descending
  • 4. 

    A computerized database can store millions of telephone numbers.

    • True

    • False

    Correct Answer
    A. True
  • 5. 

    A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.

    • True

    • False

    Correct Answer
    A. True
  • 6. 

    One disadvantage of computerized databases is that they limit your ability to arrange information.

    • True

    • False

    Correct Answer
    A. False
  • 7. 

    A property rental database acts as an index to let users find and view all properties leased by landlords.

    • True

    • False

    Correct Answer
    A. True
  • 8. 

    A database is a collection of related information, but a database management system is a type of software program.

    • True

    • False

    Correct Answer
    A. True
  • 9. 

    A field's data type determines what kind of information can be stored there.

    • True

    • False

    Correct Answer
    A. True
  • 10. 

    The use of a password can help preserve a database's _____________.

    • Privacy

    • Security

    • Accurace

    • Integrity

    Correct Answer
    A. Security
  • 11. 

    What does a filter do?

    • Make more records available

    • Hide records from view

    • Slow down processing

    • Add to the quantity of data

    Correct Answer
    A. Hide records from view
  • 12. 

    What is a query?

    • A question you ask a database

    • A question you ask a record

    • A question you ask a table

    • A question you ask a field

    Correct Answer
    A. A question you ask a database
  • 13. 

    Which of he following is NOT a part of a database?

    • Tables

    • Records

    • Fields

    • Worksheets

    Correct Answer
    A. Worksheets
  • 14. 

    In a database, each _________________ contains a collection of related data.

    • Table

    • Record

    • Field

    • None of the above

    Correct Answer
    A. Table
  • 15. 

    In a database, a _____________ is a unit of information about one individual or item.

    • Table

    • Record

    • Field

    • File

    Correct Answer
    A. Field
  • 16. 

    Once tables are created and defined, Access will automatically save data as you type without clicking save.

    • True

    • False

    Correct Answer
    A. True
  • 17. 

    If you sort a database's information chronologically, then you are sorting letters and symbols.

    • True

    • False

    Correct Answer
    A. False
  • 18. 

    Databases typically store all of  the data you entered into one combined table.

    • True

    • False

    Correct Answer
    A. False
  • 19. 

    If you want to view some but not all information in a table so you can insert data in a certain field for multiple records which feature would you most likely use?

    • Find & Replace

    • Filter

    • Sort

    • Freeze Panes

    Correct Answer
    A. Freeze Panes
  • 20. 

    The same features that make databases efficient tools also enables them to keep data secure.

    • True

    • False

    Correct Answer
    A. False

Quiz Review Timeline (Updated): +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 04, 2019
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 09, 2015
    Quiz Created by
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.