Microsoft Access | MCQs

Explanation

Microsoft Access (MS Access) organizes data in tables, which are the fundamental building blocks of any database: 

Data organization: Stores data in tables with rows and columns

Data types: Supports various data types, such as text, number, date/time, currency, and more

*************

VU CBT FIA PAPER 26-12-2021

Explanation

A Form in Microsoft Access is used to enter, view, and edit data in a user-friendly and customized layout.

It provides a more controlled and organized way to interact with the database than using tables directly.

Explanation

Forms in MS Access provide a user-friendly interface for easy data entry and editing in tables.

They simplify interacting with table data without directly working in the table view.

Explanation

Explanation

 The MS Access report object is primarily used to display and print formatted data from tables or queries in an organized and visually appealing manner.

It's not used for data entry or editing like forms.

Explanation

You create such a relationship by defining a third table that is called a junction table. 

Explanation

MS Access, the "Format Painter" tool is used to copy the formatting of one control and apply it to another.

This helps maintain consistency in the design of forms and reports.

Explanation

A primary key is a field or set of fields with values that are unique throughout a table.

Values of the key can be used to refer to entire records, because each record has a different value for the key.

Each table can only have one primary key.

Explanation

• In Microsoft Access, pressing SHIFT+F10 is used to Display the shortcut menu.
• The shortcut menu, also known as the context menu, is a menu that provides options related to the selected object or area.
• It typically contains commands that are relevant to the current context, allowing you to perform various actions without navigating through multiple menus.

Explanation

In MS Access, columns in a table are called fields.

It store specific types of data for each record.

Rows in an MS Access table are called Records.

It representing individual entries or data points within the table.