Exam 1: Access-2019

_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

When you enter data in the rows of a table datasheet, you are entering _____.

A control layout in an Access report is a ____.

The term _____ describes a field value that does not exist because it has never been entered.

To have form users select one of three options, add a(n) _____ to the form.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

Which of the following templates lets you create a database from scratch?

A(n) _____ provides a template for designing a form.

The Caution action displays a warning or informational message.

What can you use to find information about Access commands and features and instructions about how to use them?

In Report Design view, you display a Number field value as a percentage using the _____ property.

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

You primarily use the Form Wizard to create a form to _____.

The _____ key field is the linking field on the "many" side of the relationship.

_____ data is scrambled so that it is indecipherable when opened by another program.

_____ are statements in the code that document the code and do not affect how it runs.

When you _____ data to a table, the column names in the Excel spreadsheet must match the field names in the Access table.

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?