To receive updates and new releases, subscribe today

ABOUT US

Save up to 30%
Off Publishers Retail Prices

IT CERTIFICATION
MCPD: ASP.NET 3.5 C#
MCPD: Ent. App. Dev. 3.5 C#
MCPD: Windows 3.5 C#
A+ 2009 with Network+ 2009
MCSE 2003
MCSE with A+/N+ 2009
MCSE with CCNA
MCITP 2008 Server Admin
MCITP 2008 Enterprise Admin
Cisco CCNA (640-802)
MCTS: Windows 7 Configuration
MCITP Business Intelligence Dev SQL 2008

View Complete List...

DESKTOP & OFFICE
Office 2010: New Features
Office 2007 Training Bundle
Office 2003 Training Bundle
Access 2007
Excel 2007

View Complete List...

SECURITY & NETWORKING
EC-Council Network Security Administrator (ENSA)
EC Council - Security5
EC Council - CEH v6
EC Council - CHFI v4
EC Council - ESCA/LPT
CISSP Training Suite

View Complete List...

PROJECT MANAGEMENT
PMP 2008 Exam Prep
Project 2007
Project Management Intro
Managing Project Teams
ITIL v3 Foundation

View Complete List...

CAD & 3D
AutoCAD 2011
AutoCAD Architecture 2011
Inventor 2011
AutoCAD LT 2010
Civil 3D 2010
Revit Structure 2010
AutoCAD Map 3D 2010
AutoCAD Mechanical 2010

View Complete List...

GRAPHICS & LAYOUT
Creative Suite 5 Design Essentials Bundle
Photoshop CS5 Extended: Essentials
InDesign CS5: Essentials
Illustrator CS5: Essentials
Photoshop Elements 8

View Complete List...

WEB DESIGN & INTERNET
Dreamweaver CS5: Essentials
Creative Suite 5 Web Essentials Bundle
Flash CS5 Professional: Essentials
Creative Suite 5 Design Essentials Bundle
Expression Studio 2 Bundle

View Complete List...

CAREER PROGRAMS
Executive Office Admin Track
Helpdesk Support Track
Information Security Track
Network Engineer 2008 Track
Web & Graphic Designer Track

MULTIMEDIA & ANIMATION
Adobe CS4 Production Bundle
After Effects CS4 Essentials
Premiere Pro CS4 Essentials
MOTU Digital Performer 6
Encore DVD Pro 2.0

View Complete List...

SOFT SKILLS TRAINING
Better Business Writing
Excellence in Supervision
How to Get Things Done
Team Leadership
Assertiveness

View Complete List...

PROGRAMMING
ASP.Net 3.5
C Programming 2007
C# for Developers
VB.Net 3.5
Visual Studio 2008: Essentials

View Complete List...

DATABASES
Oracle 11g OCA
Visual Basic for Excel
SQL Server 2008 Database Development (70-433)
Data Modeling
MCTS: SQL Server 2005 (Exam 70-431)

View Complete List...

OPERATING SYSTEMS
Windows XP End User
Windows Vista for End Users
Windows 7 by VTC
Mac OSX 10.4 Tiger

View Complete List...

COURSES BY EXAM NUMBER
A+ Essentials 2009 Training

View Complete List...

BOOKS
A+ 2009 Review Guide

View Complete List...

Windows 7: New Features

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....

FAST UK DELIVERY
Order Today, Learn Tomorrow!

SECURE PAYMENT
PROCESSING

We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted

A-Z COURSE LIST

WHAT'S NEW

FREE DEMOS

SPECIAL OFFERS

ONLINE TRAINING

Access 2003 and SQL Server by Blast

By LearnKey

MS Access 2003 and SQL Server Training Series on CD-ROM

Access 2003 and SQL Server by Blast

Single User CD Course	£280.00 + VAT
Multi User CD Course	£560.00 + VAT

PACKAGE INCLUDES

• 6 training CDs
• Over 6 Hours of Instruction

COURSE INTRODUCTION

The Access 2003 and SQL Server by Blast training course provide an insight on these powerful and complex database application environments. Even experienced developers need help learning Microsoft Access 2003, especially when it comes to integrating with SQL Server.

Training instructor 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.

In this comprehensive training course on Access 2003 and SQL Server, Alison provides developers with 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
•  Developing an ADP application

COURSE OUTLINE

Session 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

Session 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

Session 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

Session 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

Session 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

Session 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

Printer friendly version

Top of page

A-Z COURSE LIST PROVIDERS CBT TRAINING CVISION NEWS CONTACT US SITEMAP

MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

Website design by Aimpro UK

Terms