Question 1

Access opens a new database by creating a default table named Table A.

Accepted Answer

When Access opens a new database, it creates a default table named "Table1," not "Table A."

Question 2

In Microsoft Access,a user has to define the relationships between tables before creating the tables.

Accepted Answer

In Microsoft Access, a user can create tables without defining relationships between them. However, it is recommended to define relationships for data consistency and to avoid data duplication.

Question 3

Before using any DBMS,a user should create a data model based on the users' requirements.

Accepted Answer

It is important to create a data model before using any DBMS to ensure that the data is organized and structured in a way that meets the user's requirements. This helps to ensure that the data can be easily accessed, stored, and managed.

Question 4

Every field in Microsoft Access must have a Description associated with it.

Accepted Answer

It is not mandatory for every field in Microsoft Access to have a description associated with it, although it is recommended for better documentation and understanding of the data stored in the field.

Question 5

In Microsoft Access,the option to generate a data entry form is present in the CREATE ribbon.

Accepted Answer

The option to generate a data entry form is present in the CREATE ribbon in Microsoft Access.

Question 6

To create a query in Microsoft Access,one must drag columns out of the required tables into the grid in the lower part of the query definition form.

Accepted Answer

This is the basic process to create a query in Access.

Question 7

Microsoft Access can be used to create and process queries: However,it does not provide a graphical interface for the queries.

Accepted Answer

Microsoft Access actually does provide a graphical interface for creating and processing queries. This interface allows users to select tables and fields, apply filters and criteria, and view results in a variety of formats.

Question 8

In Access,"Integer" is a valid entry for Field Size if the Data Type is "Text."

Accepted Answer

"Integer" is not a valid entry for Field Size if the Data Type is "Text." Field Size options for text data types include "Byte," "Char," "Long Text," etc.

Question 9

In Microsoft Access,relationships can be defined by selecting the DATABASE TOOLS tab.

Accepted Answer

In Microsoft Access, you can define relationships between tables by selecting the DATABASE TOOLS tab and using the Relationships feature.

Question 10

In Access,an underlined attribute is a primary key and an italicized attribute is a foreign key.

Accepted Answer

This is correct. Primary keys are typically underlined in Access to indicate their unique values, while foreign keys are typically italicized to indicate that they refer to a primary key in another table.

Question 11

Microsoft Access can process SQL.

Accepted Answer

Microsoft Access can use SQL to create queries, insert or update data in tables, and perform other database operations.

Question 12

The Description field in Microsoft Access is used mainly for documentation.

Accepted Answer

The Description field in Microsoft Access is used to provide additional details and comments about a specific object, such as a table, query, form or report. This information can be helpful for users to understand the purpose and function of the object, especially in complex databases with multiple objects.

Question 13

Unlike Microsoft Excel,users cannot key in data into Microsoft Access cells.

Accepted Answer

In Microsoft Access, users can input data directly into fields within tables, similar to entering data into cells in Excel.

Question 14

To create a report with data from a single table,we must use the Report Wizard.

Accepted Answer

The Report Wizard is a tool that assists in creating reports, but it is not mandatory to use it. Reports can also be created manually or using other tools.

Question 15

Microsoft Access provides a default table display for creating a data entry form.

Accepted Answer

Microsoft Access provides a default table display for creating a data entry form, which can be customized to suit specific needs.

Question 16

In Access,a surrogate key has no meaning to the user.

Accepted Answer

A surrogate key is a unique identifier that is generated by the system to provide a primary key for a table. It has no meaning to the user and is used solely for database management purposes.

Question 17

To create a relationship between one row of a table and an unlimited number of rows in another table using Access,users must drag the foreign key in one table to the primary key in another table to create a relationship.

Accepted Answer

The answer of To create a relationship between one row...

Question 18

In Access,to modify the design of a default table,one must select the Relationships option in the DESIGN tab.

Accepted Answer

To modify the design of a default table in Access, one must select the Table Design option in the CREATE tab. The Relationships option is used to create and manage relationships between tables.

Question 19

By default,for queries of two or more tables,Access shows only those rows that have value matches in both tables.

Accepted Answer

This statement is true. Access only shows rows that have matching values in both tables by default when querying multiple tables. However, you can change this behavior by using different types of joins to include rows with no matching values or different subsets of the data.

Question 20

Any text entered as the Description of a field is displayed as help text on forms.

Accepted Answer

The description of a field is displayed as help text on forms.

Quiz 18: Using Microsoft Access 2013