Exam 11: Enhanced Database Techniques

Table validation rules can only work with one field.

Which of the following is not true about macros which have been converted to VBA?

Match the following terms with their descriptions: I. SQL II. Stand-alone macro III. Macro IV. Argument V. Event A. Developed by IBM in the early 70s B. The MessageBox action has four of these C. Is displayed on the Navigation Pane D. Occurs when a user enters, edits, or deletes data E. Automated series of actions

A(n) ________ is a variable, constant, or expression that is used to produce the output for an action.

When was SQL developed?

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

What was developed to make it easier to create or modify macros?

When business logic requires the comparison of two or more fields, you need to use a(n) ________ macro.

Data macros, like stand-alone macros and embedded macros, use the Macro Designer.

Which type of macro executes when an event attached to a control or object occurs?

You can use the ________ Button Wizard to create an embedded macro automatically.

Access creates macros automatically when you add certain controls to forms or reports.

What type of macros associate programming logic to tables?

Standalone macros are listed in the Navigation Pane.

The keyword used in SQL to establish criteria is ________.

Event-driven data macros are triggered by what events?

Match the following terms with their descriptions: I. Event II. Macro III. Macro Designer IV. Embedded macro V. Data macro A. Used to automate tasks B. Executes when an event is triggered C. Triggered by table events D. User interface for working with macros E. Occurs when users open, use, or close forms and reports

What defines the purpose and the structure of an SQL statement?

What company developed SQL?

Match the following terms with their descriptions: I. SELECT keyword II. WHERE keyword III. ORDER BY keyword IV. FROM keyword V. SQL keyword A. Determines any criteria that will be applied to records in an SQL statement B. Determines the table or tables which will supply the fields used in an SQL statement C. Determines the sort order in an SQL statement D. Determines which fields will be included in an SQL statement E. Defines the purpose and structure of an SQL statement