Exam 1: Access 2019

If users must enter data in a LastName field, what property should you set for the field?

To modify the number of items displayed in a combo box, use the List Rows property.

Access creates fields with _____ properties as combo boxes on new forms.

Access adds # signs around text criteria in Date/Time fields.

You select a control layout so that you can move or change the controls as a group.

When you click the Application Parts button on the Create tab and then click Issues, you create a new database named Issues.

What should you do before applying a new filter to a datasheet?

Report Design View gives you full control of all aspects of a report.

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

A subdatasheet shows the records on the " one " side of a one-to-many relationship.

In a datasheet, which mode do you use for changing the value of a field?

Press ESC to remove editing changes you made to the previous record.

Sylvia wants to align the right edges of the labels on a form. After selecting the controls in Form Design view, what should she do?

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

After you create a table, you must save the entire database so you do not lose the new table.

To change the fonts in all the forms and reports in the database, you can change the _____.

A control layout in an Access report is a ____.

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