Exam 1: Access 2019

If you add Is Null as the criterion for the Advisor field in the Students table, what are the results?

The outer join is the default join operation in Access.

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Use the _____ Table Manager to manage a split database.

A report that contains a subreport is called the main report.

In Report Design view, you remove a control layout from a report using the Control Padding button.

To which one of the following fields would you most likely apply the Percent format?

Access provides four types of action queries: _____, Append, Delete, and Update.

_____ a database means to identify the database file as safe to open.

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

How do you select a row in a control layout in Report Layout view?

To use data from an Access form on a webpage, you can _____.

To quickly remove all Lookup properties from a field, change the Display Control property to _____.

Which of the following tools can you use to create a query?

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

A Make-Table query is a type of action query that creates a new table of data.

As you create a report, when might you want to work in Report Layout view?

If you often sort on a field, you should set its_____ property to Yes.

A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

Which procedure is triggered after a field is updated?