MICROSOFT ACCESS ADVANCED COURSE OVERVIEW

Course Objectives

A 2 Day Database Programming Course, aimed at users that have been on the previous stages; this course aims to give users further knowledge and tools to create and manipulate Access databases. By the end of the two days, users will be able to create user-friendly forms using macros and code. The databases created, will be easy enough for someone to use with no Access experience, however, the developer will have a difficult task creating these user-friendly databases.

Course Content

Quick Refresh on previous stages

Macros:

    • Refresh
    • Requery
    • Max
    • Min
    • Setvalue
    • Open
    • Runcommand

Macro names

Macro group files

SQL Programming

Referring to a macro in a group file

Conditional macros – If Statements

Event Driven Programming – making
forms come to life

Understanding common control events
and triggers

Understanding form events

Creating common form events

A workshop – problem solving

Differences between a macro and Visual
Basic code ( VBA )

Advanced queries and reports

Saving MDE format

Search forms

Security

AJ Training Access Developers advanced tips
and tricks