Microsoft Access
Introduction to Application Development


Outcomes

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.

Prerequisites

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

Location

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

          Appendices

          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 2017