Values in an AutoNumber field are automatically created by Access.

The question mark (?) is the wildcard character which stands for any single character in criteria.

“Focus” refers to which data you would edit if you started typing.

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

The wildcard character that stands for any group of characters is the ____.

Which of the following comparison operators means "not equal to"?

Which is NOT a feature of Access reports?

Which of the following is NOT a data type?

Which shortcut key moves focus to the first field of the current record?

SQL stands for ____.

Use the ____ command to save the current object with a new name.

Which shortcut key moves focus to the previous field of the current record?

Access saves ____ automatically as you move from record to record.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

____ will find all records where there is any entry in the field, even if the entry is 0.

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

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

A query datasheet is sometimes called a ____ of the data.

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Which is NOT true about Access?

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Which keystroke combination moves focus to the last field of the last record?

The wildcard character that stands for any single character is the ____.

Which of the following keys will help you delete unwanted data in Edit mode?

An) ____ is a temporary view of the data that is removed when you close the datasheet.

Which data type is used for sequential integers controlled by Access?

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Which of the following comparison operators means "less than or equal to"?

Query Design View presents the fields you can use for a query in small windows called field ____.

A(n) ____ is a saved object within the datasheet.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Which data type stores only one of two values?

If the Navigation Pane is not open, click the _____ to open it and view the database objects.​

Each object in an Access database application displays at the left side of the Access window in the ____.

Which of the following comparison operators means "greater than"?

Which data type links files created in other programs such as pictures or documents?

Microsoft Access 2016 can best be described as ____ software.

Which Access object provides an easy-to-use data entry screen?

To sort records based on the selected field in the order Z to A, use the _____ button.​

Which two properties are required for every field?

While editing a record, pressing [Esc] a second time ____.

Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel lives in Oxford and he would like to find all customers who do not live in Oxford. Which comparison operator should he use?​

A join line is also called a(n) ____ line.

When you double-click a field in a field list in Query Design View, it is ____.

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

To move a field in the query design grid, click its ____, and then drag it left or right.

Which Access object contains all of the raw data within the database?

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

Tables, queries, and forms are examples of Access ____.

____ View provides the most options for defining fields.

Which editing keystroke deletes one character to the right of the insertion point?

To find numbers greater than or equal to 500, use which comparison operator?

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Criteria ____ is the term for rules by which criteria must be entered in a query.

Which data type stores Web addresses?

Which of the following is NOT available to you as you start Access?