Test Your Concepts About Database And MS Access Application!

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

Query

Table

Report

Forms

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

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.

2. 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?

Employee_No

Emplyee_FirstName

Emplyee_LastName

Emplyee_Address

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

3. What will be a suitable criteria that should be entered for a query to serach for Employee Names beginning with M?

Start with M

Like M

Like "M*"

Like 'M*'

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

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.

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

Text

Date/Time

Number

Memo

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

5. Which of the following data type enables you to insert or embed the objects created in other applications into an Access Database?

OLE object

AutoNumber

Currency

Hyperlink

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

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.

6. Which of the following component contains buttons that provide easy access to the commands and functions of Access?

Title bar

Menu bar

Database toolbar

Task pane

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

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.

7. What is used when you want to temporarily change the view of a set of records?

Query

Filter

Forms

Sorting

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

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.

8. What defines the format of the data that has to be entered in a field?

Input mask

Validation rule

Caption

Format

Validation text

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

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.

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

Greater than 1/1/1950 And less than 1/1/1990

>1/1/1950 And

>=#1/1/1950 And

From 1/1/1950 to 1/1/1990

Explanation

10. The DBMS acts as an interface between what two components of an enterprise-class database system?

Database application and the database

Data and the database

The user and the database application

Database application and SQL

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.

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.