Exam 1: Access-2019

You use the Report Wizard to guide you through the steps of creating a report.

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

You can select a particular form, such as a Navigation form, to display when Access starts.

You select a control layout so that you can move or change the controls as a group.

The _____ refers to the data you would edit if you started typing.

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

If you set the _____ property for a field that is often used for sorting, you improve database performance.

To add VBA code to a macro embedded in a report, you can first _____ the macro to VBA code.

To display the data in a table, you open the table in Table Design view.

The Allow Value List Edits property determines whether users can change the items in a lookup list.

If you want to add records from one table to a backup table, create a(n) Append query.

An Access chart displays data in rows and columns, similar to a spreadsheet.

To add a heading to the Detail section of a form, you use a text box control.

What must you do before setting a database password?

Microsoft Access can best be described as ____ software.

What must you do before setting a password for a database?

To query for records with no values in a particular field, use _____ as the criterion.

To learn about the new features in Access, you can use the Tell Me box.

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

Which of the following commands aligns text in the center of a label control?