Exam 1: Access 2019

Vertical Tabs, Left is one of the _____ you can select for a Navigation form.

Access provides a single database template for creating a blank database.

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

You can use a wizard to create a _____, a formatted printout or display of the contents in tables or queries.

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

You can drag forms and reports to a navigation form to add the object to the form.

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

A(n) event is a procedure that returns a value.

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

An Append query adds selected records to an existing table.

You can use the arrow keys to move a selected control in Form Design view.

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

Besides reducing file size, what other benefit does compacting an Access database provide?

The Else portion of an If...Then...Else construct is always executed.

When using the Chart Wizard, you can choose whether to display _____ in the chart.

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

If you export a report as a PDF file, other people can edit the report.

Which action query would you use if you wanted to add records from one table to a backup table?

Which field is always on the "one" side of a one-to-many relationship between two tables?

You might delete an employee record if the employee no longer works for the company.