 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code.
Students will learn how to build an application by designing and creating the database objects and a graphical user interface.
Students should already understand table, query, form, report, and macro design and function, as well as data normalisation and table relationships.
Prerequisites:
Access 2000 Advanced, or equivalent knowledge.
Unit 1 : Application design concepts
- Planning an application
- Examining a completed application
- Developing a distributed application design
- Using one form for two purposes: to add or edit records
- Creating a macro group
- Customising an unbound form as a dialog box
- Documenting a macro group
Unit 4 : Creating a Switchboard form
- Using the Switchboard Manager
- Setting database startup properties
- Using a macro group to show and hide a toolbar
- Creating a custom menu bar for a form
- Startup properties for toolbars and menu bars
Unit 6 : Creating a Splash Screen form
- Creating a form as a splash screen
- Automating the Splash Screen form
- Modifying startup properties to display a Splash Screen form
- Documenting the application
Unit 7 : Using Visual Basic procedures
- Creating a public function
- Adding general procedures in a Form module
- Creating Event Procedures
- Viewing a live web site on a Form
Unit 8: Adding security to an application
- Security overview
- Steps to securing a database by using user-level security
- Documenting database security
- Securing a database with a database password
- Distributing the secured application