This course focuses on the use of macros and the ability to import and export data between Microsoft Access 2007 and other programs.
Objectives:
View macro events and actions
Create embedded macros
Import and link data from Excel
Import text data
Export Access data
Import and export XML data
Topics:
Introducing macros and events
Generating embedded macros
Importing and linking Excel data
Importing text files
Exporting data from Access
Importing XML data
Exporting tables and queries to XML
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.