Exam 18: Using Microsoft Access 2013

In Access,after creating a relationship between two tables,the user cannot and need not assign values for the ________.

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

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

Before using a DBMS,a user should create a(n)________.

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

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

In Microsoft Access reports,the Grouping & Totals section contains the options to display totals in a report.

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

Which of the following is one of the alternatives for creating a data entry form in Microsoft Access?

What steps must a database designer take before creating a database with Access?

All modern DBMS products can process the ________ query language.

In Access,to create a relationship between one row of a table and an unlimited number of rows in another table,users should ________.

Relationships can be defined in Microsoft Access by selecting the ________ tab in the ribbon.

In Access,the step after creating a relationship between two tables is ________.

Microsoft Access can process SQL.

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.

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

In Microsoft Access,the Description of fields is used to ________.

Which of the following statements is true about naming a new database in Microsoft Access?

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