Exam 8: Access

You can add a line to a report to indicate a subtotal.

_____ is the default name for a new table in an Access database.

_____ connects an Access database to data in an external file such as an Outlook folder.

Set the _____ Form startup option to specify which form opens when the database opens.

A form ____ is the general way that the data and controls are arranged on the form.

To add a sort to a report in Report Design view, you use the _____ button

How can you identify a linked table in a database?

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

Which of the following are properties you can set for a Currency field? Select all the options that apply.

Which of the following are ways to help secure an Access database? Select all the options that apply.

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

At what point does Access save the data in a database?

In Access, you create a macro by recording a series of steps you want the macro to perform.

Which of the following are ways to add records to an existing table? Select all the options that apply.

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

_____ is a standardized language that all major relational database software uses.

Before you can rename a field, you must change its data type.

Which of the following techniques can you use to resize a selected control in Report Design view? Select all the options that apply.

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

The On Current event of a form is triggered when you navigate through records.