Access Level 4

Course Description
Access Level 4 is a hands-on instruction that will guide you through the process of developing an application by using one or more Access  databases.

Prerequisites
Access Level 4 is designed for the student who is proficient in creating Access normalized tables and their relationships, multi-table queries, forms and sub forms, reports, and macros, and who needs to draw on all these skills and add code to create an application. These skills are taught in Access Level 1, Access Level 2 and Access Level 3.

Study Method:
Flexible Learning:  Group Training

What Next?
Professional IT training courses.

Course Content

Lesson 1: Application Design Concepts

Planning an Application
Moving through a Completed Application
Looking at the flow and automation of an application’s objects

Lesson 2: Adding Command Buttons to Guide User Navigation

Using One Form for Two Purposes: To Add or Edit Records
Lesson 3: Automating a Dialog-box Form with a Macro Group
Creating a Macro Group
Customizing an Unbound Form to Behave like a Dialog Box
Documenting a Macro Group

Lesson 4: Creating a Switchboard Form

Using the Switchboard Manager
Setting Database Startup Properties
Testing the application startup

Lesson 5: Working with Command Bars: Toolbars and Menus

Using a Macro Group to Show and Hide a Toolbar
Creating a Custom Menu Bar and Shortcut Menu for a Form
Startup Properties for Toolbars and Menu Bars

Lesson 6: Creating a Splash Screen Form

Creating a Form as a Splash Screen
Automating the Splash Screen Form by Using VisualBasic Code
Modifying Startup Properties to Display a Splash Screen Form
Documenting the Application

Lesson 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

Lesson 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

[ Home ] [ Computer Skills ] [ Office Skills ] [ Professional IT courses ] [ Business Courses ] [ Contact ] [ Group Training ] [ Flexible Learning ] [ Distance Learning ] [ Certification | Training West Midlands/Microsoft West Midlands/Sage West Midlands/Bookkeeping West Midlands ]