Exam 1: Access 2019

Which of the following security methods makes data indecipherable to other programs when sent across a network?

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

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

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

What happens when you run a query from Query Design view?

Access sets the number of decimal places in a Number field, and you cannot change it.

Which startup command-line option opens the database for exclusive access?

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

You use a(n) apostrophe to begin a comment line.

Two required tasks when creating a field are naming the field and _____.

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

When does the Visual Basic Editor display text in red?

Changing the _____ property for a field does not change the actual data stored in the field.

Which of the following is a startup command-line option?

The chart type that uses slices to show parts of a whole is a _____ chart.

When you add a field to a form in Form Layout view, Access creates a text box but not a label.

In Form Design view, you can align controls and their contents.

On Click is an example of a(n) _____.