Exam 8: Access

An Append query adds selected records to an existing table.

Use the Number data type for fields that store postal codes.

You can use the _____ to copy data from Excel to Access.

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

When does the Visual Basic Editor display text in red?

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

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

You can add one or more _____ to a tab control.

Which of the following are tasks you perform when creating tables? Select all the options that apply.

You set the opening Display Form for a database using the Access Preferences dialog box.

A(n) _____ is an image that fills the entire form, appearing "behind" the other controls.

How can you quickly add the date and time to a report in Report Design view?

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?

Which of the following views should you use to modify the size, position, and formatting of report controls while displaying live data?

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

To add a subform to a form in Form Design view, you use the Subform/Subreport control.

How can you display the title of a report in green?

Which of the following formatting enhancements do themes apply to reports? Select all the options that apply.

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

To remove retired employees from an Employee table, create a(n) _____ query.