Exam 18: Using Microsoft Access 2013

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

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

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

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

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

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.

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

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

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

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

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.

In Microsoft Access reports,the Grouping & Totals section contains the options to display totals in a report.

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

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

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

To delete a record in Microsoft Access,a user has to select the Records section in the ________ tab.

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

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

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

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