Microsoft Access
Introduction to Application Development


Participants will learn how to transform a Microsoft Access Database into a fully functioning application by creating Custom menu's, interactive forms and adding security to an Access Application. Participants will also expand on the knowledge from Access Advanced by using advanced Macros and gaining an introduction to Visual Basic for Applications.


Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1, Level 2 and Advanced, or equivalent knowledge

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          Application design concepts
          Planning an application
          Examining a completed application
          Developing a distributed application design

          Adding command buttons to guide user navigation

          Using one form to add or edit records

          Automating a dialog-box form with a macro group

          Creating a macro group
          Customizing an unbound form as a dialog box
          Documenting a macro group

          Creating a Switchboard form

          Using the Switchboard Manager
          Setting database startup properties

          Working with custom toolbars and menus

          Using a macro group to show and hide a toolbar
          Using Visual Basic code to show and hide a customized form-view toolbar
          Creating a custom menu bar for a form
          Startup properties for toolbars and menus
          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

          Using Visual Basic procedures

          Creating a global function
          Adding General procedures in a form module
          Creating event procedures

          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


          APP.MDB diagram
          Planning an applications
          Importing spreadsheets, databases, and delimited text files

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2018