Test Your Concepts About Database And MS Access Application!

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.

Explanation
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.

Explanation
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.

Explanation
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.

Explanation
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.

Explanation
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.

Explanation
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.

Explanation
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.

Explanation
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.