Exam 1: Access-2019

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.

To decrease the decimal places in a Number field in Table Datasheet view, you can use the Decrease Decimals button.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

The outer join is the default join operation in Access.

Which of the following views provides the most options for creating and modifying a report?

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

When you enter a record in a table, you are working in navigation mode.

Which of the following Access options provides a way to set security, macro, and other privacy settings?

What Access tool helps you import a CSV file as a new Access table?

Two required tasks when creating a field are naming the field and _____.

What happens if you apply the Currency format to a Number field?

When you import Excel data, you create a link to the data in the Access database.

Clicking a command button or making an entry in a field is considered a(n) ____.

In Form view, how can you navigate to the previous record in the form?

Compacting a database rearranges the data and objects in a database to decrease its file size.

You use a(n) apostrophe to begin a comment line.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

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

Which of the following can you change when formatting a datasheet?

What happens when you run a query with the Is Null criterion in the Product Type field?