Exam 18: Using Microsoft Access 2013

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.

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

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

To delete data in Microsoft Access, a user should double-click the table name in the left hand pane.

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

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

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

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.

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

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

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?

How can a user generate reports in Microsoft Access?

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

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

Microsoft Access can process SQL.

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

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

Which of the following tabs in Microsoft Access is used to generate reports?