Exam 1: Access 2019

ToWhat tool do you use to set the sort orders for records in a report?

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

To format a number with a dollar sign ($) as in $50.99, use the Standard format.

If you export form data as a(n) _____ file, you can view the data but not change it.

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

The edit record symbol (a pencil icon) appears to the left of a table record when you are selecting the record.

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

Heather set the Required property for the GameDate field in the Soccer database, which means users must enter the date with a proper date format, such as June 20, 2021.

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

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with " New Macro."

You can select a particular form, such as a Navigation form, to display when Access starts.

A(n) _____ is an individual step that a macro performs.

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

Which common technique is used to fit more columns of data across a report?

The _____ key field is the linking field on the "many" side of the relationship.

What happens if you delete a field from a table that contains data?

Use a Number field to store values that represent money.

To modify the number of items displayed in a combo box list, you use the ____ property.

You can create an Access report by selecting fields from one or more tables or _____.