Exam 1: Access-2019

Which of the following controls would you add to a form to print the current record?

Use a(n) If statement to document a macro with explanatory text.

After you create a table, you must save the entire database so you do not lose the new table.

To delete the Discount column from the query grid in Query Design view, click the Discount field in the field list and then press DEL.

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

Which of the following events would trigger a data macro?

The Alternate Background Color command changes the background color of alternate records in a selected section.

To relate two tables in a one-to-many relationship, you connect them using a common field.

The programming language used in Access modules is called Visual Basic for _____.

A function created in a standard module can be used in any query in the database.

If you edit data in the upper half of a split form, you must make the same changes in the lower half.

Set the Database Title property of a database to change the text displayed in the title bar.

If you select 25 in the Top Values list, Access displays _____ in the query results.

At what point does Access save the data in a database?

When can you rename a table?

What data type is most appropriate for a field named PaymentAmt?

Which data type stores email addresses?

An Access template is a diagram showing the structure of a database.

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

You use the _____ to create a query that finds records in one table that do not have related records in another table.