Exam 8: Access

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

To resize a control in Report Layout view, you format an edge of the selected control.

Which of the following types of objects can you import into an Access database from another Access database? Select all the options that apply. A) tables B) reports C) forms D) queries

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

How do you rename a table?

You click the _____ button to execute the selected Access macro.

Which of the following statements apply to Long Text fields? Select all the options that apply.

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

Which of the following is an appropriate entry for the Hyperlink Address property of a form control?

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

Which of the following clauses can an If statement contain in a macro?

When building an action query, you do not change data until you click the _____ button.

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

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

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

Query for zero-length values by entering Is Null as the criterion.

An advantage of emailing query results as a PDF file is that _____.