Basic Database And MS Access Concepts Quiz!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Kumar_niten
K
Kumar_niten
Community Contributor
Quizzes Created: 7 | Total Attempts: 66,232
Questions: 10 | Attempts: 843

SettingsSettingsSettings
Database Concept Quizzes & Trivia

A database is a systematic collection of information or data in electronic form, which can be accessed, retrieved and updated. This process is executed in a DBMS (Database management system). Whereas, Microsoft Access is an application that helps in maintaining and organizing databases for reporting and analysis. Take this quiz to test your knowledge about the concepts of Database and MS Access. So, let's try out the quiz. All the best!


Questions and Answers
  • 1. 

    A table called students has to be searched to find out how many males are in the class. Which object can be used to achieve this?

    • A.

      Macros

    • B.

      Forms

    • C.

      Queries

    • D.

      Reports

    • E.

      Modules

    Correct Answer
    C. Queries
    Explanation
    Queries can be used to search the table called students and retrieve specific information from it. By creating a query with appropriate criteria, it is possible to filter the data and retrieve only the records that correspond to males in the class. Queries allow for flexible and efficient searching and filtering of data in a database.

    Rate this question:

  • 2. 

    What command can be used to close the current database?

    • A.

      File -> Close

    • B.

      File -> Exit

    • C.

      File -> End

    • D.

      File -> Quit

    Correct Answer
    A. File -> Close
    Explanation
    The correct answer is "File -> Close" because the command "Close" is commonly used to indicate the action of closing a file or a database. The other options, "Exit," "End," and "Quit," are typically used to indicate the action of exiting or quitting an entire program or application, rather than just closing a specific file or database.

    Rate this question:

  • 3. 

    What command can be used to close Microsoft Access?

    • A.

      File -> Close

    • B.

      File -> Exit

    • C.

      File -> End

    • D.

      File -> Quit

    Correct Answer
    B. File -> Exit
    Explanation
    The correct answer is "File -> Exit" because in Microsoft Access, the "Exit" option under the "File" menu is used to close the application. This command allows the user to exit the program and close all open databases and windows associated with Microsoft Access.

    Rate this question:

  • 4. 

    Which property of a field enables you to simplify the task of data entry and control the values that users enter for a field?

    • A.

      Validation Rule

    • B.

      Default

    • C.

      Caption

    • D.

      Validation Text

    • E.

      Input Mask

    Correct Answer
    E. Input Mask
    Explanation
    An input mask is a property of a field that enables you to simplify the task of data entry and control the values that users enter for a field. It allows you to define a specific format for data entry, such as phone numbers or social security numbers, and automatically applies that format as users enter data. This helps ensure that the data entered is consistent and accurate, reducing the likelihood of errors and making data entry more efficient.

    Rate this question:

  • 5. 

    The Database Administrator of a company has the records of employee details in the Employee table. He carries out frequent searches based on the address field of the Employee table. What should he do to make the search faster?

    • A.

      Index the Address field of the Employee table

    • B.

      Set the Address field as the primary key

    • C.

      Set the EmployeeID as the primary key

    • D.

      Use a validation rule on the address field

    Correct Answer
    A. Index the Address field of the Employee table
    Explanation
    To make the search faster, the Database Administrator should index the Address field of the Employee table. Indexing allows for quicker retrieval of data by creating a separate data structure that stores the values of the indexed field in a sorted order. This helps in reducing the search time and improving overall query performance when searching based on the address field. Setting the Address field as the primary key or using a validation rule on the address field may not necessarily improve search speed, and setting the EmployeeID as the primary key is unrelated to optimizing search performance based on the address field.

    Rate this question:

  • 6. 

    The association that is created between tables when they are joined is called a __________________.

    • A.

      Module

    • B.

      Relationship

    • C.

      One-to-one

    • D.

      Referential Integrity

    • E.

      Macro

    Correct Answer
    B. Relationship
    Explanation
    When tables are joined, an association is created between them, which is referred to as a relationship. This relationship allows for the connection and interaction between the data in the joined tables. It enables the retrieval of related information from multiple tables based on common fields or keys. The term "relationship" accurately describes this connection between tables in a database.

    Rate this question:

  • 7. 

    What are the different types of relationships? (Choose all that apply)

    • A.

      One-to-one

    • B.

      One-to-many

    • C.

      Many-to-one

    • D.

      Many-to-many

    Correct Answer(s)
    A. One-to-one
    B. One-to-many
    D. Many-to-many
    Explanation
    The different types of relationships are categorized based on the number of entities involved. A one-to-one relationship means that each entity in one set is related to exactly one entity in another set. A one-to-many relationship means that each entity in one set can be related to multiple entities in another set. A many-to-one relationship means that multiple entities in one set can be related to a single entity in another set. A many-to-many relationship means that multiple entities in one set can be related to multiple entities in another set.

    Rate this question:

  • 8. 

    Which of the following database objects allows you to search for information and then display the result?

    • A.

      Query

    • B.

      Table

    • C.

      Report

    • D.

      Forms

    Correct Answer
    A. Query
    Explanation
    A query is a database object that allows you to search for information within a database and display the results. It enables you to specify the criteria for the search and retrieve only the data that meets those criteria. With a query, you can search for specific records, filter data based on certain conditions, and sort the results in a desired order. It provides a flexible and efficient way to retrieve and display specific information from a database.

    Rate this question:

  • 9. 

    The diagram below shows the navigation buttons on a form. What does the button x represent?

    • A.

      First Record

    • B.

      Previous Record

    • C.

      Next Record

    • D.

      Last Record

    • E.

      New Record

    Correct Answer
    E. New Record
    Explanation
    The button "x" represents the option to create a new record. This button allows the user to start entering new information into the form, adding a new entry to the database or system.

    Rate this question:

  • 10. 

     A function which causes retrieval of any kind of data from the database is considered as

    • A.

      Key

    • B.

      Query

    • C.

      Structure

    • D.

      Storing cycle

    Correct Answer
    B. Query
    Explanation
    A function that causes retrieval of any kind of data from the database is considered as a query. A query is a request for information from a database, and it is used to retrieve specific data based on certain criteria or conditions. It allows users to extract relevant data from the database by specifying what information they need and how it should be filtered or sorted. Therefore, the correct answer is query.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.