Courses / Access 2002/2003 Application Development
Access 2002/2003 Application Development
- Provider
- WWP Training Ltd
- Course ID
- ACCO3AD
- Summary
- This programme is for you if you want to learn how to become a proficient database application developer by using the features of Access and Visual Basic for Applications (VBA).
About the Course
- Target
- Regular users of databases
- Entry 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.
- Outcome
- Perfomance Based 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
- 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 window 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 show 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 window 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 - Cost
- Following course delivery, we ensure that you continue to receive the full benefit of our training programmes (excluding Technical programmes) by offering 12 months free telephone support during normal office hours - boosting confidence and providing expert advice when you need help to solve a problem quickly.
- Enrolment
- For further information contact the course provider for details
Availability
- Starts
- Please contact provider to arrange on site training dates.
- Duration
- 2 days
- Timetable
- Contact course provider for details
- Provider
- WWP Training Ltd
Venue and Contact details
Main
39 - 45 Victoria Street
Windsor
Berkshire
SL4 1HE
UNITED KINGDOM
Telephone 01753 857 828
Fax 01753 858 615
Email info@wwp.co.uk
Website http://www.wwp.co.uk
Contact Notes Please contact the provider to arrange a venue.
Courses
Syndicate
