Exam 17: Using Microsoft Access 2010

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

In Access,records can be deleted by clicking the down arrow next to Delete and selecting Delete Record,which is present in the Records section of the ________ tab.

How can a user generate reports in Microsoft Access?

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.

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

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

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

In Access,to create a relationship between two tables,users must ________.

The description field in Microsoft Access is used mainly for documentation.

In Microsoft Access,users must drag the foreign key in one table to the primary key in another table to enforce a relationship.

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

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

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

All modern DBMS products can process the ________ query language.

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

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

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

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

To create a report with data from two or more tables,we must use the ________.

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