Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLE * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade
MCSE 2003 Corp Training Suite
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Cisco CCNA
Cisco CCNP
CISSP 2007
Certified Ethical Hacker (CEH)

View Complete List...
*

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
PRINCE2 Foundation
PRINCE2 Practioner Complete
IT Infrastructure Library ITIL

View Complete List...
*

GRAPHICS & LAYOUT
Creative Suite 3: Design Bundle
PhotoShop CS3 Essentials
Illustrator CS3 Essentials
InDesign CS3 Essentials
Photoshop Elements 5

View Complete List...
*

MULTIMEDIA & ANIMATION
After Effects CS3 Essentials
CS3: Production Bundle
Encore DVD Pro 2.0
Final Cut Studio
Premiere Pro CS3 Essentials

View Complete List...
*

CAD & 3D
AutoCAD 2008
AutoCAD Architecture 2008
AutoCAD LT 2008
3ds max 9 and VIZ
Civil 3D 2007

View Complete List...
*

SOFT SKILLS TRAINING
Assertiveness
Communication Series
Customer Service Series
Effective Presentation Skills
Telephone Courtesy and Customer Service

View Complete List...
*

WEB DESIGN & INTERNET
Creative Suite 3: Web Bundle
Dreamweaver CS3 Bundle
Flash CS3 Bundle
Expression Studio Bundle
E-Commerce Introduction

View Complete List...
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

Access 2003 and SQL Server
By LearnKey
MS Access 2003 and SQL Server Training Series on CD-ROM
Access 2003 and SQL Server
5 User Library Licence £250.00 + VAT
Buy Now
 

PACKAGE INCLUDES


  • 6 CDs
  • Over 6 Hours of Instruction
  • 5 User Licence Included

    COURSE INTRODUCTION

    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.

    In this comprehensive 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 . Securi

    		•

    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 CONTACT US  SITEMAP 
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 CarolineStreet, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk
    red arrow Website design by Aimpro UK red arrow Terms