Exam 8: Access

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

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

After you export report data to an HTML document, you can _____ the data in a browser.

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

When you single step a macro, you _____.

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which of the following are Access data types? Select all the options that apply.

What can you do when a report has blank pages in Print Preview?

What is the difference between entering a record using a form and entering a record using a datasheet?

You can create a comment by starting the statement with _____.

You can create a database by using an Access _____ or by starting with a blank database.

A report that contains a subreport is called the main report.

What types of errors occur only after you start running the code in the Visual Basic window?

How do you specify an outer join between two tables?

On a form, you use Edit view to enter, edit, and delete records.

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

When designing a startup switchboard form, which form properties should you set to "No" to prevent users from navigating among records? Select all the options that apply.

_____ means to make the data in a database unreadable by other software.

To resize the Detail section in Report Design view, you _____.