Test Your Concepts About Database And MS Access Application!
A database is defined as a systematic collection of data which is maintained by different DBMS software such as SQL, Mongo DB, Postgre, MS Access etc. The essential purpose of database management is to store retrieve and manage the information for future access. This quiz has been created to test your knowledge about the concepts of database and MS Access application. So, let's try out the quiz. All the best!
- 1.
The most suitable validation rule that can be entered for the DOB(Date of Birth) field in a table that restricts the date from 1/1/1950 to 1/1/1990 is
- A.
Greater than 1/1/1950 And less than 1/1/1990
- B.
>1/1/1950 And
- C.
>=#1/1/1950 And
- D.
From 1/1/1950 to 1/1/1990
Correct Answer
C. >=#1/1/1950 And -
- 2.
What will be a suitable criteria that should be entered for a query to serach for Employee Names beginning with M?
- A.
Start with M
- B.
Like M
- C.
Like "M*"
- D.
Like 'M*'
Correct Answer
C. Like "M*"Explanation
The suitable criteria that should be entered for a query to search for Employee Names beginning with M is "Like 'M*'". This is because the "Like" operator is used for pattern matching and the wildcard character '%' is used to represent any sequence of characters. By using the pattern 'M*', the query will retrieve all employee names that start with the letter M.Rate this question:
-
- 3.
What defines the format of the data that has to be entered in a field?
- A.
Input mask
- B.
Validation rule
- C.
Caption
- D.
Format
- E.
Validation text
Correct Answer
A. Input maskExplanation
An input mask is used to define the format of the data that needs to be entered in a field. It specifies the allowed characters, their placement, and any special formatting requirements. By using an input mask, users are guided to enter data correctly and consistently, reducing errors and ensuring data integrity.Rate this question:
-
- 4.
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 and then display the result. It is used to retrieve specific data from one or more tables based on certain criteria. Queries can be used to filter and sort data, perform calculations, and generate reports. By specifying the desired criteria, a query helps in finding and displaying the exact information needed from the database.Rate this question:
-
- 5.
Which of the following data type should be used to enter the Employee Id in an Access database? The Employee Id field consists of alphabet and numbers.
- A.
Text
- B.
Date/Time
- C.
Number
- D.
Memo
Correct Answer
A. TextExplanation
The Employee Id field consists of both alphabets and numbers, which makes it a combination of characters. In an Access database, the data type that should be used to enter this kind of data is "Text". The Text data type allows for the storage of alphanumeric characters and is suitable for fields that contain a combination of letters, numbers, and symbols.Rate this question:
-
- 6.
Diane Frye, an HR manager wants to create a database of all the employees in the organization. Diane wants to create an employees table and in turn, wants to make one of the keys as a primary key. Which of the following fields is most suitable to be a primary key field?
- A.
Employee_No
- B.
Emplyee_FirstName
- C.
Emplyee_LastName
- D.
Emplyee_Address
Correct Answer
A. Employee_NoExplanation
The most suitable field to be a primary key in the employees table is Employee_No. A primary key is a unique identifier for each record in a table, and Employee_No seems to be a field that would have a unique value for each employee. This field can be used to uniquely identify and distinguish each employee in the database.Rate this question:
-
- 7.
Which of the following component contains buttons that provide easy access to the commands and functions of Access?
- A.
Title bar
- B.
Menu bar
- C.
Database toolbar
- D.
Task pane
Correct Answer
C. Database toolbarExplanation
The database toolbar contains buttons that provide easy access to the commands and functions of Access. This toolbar typically includes buttons for common tasks such as creating a new database, opening an existing database, saving changes, and running queries. By having these buttons readily available on the toolbar, users can quickly perform common actions without having to navigate through menus or search for specific commands.Rate this question:
-
- 8.
Which of the following data type enables you to insert or embed the objects created in other applications into an Access Database?
- A.
OLE object
- B.
AutoNumber
- C.
Currency
- D.
Hyperlink
Correct Answer
A. OLE objectExplanation
OLE object data type enables you to insert or embed the objects created in other applications into an Access Database. OLE (Object Linking and Embedding) allows you to incorporate objects such as images, documents, spreadsheets, etc., from other applications into your Access database. This enables you to have a more comprehensive and integrated database system where you can store and access various types of data within a single platform.Rate this question:
-
- 9.
What is used when you want to temporarily change the view of a set of records?
- A.
Query
- B.
Filter
- C.
Forms
- D.
Sorting
Correct Answer
B. FilterExplanation
When you want to temporarily change the view of a set of records, you can use a filter. A filter allows you to specify criteria or conditions that records must meet in order to be displayed. By applying a filter, you can narrow down the records that are shown based on specific attributes or values. This temporary change in view helps in focusing on specific data and simplifying the analysis or task at hand.Rate this question:
-
- 10.
The DBMS acts as an interface between what two components of an enterprise-class database system?
- A.
Database application and the database
- B.
Data and the database
- C.
The user and the database application
- D.
Database application and SQL
Correct Answer
A. Database application and the databaseExplanation
The DBMS acts as an interface between the database application and the database. The database application is responsible for interacting with the user and performing tasks such as data entry, retrieval, and manipulation. On the other hand, the database stores and organizes the data. The DBMS acts as a bridge between these two components, allowing the application to access and manipulate the data stored in the database efficiently and securely. It provides a set of tools and functionalities that enable the application to interact with the database effectively.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
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 21, 2008Quiz Created by
Kumar_niten
Back to top