ACCESS FOR DEVELOPERS - LEVEL 1

Course Fee: $597.00
Course Time: 2 Days, 9am - 4pm

Objectives:

• Design robust relational database applications using Microsoft Access

• Develop client/server database frontends

• Build database applications quickly using Form, Table, Report and Query wizards

• Create and integrate macros into your applications

• Apply VBA programming concepts to enhance Access applications

• Protect Access databases using Access integrated security

 Course Content:

• Build a MS Access database

• Establish indexes and data relationships

• Link data among Access tables and with other programs

• Use Form and Query Wizards

• Link to and querying a SQL server database

• Create buttons to run macros

• Program with macros and VBA

• Handle Windows events

• Create preformatted and custom reports

• Secure your database

ACCESS FOR DEVELOPERS - LEVEL 2

Course Fee: $597.00
Course Time: 2 Days, 9am - 4pm

Objectives:

• Develop applications with Access using Visual Basic for Applications (VBA)

• Integrate queries, forms and VBA programming for enhanced functionality

• Manage the user interface by programming Form and Control objects

• Use Data Access Objects (DAO) and ActiveX Data Objects (ADO) for data operations

• Build dynamic applications that respond to user input

• Utilize debugging tools and error-handling code

• Integrate Access with other applications using Automation

Course Content:

• Convert a macro to VBA

• Make decisions with If...Then and Select...Case statements

• Control execution with Do...Loop and For...Next

• Create a Master-Detail form

• Use data types, variables and constants

• Build Sub and Function procedures

• Add error-handling code to procedures

• Program database objects with DAO and ADO

• Clone Access forms

• Create new objects with Class Modules