Exam 20: Using Microsoft Access 2010

Microsoft Access provides a default table display for entering the data.

Microsoft Access can be used to process the SQL query language.

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

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

In Access,to modify the design of a default table,one must click View and select Design View in the upper right-hand corner of the access window.

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

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

Before using any DBMS,the creators should have created a data model from the users' requirements.

To create a query,one must drag columns out of the required tables into the grid in the lower part of the query definition form.

What steps must a database designer take before using a DBMS?

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

The step after creating a relationship between two tables is ________.

Explain the procedure for establishing a relationship between two tables in Microsoft Access.

Before using a DBMS,the user should have created a(n)________.

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

Explain the procedure for creating a database using Microsoft Access.

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

Which of the following options in Microsoft Access can be used to make the data entry form more pleasing for the users?

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

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