Basic Database And MS Access Concepts Quiz!
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!
- 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. QueriesExplanation
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 -> CloseExplanation
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 -> ExitExplanation
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 MaskExplanation
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 tableExplanation
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. RelationshipExplanation
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-manyExplanation
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. QueryExplanation
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 RecordExplanation
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. QueryExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 13, 2024Quiz Edited by
ProProfs Editorial Team -
Jun 09, 2008Quiz Created by
Kumar_niten
Back to top