CGTC Home
Economic Development
About Economic Development
Meeting Facilities
Campus & Street Map
Mission Statement
Contact Us
Business and Industry
About Business and Industry
QuickStart
Retraining Tax Credits
WorkKeys
Customized Training
Certification
Facilities
Request Information
Computer Training Center
About the Computer Training Center
Schedule of Classes
Class Descriptions
Register Online
Facilities
Request Information
Continuing Education
About Continuing Education
Schedule
Class Descriptions
Register Online
Facilities
Request Information
Site Map
Computer Training Center
Imagine the Possibilities - Economic Development
CGTC Home >> Economic Development >> Computer Training Center >> Class Descriptions >> Access XP/2000: Introduction to Application Development

Access XP/2000: Introduction to Application Development

Register Online

Prerequisites: Access Level 2

Designing Applications
Examining the Application Development Process
Determining User Requirements
Designing the Application Interface
Defining the Database Configuration
Previewing an Existing Application
Deciding How to Automate Your Application

Using Advanced Tools and Controls
Using the Performance Analyzer
Using the Combo Box to Find Records
Calculating Values from Subform Controls

Creating Dialog Boxes
Setting Dialog Box Form Properties
Creating Option Groups
Creating Command Buttons
Specifying Default and Cancel Buttons
Enhancing Dialog Boxes

Using Macros
Creating Macros
Attaching Macros to Events in Forms
Using the Macro Builder
Creating Conditional Macros
Creating Macro Groups

Controlling Data Entry
Restricting User Access to Fields
Setting Form Properties
Setting Form Open Modes
Closing Forms Automatically
Specifying Default Values for Fields
Conditioning Setting the Visible Property

Using Dialog Boxes to Filter Records in Reports
Creating Dialog Boxes for Reports
Modifying Underlying Queries
Modifying Report Properties
Evaluating Dialog Box Functionality
Creating Message Boxes

Creating Custom Switchboards
Creating Switchboard Forms
Creating Macros for Switchboard Controls
Assigning Macros to Switchboard Controls

Enhancing Applications
Creating Keyboard Shortcuts Macros
Creating Control Tips and Status Bar Messages
Setting Startup Properties
Creating Modules

Using Database Utilities
Using the Database Splitter
Using the Linked Table Manager
Compacting and Repairing Databases
Saving Databases as MDE Files

Protecting and Replicating Databases
Setting Record Locking
Setting Database Passwords
Assigning User Permissions
Encrypting and Decrypting Databases
Replicating and Synchronizing Databases

 

 

 

 

 


Accreditation | Non-Discriminatory Statement | Contact Webmaster

CGTC Home | College Profile | Academics | Apply to CGTC | Student Services | Faculty and Staff | News & Information | Economic Development | Campuses | Site Map | Faculty WebMail | Search
Central Georgia Technical College, A Unit of the Technical College System of Georgia