Mastering Access Programming

This Course aims to provide Professional approach to the fresher in the field of database technology and programming. Just knowing the syntax and database application is not sufficient enough for creating industry standard application. Thus the course focuses on system analysis, design and data modeling, which is an integral part of software development cycle.

Course Outline

• System Analysis and System Design
• Programming concepts
• Overview of a Microsoft Access application
• Controlling program flow
• Scope and lifetime of variables, constants and procedures
• Working with forms
• Using the DoCmd object, Run command
• Overview of data validation
• Arrays
• Advance procedures
• Standard Functions
• Handling Run-Time Errors
• Looping Through Code
• Database programming using DAO
• ActiveX Controls
• DAP and Scripting
• Replication
• Security
• Menu and Toolbar
• Distributing Access Applications