Exam 1: Access-2019

(999)000-000;1;_ would be a possible entry for which field property?

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

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

When you import data from Excel, you can create a new table or add the records to an existing table.

In Form Layout view, you can edit the text in a _____ without changing any data.

To remove retired employees from an Employee table, create a(n) _____ query.

A new blank desktop database includes one table named Table1.

How do you enter a value in a lookup field in Table Datasheet view?

Of all the database objects, a table provides the most formatting, layout, and summary options.

What happens if you write VBA code in all lowercase letters?

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

A common place to use the Input Mask property is for a FirstName field.

When does the Visual Basic Editor display text in red?

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

How can you reorder the navigation buttons in a navigation form in Form Layout view?

A macro may contain one or more _____, the tasks that you want Access to perform.

Which of the following is the SQL keyword to identify tables containing the field(s) you are selecting?

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

In VBA, comments appear in _____ text.

When a module is embedded in a form or report, it is called a(n) _____.