Exam 18: Using Microsoft Access 2013

How can a user generate reports in Microsoft Access?

Unlike Microsoft Excel,users cannot key in data into Microsoft Access cells.

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

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

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.

Before using any DBMS,a user should create a data model based on the users' requirements.

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

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

Microsoft Access can process SQL.

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

Which of the following is a valid entry for Field Size if the Data Type of the field is "Number"?

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

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

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

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

In Access,to modify the design of a default table,one must select the Relationships option in the DESIGN tab.

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

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

Which of the following statements is true about reports in Access?

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