Access school training courses in Baltimore, MD (public, in-house or online)

Examine basic database concepts and create and modify databases and their various objects using the Access 2007 relational database application. Prerequisite: Windows Intro or equivalent knowledge.

Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. Prerequisite: Access 2007 Intermediate or equivalent knowledge.

Go beyond using the built-in features offered by Access and develop your own applications. Plan an application from the ground up, and make use of advanced form design, macros, and dialog boxes. Also create switchboards, splash screens, custom menu forms, and navigation groups. Prerequisite: Access 2007 Advanced or equivalent knowledge.

Designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Prerequisite: Access 2007 Application Development or equivalent knowledge.

You Will Learn How To

Develop distributable applications with Microsoft Access
Incorporate design requirements to enhance application functionality
Customize applications by dynamically setting properties and executing methods
Assemble expressions into VBA statements using variables and intrinsic functions
Control program flow with loops and decision-making logic
Programmatically control data access to incorporate business rules

Course Benefits

Microsoft...

Full archival course description>>