Category: Ms Access Mcqs

Correct Answer: C. Double clicking

To automatically include all of the fields in a table in a query in Microsoft Access, you can: C. Double clicking

Double-clicking on the asterisk (*) that appears in the list box in the query design view will include all the fields from the selected table in your query

Correct Answer: B. It is an input screen designed to make the viewing and entering data easier

In MS Access, a form is: B. It is an input screen designed to make the viewing and entering data easier

Forms are used to create a user-friendly interface for data entry and navigation. They allow users to input, modify, and view data in a structured and visually appealing way, making interaction with the database more intuitive

Correct Answer: C. Fields

In a Microsoft Access table, the columns are called: C. Fields

Fields represent the individual pieces of data stored for each record in the table. Each field has a specific datatype and can contain different kinds of data, such as text, numbers, dates, etc.

Correct Answer: C. Wild card character

When performing searches in databases or query design windows, a search value is used to match specific data within the database. This search value can be an exact value, such as a specific number or text string. Alternatively, it can use a wild card character to allow for more flexible searches.

Correct Answer: B. 64 

In Microsoft Access, when creating tables or queries, you typically define field names to represent various attributes of your data. These field names can have a maximum length, which is 64 characters. This limit includes any characters you type in, including letters, numbers, and special characters. Therefore, the correct answer is B. 64.

Correct Answer: D. All of these

The correct answer is D. All of the above.

In Microsoft Access, you can create queries using multiple methods:

A. You can drag and drop fields onto the query design grid in Query Design View. B. You can directly type SQL commands in SQL View to create custom queries. C. You can use the Query Wizard, which provides a step-by-step interface for creating queries based on specific criteria or templates.

So, all of the options (A, B, and C) are valid methods for creating queries in Access

Correct Answer: B. File

The correct answer is B. File.

A file in a database typically stores complete information about an entity such as an employee, sales, orders, etc. It contains records, which are collections of fields that represent individual pieces of data related to the entity. So, while a “record” refers to a collection of related data fields, a “file” is the part of the database that holds these records.

Correct Answer: D. All of these

In Microsoft Access, the OLE (Object Linking and Embedding) objects data type can indeed store:
D. All of these
The OLE objects data type in MS Access allows you to store various types of binary data, including Microsoft Excel spreadsheets, Microsoft Word documents, sounds, images, and more. This versatility enables users to incorporate different types of files or multimedia content directly into their Access databases.

Correct Answer: A. Fields

The columns in a Microsoft Access table are called:
A. Fields
In Microsoft Access, a field represents a specific piece of data within a table. Each field is assigned a unique name and data type, and it corresponds to a column in the table. Fields define the structure and characteristics of the data stored in the table.

Correct Answer: D. Datasheet

The form that displays multiple records, one per row, in the form window is typically referred to as:
D. Datasheet
A datasheet form layout is common in database applications, where each row represents a record and each column represents a field or attribute of that record. It provides a tabular view of the data, allowing users to easily navigate, view, and edit multiple records at once.