Exam 8: Access

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

To relate two fields in a one-to-many relationship, you connect them using a _____.

Marie wants to move and format the report controls in the Page Footer section.To work with all the controls at the same time, she selects the controls, clicks the Size/Space button on the Arrange tab, and then clicks _____.

If you change the font size of a report control in Report _____ View, you can see the effects of the change immediately.

What information does the Form Wizard request as it creates a form? Select all the options that apply.

How do you start the Performance Analyzer?

What must you do before setting a password for a database?

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

To resize a control in Report Design view, you select the control and then _____.

Which of the following controls would you use to display a Yes/No field on a form?

What happens when you run a query from Query Design view?

Which of the following are ways you can import a CSV file into Access? Select all the options that apply.

In the _____, Access lists each object in the open database.

Which of the following options are available on the navigation bar in Print Preview of a report? Select all the options that apply.

You can set the Decimal Places property for fields with a Currency data type.

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

Madelynn enforced referential integrity on all the one-to-many relationships in the Volunteers database.Provided all data entry was completed after the relationships were established, which join type would not be needed in the database?

A check box control usually displays a "yes" or "no" answer for a field.