| |
Overview:
Students will learn different skills using Access
in a hands-on instructor-led classroom.
Prerequisites:
Windows
Operating System: Introduction or equivalent knowledge.
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
All the skills required for a student to
use an existing database.
-
Relational Database
Concepts
-
The Access
Environment
-
Help Functions
-
Entering and Editing
Data
-
Sorting and
Filtering Data
-
Introduction to
Queries
-
Creating User
friendly forms
-
Entering, editing,
sorting in forms
-
Creating and
Printing easy to read Reports
-
Creating Tables in
Design View
-
Using the Table
Wizard
-
Data integrity
properties
-
Modifying the Table
Design
-
Auto Lookup lists
-
Query Concepts
-
Query Criteria
Operators
-
Using Comparison
Operators
-
Running and Saving
Queries
-
Multi table queries
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
Design I: Database design from a overall point
of view. The skills required put it all together and make it work.
-
Database Design
Concepts
-
Normalizing Data
-
Creating
Relationships
-
Performing
Calculations in Queries
-
Working with
Multiple Table Queries
-
Enhancing Forms
-
Customized Form
Design
-
Customizing Reports
-
Troubleshooting
Printing Problems
-
Using Subforms and
Subreports
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
Design II: Adding more power to the database
with more complex functions, and user friendly concepts.
-
Parameter Queries
-
Action Queries
-
Query Join types
-
Crosstab Queries
-
Enhancing Forms
-
Option Groups
-
Tabbed Forms
-
Grouping and
Summary in Reports
-
Using command
buttons
-
Creating Macros
- Creating a
Switchboard form
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
Get Started Quickly with
Wizards
- Using Wizards for
Application Development
- Creating a Database Using
the Database Wizard
- Adding an Object to Your
Application
- Adding a Command Button
to a Form
Customize an Application with
Visual Basic
- Customizing a Command
Button
- Modifying a Command
Button Created Using the Wizard
- Making a Form Read-Only
by Default
- Creating a Command Button
Without a Wizard
- Creating Event Procedures
for Form Events
- Displaying a Message to
the User
Find and Filter Records in a
Form
- Creating a Combo Box to
Find Records
- Filtering Data
Respond to Data Entry Events
- Understanding Form and
Control Events
- Performing Actions as the
User Moves in a Form
- Performing Actions as the
User Changes Data
- Responding to Keyboard
Events
- Validating Data
Write Your Own Functions
- Understanding Modules and
Procedures
- Creating General
Procedures in a Standard Module
- Using General Procedures
on a Form
- Creating General
Functions in a Form Module
Monitor and Debug Your Code
- Stepping Through Code
Line by Line
- Finding and Fixing Bugs
in Your Code
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
Respond to Errors and
Unexpected Conditions
- Replacing Standard Error
Messages
- Responding to a Combo Box
Error
- Creating Error-Handling
Routines
Gather Information in a Dialog
Box
- Creating an Application
from Scratch
- Creating a Dialog Box to
Go to a Specific Record
- Filtering Data in a
Report
Navigate Through Your
Application
- Making Forms Work
Together
- Displaying Related
Records in a Pop-Up Form
- Opening a Form to Add
Related Records
Display Custom Menus and
Toolbars
- Using Menus and Toolbars
in Your User Interface
- Creating a Custom Menu
Bar
- Customizing Toolbars
Put Final Touches on an
Application
- Controlling How Your
Application Starts
- Customizing Your
Application’s Appearance
- Preparing to Distribute
Your Application to Users
Course Fee: $249.00
Course Time: 1 day, 9am - 4pm, or 2 evenings, 6pm -9pm
Explore Objects and
Collections
-
Introducing the Issues
Application
-
Understanding Objects and
Collections
-
Referring to Objects and
Collections
-
Using the For Each
Statement with a Collection
-
Using a Multiple-Selection
List Box
-
Working Directly with
Database Objects
-
The difference between DAO
and ADO
-
Finding and Changing Data
in a Recordset
-
Creating and Running an
Action Query
Customize Reports with Visual
Basic
-
Using Standard Reporting
Features
-
Responding to Report
Events
-
Calculating Totals While a
Report Is Printing
-
Controlling Printer
Settings
Share Data with Other
Applications
-
Using Automation Objects
-
Sending Commands to
Microsoft Word
-
Getting Information from
Another Application
-
Working with Folders in
Microsoft Outlook
-
Using Access Objects from
Microsoft Excel
|
|
