Briefly explain how to embed submacros, subforms, subqueries, and subreports in macro, form, query, and report Access objects.

What will be an ideal response?


Student answers will vary but should include the information below in some form.
Use the Macro Designer to add a submacro as a new action to an existing macro.  Add a subform to an existing form in Design view using the wizard or drag the subform to the main form. To embed a subquery in an existing query, view the SQL code from SQL view for the subquery and paste it in the SQL statement for the main query. Use the subreport wizard in Design view for the main report or drag the subreport to the main report.

Computer Science & Information Technology

You might also like to view...

Which of the following is evaluated first, given the expression:

A && B || C && !D a. A && B b. B || C c. C && !D d. !D

Computer Science & Information Technology

Eight bits together form a(n) _____.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

During document proofreading, the suggestion to insert an apostrophe to indicate possessive use would appear in the ________

A) Ribbon B) Proofing pane C) Margin D) Grammar pane

Computer Science & Information Technology

A hard drive or solid state drive that is physically installed inside of a workstation would generally be considered to be what type of storage?

A. Local storage B. Direct-Attached Storage C. Network Attached Storage D. Storage Area Network

Computer Science & Information Technology