|
Provided by: Act Training Access Level 4Computer |
 |
Training
Provided by Act Training
Application Development level one day hands-on instructor led course on Microsoft Access. Topics include: Application Design Concepts, Adding Command Buttons to Guide User Navigation, Automating a Dialog-box Form with a Macro Group, Creating a Switchboard Form, Working with Command Bars Toolbars and Menus, Creating a Splash Screen Form, Using Visual Basic Procedures, Adding Security to an Application.
The prerequisite for this course is Access Level 1, Level 2 & Level 3 or equivalent knowledge.
Related Software Programs or Products: Microsoft Access
|
|
||||||||||||
Access Level 4
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
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
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
