1 / 12

Access

L. L Line. Access. 2007. The L Line. The Express Line to Learning. © Wiley Publishing. 2007. All Rights Reserved. Automating Access with Macros. 11. Stations Along the Way. * Learning to automate with macros * Programming without coding * Creating a Switchboard

lethia
Download Presentation

Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. L L Line Access 2007 The L Line The Express Line to Learning © Wiley Publishing. 2007. All Rights Reserved.

  2. Automating Access with Macros 11 Stations Along the Way * Learning to automate with macros * Programming without coding * Creating a Switchboard * Using a macro group * Putting on the finishing touches

  3. Adding Macros to Your Toolkit Macros… • Help you perform repetitive tasks • Work with Access forms, reports, queries, and tables • Have a base in Visual Basic for Applications (VBA) • Automatically interface with VBA (programming savvy not required!) • Are easy to build and use

  4. Anatomy of a Macro

  5. Types of Macros Embedded: • Are part of a form or report • Often appear as command buttons Stand-alone: • Exist as independent database objects • Can be executed from a form, report, or control • Appear in the left navigation pane

  6. The Classic Switchboard • Acts as the database’s index page • Usually consists of a form with buttons • Offers user navigation to all other forms and reports • Typically opens with the database • Can contain an Exit button

  7. Building a Switchboard • Start with the Switchboard Manager under Database Tools • Add action-related buttons as Switchboard entries • Avoid too many entries on one Switchboard form • Design to separate entries by function • Edit like any other form in Layout View or Design View

  8. Embedded VersusStand-Alone Macros

  9. Multi-Step Macros • Can be embedded or stand-alone • Are single macros that perform multiple, sequential steps • Require a defined data source

  10. Macro Groups • Contain named, stand-alone macros • Save related macros in a single file • Organize macros by function or usage • Require a group plus individual naming convention Group_Name.Macro_Name

  11. Macro Finishing Touches • Close Access: Adds a professional touch • RunApp: Runs an external application from within Access • AutoExec: Automatically executes when a database opens

  12. Discussion Topics • Why should I use macros? • How do I create a Switchboard? • Can I run external applications and programs from within Access? • What’s the best type of macro to use? • What’s the difference between embedded and stand-alone macros?

More Related