Requirements:
It is essential to have a good working knowledge of Windows, the Access interface, table creation, basic query, and report writing functions, macro development, and relational database concepts gained from practical experience or by prior attendance on Level 2 Access User programme.
Course objectives:
-Identify components of and plan an application
-Automate the application interface, automate dialogue boxes, use Visual Basic for Applications (VBA) code elements, and automate navigation across forms
-Create switchboard forms and create and automate splash screen forms
-Create macro groups, custom toolbars, menu bars, shortcut menus, and set the start up properties for toolbars and menus
-Use different VBA programming elements, work with modules, and create procedures in modules
-Use control and loop structures in VBA code, handle events by automating controls on forms, trap and resolve errors in code, add web browser controls to forms, and work with MDE files
Course content:
Designing an application
-Examining an application
-Examining the components and identifying the objectives and resolving design issues in an application
-Planning application objects
Automating forms
-Working with dialogue boxes
-Examining the properties of a dialogue box
-Examining the properties of controls on a dialogue box
-Working with, examining and creating a macro group
-Attaching a macro group to command buttons
-Automating navigation across forms
-Discussing VBA
-Examining the VBE windo- and command button code
-Programming a button on a form to open another form
-Disabling and enabling command buttons
Working with switchboard and splash screen forms
-Working with switchboard forms
-Creating a switchboard form by using the switchboard manager
-Testing switchboard objects
-Modifying a switchboard form
-Working, observing and creating a splash screen form
-Setting label properties
-Setting the properties of a splash screen form
-Automating splash screen forms
-Displaying the splash screen form on database start-up and for a specified time
-Opening a switchboard form automatically after the splash screen form
Creating custom toolbars and menu bars
-Working with toolbars
-Creating a macro group to sho- or hide a toolbar
-Replacing the built-in toolbar with a custom toolbar
-Adding buttons to a custom toolbar
-Creating custom and shortcut menusCreating custom toolbars and menu bars (cont.)
-Examining, creating and adding commands to a custom menu bar
-Creating a custom shortcut menu
- Setting start up properties for toolbars, menus, and Access special keys
Working with VBA code
-Discussing VBA programming elements and data types
-Using variables and constants
-Working with modules
-Examining the code windo- and VBA code
-Creating procedures
-Creating a sub procedure in a standard module
-Calling a sub procedure
-Creating a function procedure in a standard module
-Calling a function procedure
Advanced VBA programming
-Using control structures
-Using the IF statements
-Using the For...Next and Do While... loops
-Handling events
-Assigning event handling code to a text box, combo box and to coordinate events across two forms
-Assigning the OnUndo and assigning the Unload event procedure for a form
-Resolving errors
-Adding and testing an error-handling code
-Displaying a web site
-Adding a web browser control and displaying a web site on the form
-Working with and creating an MDE file
Revie- of Programme
Other Recommended Programmes
-Our Learning Consultants can advise on further areas for development.
