FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Access 2019

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 221

Multiple Choice

Review LaterAdd Note

Review Later

What would you use to quickly create an Issues table and related forms?

A) a Custom Table
B) a Quick Part
C) an Application Part
D) an Outlook task

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 222

Multiple Choice

Review LaterAdd Note

Review Later

What could you do to clarify that the TaxRate field in a report contains percentages?

A) Apply the Percent format to the field.
B) Decrease the decimal places displayed in the field.
C) Apply the Currency format to the field.
D) Change the Special Effect property of the field.

E) A) and B)
F) B) and C)

Correct Answer

verified

Show Answer

Question 223

True/False

Review LaterAdd Note

You can create a mail merge in Word using name and address data stored in Access.

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Class modules are stored in an individual form or report.

You switch to Report Layout view to display the entire report as it will appear when printed.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

You can create a table in Table Datasheet view or Table Design view.

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

When you add fields to a table in Table Design view, the _____ is optional.

To remove scroll bars on small forms, set the Scroll Bars property to As Needed.

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

Trusting a database means to verify the authenticity of a database with a digital signature.

A query is a temporary view of the data that is removed when you close the query in Query Design view.

In what part of the Access window do you rename a form?

When you _____ a database, you make more storage space available and enhance the performance of the database.

Before you can rename a field, you must change its data type.

One reason to split a database is to improve performance .

You can collapse all actions in a macro to hide its details.