Access 2003 and SQL Server 2000 Training

Access 2003 and SQL Server Training Vidoes on CDAccess 2003 and SQL Server 2000 Integration Training

Hosted by Alison Balter
6 Hours of training on CD

Microsoft Access is a powerful, complex database application environment, and even experienced developers need help learning it, especially when it comes to integrating with SQL Server. Alison Balter is recognized as one of the world's leading experts on Access development, and has helped thousands of users and developers become proficient in database development and integration of Visual Basic applications with Access.

See our other courses:

Details on Integrating Access 2003 and SQL Server 2000 Course

In this comprehensive course on Access 2003 and SQL Server 2000 Integration training, Alison provides over 6 hours of instruction covering 85 topics including:

  • Client-server development techniques
  • SQL Server basics
  • Mastering T-SQL
  • Designing SQL Server stored procedures, triggers, and user-defined functions
  • SQL Server security
  • Developeing an ADP application

Access 2003 w/SQL Server 2000 Training Series

Part#: bt-acc03sql | Contents: Set of 6 CDs

Format

Reg: $399.95
Sale: $369.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, or Windows 7 32-Bit.

TrainerAccess 2003 and SQL Server 2000 Integration:
Alison Balter is a highly experienced independent trainer and consultant, specializing in Windows applications training and development. During her seventeen years in the computer industry, she has trained and consulted with many corporations and government agencies. Alison is a regular contributing columnist for Access/Office/Visual Basic Advisor as well as other computer publications. She is also a regular on the Access and Visual Basic national speaker circuit. She was also one of four speakers on the Microsoft Visual Basic/Visual Studio World Tour.

Course Outline - Access 2003 and SQL Server 2000 Training:

Time: Approximately 6 hours of instructor-led training

Access 2003 and SQL Server Level 1

1.0 INTRODUCTION TO CLIENT/SERVER DEVELOPMENT TECHNIQUES
1.1 Why This Section Is Important
1.2 Understanding the Client/Server Model
1.3 Deciding Whether to Use the Client/Server Model
1.4 The Roles Access Plays in the Application Design Model
1.5 Learning the Client/Server Buzzwords
1.6 Upsizing: What to Worry About
1.7 Using the Upsizing Wizard
1.8 Defining an ODBC Data Source
1.9 Connecting to a Database Server
2.0 SQL SERVER BASICS
2.1 Why This Chapter is Important
2.2 Editions of SQL Server Available
2.3 Overview of the SQL Server Components
2.4 Introduction to the Enterprise Manager
2.5 Introduction to the Query Analyzer
2.6 Introduction to the Profiler
2.7 Introduction to Data Transformation Services
2.8 Configuring the Server
2.9 Designing and Creating a SQL Server Database

Access 2003 and SQL Server Level 2

1.0 SQL SERVER TABLES AND DATABASE DIAGRAMS
1.1 Why This Chapter is Important
1.2 Creating SQL Server Tables
1.3 Working with Constraints
1.4 Identity Columns
1.5 Creating Computed Columns
1.6 Working with User-defined Data Types
1.7 Adding and Modifying Indexes
1.8 An Introduction to Triggers
1.9 Working with Relationships
1.10 Working with Database Diagrams
1.11 Establishing Referential Integrity
1.12 Looking at the Benefits of Relationships
1.13 Examining Indexes and Relationships

2.0 MASTERING T-SQL
2.1 Why This Chapter is Important
2.2 Introduction to T-SQL
2.3 The SELECT Statement
2.4 Aggregate Functions
2.5 The HAVING Clause
2.6 Top Values Queries
2.7 Join Types
2.8 Modifying Data with Action Queries
2.9 T-SQL Functions

Access 2003 and SQL Server Level 3

1.0 WORKING WITH SQL SERVER VIEWS
1.1 Why This Chapter is Important
1.2 Creating a Simple View
1.3 Creating Complex Views
1.4 Using Views to Secure Data
1.5 Modifying Data in a View
1.6 Modifying Views
1.7 Renaming Views
1.8 Deleting Views
1.9 Indexed Views
2.0 DESIGNING SQL SERVER STORED PROCEDURES, TRIGGERS, AND USER-DEFINED FUNCTIONS
2.1 Why This Chapter is Important
2.2 Stored Procedure Basics
2.3 Declaring and Working with Variables
2.4 Controlling the Flow
2.5 The SET NOCOUNT Statement
2.6 Using the @@Functions
2.7 Working with Parameters
2.8 Modifying Data with Stored Procedures
2.9 Errors and Error Handling
2.10 Building and Working with User-Defined Functions
2.11 Creating and Working with Triggers

Access 2003 and SQL Server Level 4

1.0 SQL SERVER SECURITY
1.1 Why This Chapter is Important
1.2 Security Introduced
1.3 Authentication
1.4 Creating Roles
1.5 Permissions Validation
1.6 Administering Statement Permissions
1.7 Creating and Working with Applications Roles
1.8 Access Security and Its Role in a Client/Server Application
2.0 ADO AND SQL SERVER
2.1 Why This Chapter is Important
2.2 A History of Data Access
2.3 ADO Quick Review
2.4 ADO and Stored Procedures
2.5 Advanced ADO Techniques

Access 2003 and SQL Server Level 5

1.0 DEVELOPING AN MDB CLIENT/SERVER APPLICATION WITH LINKED TABLES
1.1 Why This Chapter is Important
1.2 What is a Linked Client/Server Application?
1.3 How Linked Table Applications Work
1.4 Working with Linked Tables
1.5 Using Pass-Through Queries
1.6 Executing Stored Procedures
1.7 Building Client/Server-Friendly Forms
1.8 Working with Local Tables
1.9 Populating Combo Boxes and List Boxes Dynamically
1.10 Building Client/Server-Friendly Reports
1.11 Linked Table Gotchas
2.0 DEVELOPING AN ADP APPLICATION
2.1 Why This Chapter is Important
2.2 What are Access Projects?
2.3 Creating an Access Project
2.4 Maintaining a SQL Server Database from an Access Project
2.5 Building Access Project Forms
2.6 Special Access Project Form Properties and Techniques
2.7 Building Access Data Project Reports
2.8 ADP Gotchas

Access 2003 and SQL Server Level 6

1.0 BUILDING UNBOUND APPLICATIONS
1.1 Why This Chapter is Important
1.2 The Benefits of Unbound Applications
1.3 The Unbound Form
1.4 The Unbound Form and Pass-Through Queries
1.5 The Unbound Form and Stored Procedures
2.0 BUILDING N-TIER APPLICATIONS
2.1 Why This Chapter is Important
2.2 The Basics of N-Tier Development
2.3 Access's Role in the N-Tier Model
2.4 Access and the Logical Three-Tier Model
2.5 Building the Middle-Tier Component
2.6 Access and a Physical Three-Tier Model
3.0 TUNING AND MAINTAINING SQL SERVER
3.1 Why This Chapter is Important
3.2 Hardware Selection and Tuning
3.3 SQL Server Configuration and Tuning
3.4 Database Maintenance
3.5 Table and Object Maintenance
3.6 Job Maintenance
3.7 Performance Monitoring

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $399.95
Sale price: $369.00

Format

Product Details
  • Part#: bt-acc03sql
  • Contents: Set of 6 CDs
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player