Enquiry Form

Duration: 1 Day

MICROSOFT ACCESS APPLICATION DEVELOPMENT

Objectives

To incorporate delegates existing knowledge of databases enabling them to build applications with multiple connected objects. Upon successful completion of this course, delegates will be able to design, navigate and automate a database, toolbars and menus and work with ActiveX Data Objects and ActiveX controls.

Designed for

Experienced users of Microsoft Access.

MODULE 1: WORKING WITH OBJECTS AND COLLECTIONS

• Using objects
• Discussing objects
• Modifying object properties by using the Code window
• Using object methods and events
• Examining the Object Browser
• Searching in the Object Browser
• Using collections
• Understanding collection objects
• Using the Controls collection

MODULE 2: WORKING WITH ACTIVEX DATA OBJECTS

• Getting started with ActiveX Data Objects (ADO)
• Discussing ADO
• Discussing ADO collections
• Working with ActiveX Data Objects
• Connecting to a database
• Creating and opening a Recordset object
• Navigating a recordset
• Adding a record to a recordset
• Modifying a record
• Cancelling changes to a record
• Deleting a record
• Creating a parameter query

MODULE 3: WORKING WITH ACTIVEX CONTROLS

• Getting started with ActiveX controls
• Discussing the ActiveX Windows Common Controls
• Using ActiveX controls
• Using the ActiveX ProgressBar control
• Adding a StatusBar control to a form

MODULE 4: WORKING WITH VBA DEBUGGING TOOLS

• Errors in code
• Discussing types of errors
• Using debugging techniques
• Discussing debugging tools
• Setting a breakpoint
• Adding a watch expression
• Using Step Into
• Deleting a watch expression
• Working with the Immediate window
• Using the Locals window
• Handling run-time errors
• Writing error-handling code

MODULE 5: INTEGRATING ACCESS WITH MS OFFICE

• Automating MS Office
• Introducing automation
• Setting references to object libraries
• Working with Word from Access
• Creating an Automation object
• Opening a Word document from within Access
• Creating a Word document from within Access
• Working with Excel from Access
• Opening a workbook from within Access
• Creating a workbook from within Access