Exam 8: Access

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

Query Design view presents the fields you can use for a query in small windows called field _____.

When you export table data to a PDF file, you need software such as _____ to view the data.

What is the main purpose of a form?

The Display Control property of a _____ field is set to Combo Box by default.

_____ view provides the most options for defining fields.

To rename a field in Table Datasheet view, you change the text in the _____.

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

What could you use to display the amount of a 25% discount on a form?

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

You can create a table in Table Datasheet view or Table Design view.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

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

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

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

Which built-in Access function returns today's date?

To navigate to the first record in a form, first switch to Form Design view.

When you add a Yes/No field in Report Design view, what control(s) does Access typically add to the report?

What property would you use in an If statement to display a label in some records but not others?

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.