Back to Courses MICROSOFT ACCESS

Access Data Access Objects

• Creating Recordsets
• Sorting and Filtering Records
• Moving through a Recordset
• Marking positions with bookmarks
• Microsoft Jet Transactions

Advanced Form and Report Design
Using VBA

• Programming Combo boxes
• Programming Command Buttons
• Calculations
• Creating and editing SQL

Interaction with Other Office Applications

• Using Access to analyse external data
• Passing Access data to Excel
• Passing Access data to Word
  VISUAL BASIC FOR APPLICATIONS
  Duration - 2 Days
Print this page  
To attend this course students should have completed the Office Development course and an Advanced Access course.

Access Security Issues

• User-level security wizard
• MDW Files
• Groups and users
• Setting permissions

Access Macros V Vba Code

• Why use Macros
• Why use VBA

Event Driven Programming

• What are events
• Event-driven v Traditional programming