MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Featured Micro-Sessions
Course Descriptions
Featured Micro-Sessions
Basic Skills
Business Programs
Business Skills
Databases
Desktop Publishing & Graphics
Internet and Communications
Operating Systems
Presentations
Programming
Report Writing
Spreadsheets
Web Page Design
Word Processing
Free Events
Register for a Class
Customized Training
Proprietary Technology Training
On Site Training
About On Site Training
MobileKnowledge
Consulting Services
Technical Writing
Employment Opportunities
About Us
Site Map
Create Profile
Request Information
Support
Download Course Training Files

Access 2003: Advanced Forms

Automate navigation, data entry and validate data; create friendly user screens, filter data on sub forms.

Recommended Preparation: Access 2003 Intermediate, Access 2003 Form Design or equivalent experience.

Register for a class
Personalized training and consulting is available upon request.


Lesson 1: Automation

  • Navigation Buttons
  • Adjusting Code for Commands

Lesson 2: Macros

  • Creating a Macro to Open a Form
  • Converting Macros to VBA
  • Creating Macros using Data Validation
  • Creating Macros to Automate Data Entry

 

Lesson 3: Switchboards & Advanced Form Options

  • Creating Switchboard in Design View
  • Writing Code to Show/Hide Date Fields and Labels
  • Writing Code to Run Reports
  • Adjusting Query to Work from Switchboard
  • Adding Calendar to Select Date
  • Automating Switchboard
  • Hiding Database Window

Lesson 4: Advanced Sub Forms

  • Hiding a Sub Form
  • Open a Filtered Form using Selection Criteria

 

 

 

Dates:
January 23
1:00-4:45

March 2
1:00-4:45


Price:
$129 for open enrollment courses, when available.

Length:
4 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions