Exam 1: Access-2019

To remove scroll bars on small forms, set the Scroll Bars property to As Needed.

Hiding a column in Table Datasheet view is that same as freezing the column.

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

You can add fields to a form in Design view or _____.

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

If you create a blank form, you must set the _____ property to display data on the form.

The first step in the Form Wizard is to _____.

In Report Design view, you remove a control layout from a report using the Control Padding button.

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

In a datasheet, you can find data, but not replace it.

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

On a form, text box controls display data from an underlying record source.

How do you rename a table?

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

Use the _____ Table Manager to manage a split database.

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

When you split an Access database, how many copies of the back-end database do you have?

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.