|
Session 1
Creating Tables and Relationships
1.1 A Few Words About Database Design
1.2 Creating Tables
1.3 Creating Tables Using Design View
1.4 Creating Relationships
1.5 Importing and Linking to External Data
Creating Queries
2.1 Query Basics
2.2 Creating Query Criteria
2.3 Fine Tuning Your Queries
2.4 Multi-Table Queries and Joins
Session 2
Getting Started with Forms
3.1 Why Use Forms?
3.2 Getting Started
3.3 Creating a Bound Form
3.4 Working with Properties
3.5 Working with Other Control Types
3.6 Creating an Unbound Form
3.7 Managing Your Form’s Interface
Session 3
Displaying Data with Reports
4.1 Comparing Forms and Reports
4.2 Creating a Basic Report
4.3 Introducing the Sorting and Grouping Window
4.4 Performing Calculations on Reports
4.5 Making Sections Behave
4.6 TextBox Properties
4.7 Performing More Complex Calculations
4.8 Print Setup/Output
Building a Simple Application
5.1 Putting Together an Access Application
5.2 Using Hyperlinks in Access Applications
5.3 Using the Commnd Button Wizard
5.4 Creating Custom Menus, Shortcut Menus,
and Toolbars
5.5 Creating a Startup Form
|
Session 4
Making Forms and Controls Work
6.1 Modifying a Form’s Caption
6.2 Validating a Form’s Data
6.3 Using a Control’s Data Events
6.4 Introducing the Combo (and List) Box
Working with the VBA IDE
7.1 A Quick Tour of the VBA IDE
7.2 Writing Code
7.3 Testing Code
Session 5
Effective Database Design
8.1 Why Bother with Design?
8.2 Relational Model Basics
8.3 Normalization
Making the Most of Your Tables
9.1 Building the Rules of the Business into
the Database
9.2 Relationships and Referential Integrity
9.3 Creating Indexes
Session 6
Parameter and Aggregate Queries
10.1 Creating Parameter Queries
10.2 Aggregate Queries
10.3 Query Properties
Creating Data Access Pages
11.1 Introducing Data Access Pages
11.2 Working with Data Access Pages
11.3 Creating a Data Access Page with Groups
11.4 Deploying Data Access Pages
Session 7
Investigating VBA
12.1 Why Use VBA?
12.2 Introducing Modules and Procedures
12.3 Calling Procedures
12.4 Creating Your Own Procedures
12.5 Using Variables
12.6 Variable Data Types
12.7 Finishing the Age Function
12.8 Using Constants
Programming Objects
13.1 Working with Objects
13.2 Working with Collections
13.3 Using Object Variables
Session 8
Report Tips and Tricks
14.1 Getting Just the Data You Want
14.2 Creating Reports with Multiple Columns
14.3 Numbering Items on a Report
14.4 Using BackColor to Create Alternate Gray
Lines
Controlling Controls
15.1 Using Subforms
15.2 Using MultiSelect ListBox Controls
15.3 Handling New Entries in a Combo Box
15.4 Working with Tab Controls
Session 9
Programming Forms' Data
16.1 Filtering and Sorting Forms
16.2 Finding a Row on a Form
16.3 Mark a Row and Return to It Later
16.4 Using a Form’s Recordset Property (Access
2000)
Form Tips and Tricks
17.1 Creating a Splash Screen
17.2 Using Popup Forms
17.3 Controlling a Form’s Closing
17.4 Tapping into Keyboard Events
17.5 Using ActiveX Controls
|
Session 10
Mastering Debugging
18.1 Why Do You Need Debugging?
18.2 Getting Started with Debugging
18.3 Stepping Through Code
18.4 Evaluating Expressions
18.5 Tips on Effective Debugging
Taking Advantage of Queries
19.1 Understanding Joins
19.2 Action Queries
19.3 Access SQL
Session 11
Managing Data with ADO
20.1 Introducing ActiveX Data Objects
20.2 Retrieving Data with ADO
20.3 Searching for Data in a Recordset
20.4 Updating Data with ADO
Using Error Handling to Bullet-Proof Your
Code
21.1 Handling Run-Time Errors
21.2 The Error Handling Standard
21.3 Taking a Closer Look
21.4 Who Handles Errors?
Session 12
Designing Multiuser Applications
22.1 Multiuser Architectures
22.2 Locking
22.3 Keeping Recordsets Current
22.4 Transaction Processing
Exploring Replication
23.1 Replication Basics
23.2 Replicating a Database
23.3 Changes Access Makes to a Database When
You Replicate it
23.4 Synchronizing Replicas
23.5 Conflict Management
23.6 Partial Replication
Session 13
Automating Office Applications
24.1 What Is Automation?
24.2 Working with Other Applications
24.3 Example: Building an Excel Chart
24.4 MailMerge with Word
24.5 Access as an Automation Server
Session 14
Securing Your Applications
25.1 Choosing the Right Security System
25.2 Workgroups
25.3 Users and Groups
25.4 Permissions
25.5 Using the Security Wizard to Properly
Secure Your Database
Building Access Data Projects
26.1 Introduction to Access Projects
26.2 Creating a New Project
26.3 Creating SQL Server Objects
26.4 Creating SQL Server Database Diagrams
26.5 Creating SQL Server Views
26.6 Creating SQL Server Stored Procedures
Session 15
Developing Access 2000 Client/Server Applications
27.1 Introduction to Client/Server
27.2 MDB versus ADP
27.3 Designing Client/Server Applications
27.4 Designing MDB Client/Server Applications
27.5 Designing ADP Client/Server Applications
Deploying Access Applications
28.1 The Finishing Touches
28.2 Managing VBA Code
28.3 Introducing the Access Runtime Version
28.4 Developing Runtime Applications
28.5 Deploying Access Applications
|
Master Microsoft Access 2000 Application Development with this easy-to-follow
video training collection. Whether you are learning Microsoft Access
2000 development for the first time or adding to your reference library,
you will find this Professional Training contains thorough, well-written
content that is second to none: 