FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 18: Using Microsoft Access 2016

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following statements is TRUE about a primary key in Microsoft Access?

A) Only one field in a table can be marked as the primary key.
B) The attribute which is italicized is the primary key.
C) A primary key should have its Required Field property set to No.
D) A foreign key can be used as one of the fields for a primary key.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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

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

It is difficult to make a data entry form more pleasing and easier to use.

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

In Access, what is the next step after the tables are created?

How can one identify a primary key in a data model?

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.

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

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

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

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law. Which of the following tools will help Leonard create his report?

A table should have multiple primary keys.

Access does not remember relationships between tables.

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

Ramona works for City Hospital. She wants to fill in details of the hospital staff into the database, but she does not want to use the default table display. She prefers a design that would be easier to use and view. Which of the following options would suit Ramona's requirements?