Database Programming
Microsoft Access is the most powerful desktop database design product to date from the Microsoft Office professional suite. This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA).
The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to programming, in particular the Visual Basic programming language.
Audience
Database developers and experienced users of Microsoft Access who wish to utilise the power of VBA. This course covers the basic programming structures such as subroutines and functions and no previous knowledge of programming is necessary.
This course is particularly beneficial for those with a sound knowledge of Access 97 or Access 2000 who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.
Skills Gained
This course will enable delegates to:
- Create powerful applications.
- Learn basic programming structures.
- Work with conditional statements and loops.
- Create custom message boxes.
- Create custom functions.
- Interact with Excel or Word.
- Write error-handling code.
- Validate user input.
Prerequisites
Delegates should be fully familiar with either Access 97 or Access 2000 and be able to create tables, queries, forms, reports, macros and relationships. These concepts are covered in Access 97 Level 3 (A2C), or course Access 2000 Level 3 (A3C). Prior knowledge of programming is not necessary.
Course Outline
Working in the Visual Basic Environment.
Sub and Function Procedures
Loops and Conditional Statements.
Objects, Properties, Methods and Events.
User Interaction.
Input Validation.
Debugging code.
Error Handling.
Integrating Access with Other Microsoft Office Applications.
