Exam 18: Using Microsoft Access 2016

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

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

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

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

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

In Microsoft Access, relationships can be defined by selecting the Database Tools tab.

Which of the following statements is TRUE of reports in Microsoft Access?

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

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

Microsoft Access opens a new database by creating a ________.

In Microsoft Access, one must select the relationships option in the Design tab to modify the design of a default table.

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

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

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

In Microsoft Access, a user has to define the relationship between two tables before creating them.

In Access, there are several ways to create a data entry form.

How can a user generate reports in Microsoft Access?

Jane is performing a monthly check on her company's database. She finds records of a number of employees who are no longer working with the company and whose details need to be deleted. To delete the records, Jane would have to select the Records section in the ________ tab.

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

How does one run in query in Access?