Exam 18: Using Microsoft Access 2013

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

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?

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

Which of the following statements is true about a primary key in Microsoft Access?

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

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

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.

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.

Microsoft Access opens a new database by creating a ________.

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

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

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

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

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law.Which of the following tools will help Leonard create his report?

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

All relational database management system (DBMS)products can process the ________ query language.

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

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

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

In Microsoft Access, a report is created using a process similar to that for forms.