Exam 18: Using Microsoft Access 2016

Kathy wants to show a summary of all of the sales for the region at the bottom of the report. How does she get started?

Microsoft Access can process SQL.

Russell works on two tables in Microsoft Access. One is for contractual employees, whereas, the other is for permanent employees. He creates a relationship between the two tables. Which of the following steps should Russell take next?

Which of the following is a valid entry for field size if the data type of the field is Number?

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

Explain the procedure for creating a new database using Microsoft Access.

In Microsoft Access, different attributes are referred to as ________.

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

Which of the following is the first activity to be performed while creating a database using Microsoft Access?

Explain the different alternatives provided by Microsoft Access for creating data entry forms.

The option to create reports can be found in the Database Tools tab of Microsoft Access.

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

Before using any database management system (DBMS), a user should create a data model based on users' requirements.

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

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

Which of the following statements is TRUE about queries in Microsoft Access?