Microsoft Access Developer's Guide to SQL Server

ISBN-10: 0672319446
ISBN-13: 9780672319440
Edition: 2000
List price: $49.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
Writing a Scientific Report Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $49.99
Copyright year: 2000
Publisher: Pearson Education
Publication date: 12/13/2000
Binding: Paperback
Pages: 864
Size: 7.50" wide x 9.00" long x 2.00" tall
Weight: 3.036
Language: English

Andy Baron is a senior consultant at MCW Technologies, a Microsoft MVP (Most Valuable Professional) since 1995, and a contributing editor for Advisor Media and Pinnacle Publications. Andy is co-author of the Microsoft Access Developers Guide to SQL Server (Sams), and he writes and presents courseware for Application Developers Training Co.

Introduction
Converting Your Access Database to SQL Server
Reasons to Upsize
Getting Started with the Upsizing Wizard
Upsizing Gotchas: What to Watch Out For
What About Security?
Using the Upsizing Wizard to Create Linked Tables
Upsizing Using Data Transformation Services (DTS)
Using Linked Servers for Data Access
Beyond Upsizing: What's Next?
Summary
SQL Server Fundamentals
SQL Server Editions
SQL Server Graphical Components
The Server
The Database
What's New in SQL Server 2000
Installing SQL Server
Summary
Understanding SQL Server Security
Why Security Is Important
Letting Users In
Understanding Permissions
What About Access Security?
Upsizing Access Security Permissions on Tables
Summary
Introduction to Access Projects (ADPs)
About Access Projects
Creating a New Access Project
Forms in Access Projects
Managing Your SQL Server Through an Access Project
Summary
Linking to SQL Server Using Access Databases (MDBs)
Advantages of Using a Jet Database (MDB) Front End
How Jet Uses ODBC
Working Efficiently with Linked Tables
Creating Efficient Bound Forms
Using Pass-Through Queries
Caching Data in Local Tables
Tweaking ODBC Settings to Tune Performance
Summary
ActiveX Data Objects (ADO) Fundamentals
A Short History of Data Access Technologies
Getting Started with ADO
Creating an ADO Connection Object
Creating an ADO Recordset Object
Creating an ADO Command Object
Mixing and Matching the Three Objects
Advanced ADO
Other ADO Libraries
Choosing the Best Tool for the Job at Hand
Summary
Designing and Creating a SQL Server Database
Designing a Relational Database
Implementing Your Design in SQL Server 2000
Summary
Introduction to Transact-SQL (T-SQL)
Defining Transact-SQL
Referring to Objects
Selecting Data
Joins
Updating Data with Action Queries
Using Transact-SQL Functions
Programming in Transact-SQL
Other Querying Techniques
Summary
Creating and Optimizing Views
Defining Views
Creating and Modifying Views
Using Views to Update Data
Indexed Views
Optimizing Views and Queries
Summary
Programming Effective Stored Procedures
Stored Procedure Fundamentals
What's Under the Hood
Creating Parameterized Stored Procedures
Error Handling in Stored Procedures
Creating UPDATE, DELETE, and SELECT Stored Procedures
Debugging Stored Procedures
Advanced Stored Procedure Topics
Stored Procedures and User-Defined Functions
The System Stored Procedures
Summary
Scaling Up with Unbound Access Applications
What Is an Unbound Application and Why Build One?
Using Stored Procedures
Deciding Between Access Databases and Access Projects
Unbound MDBs
Unbound ADPs
Summary
Building Access Reports from SQL Server Data
General Guidelines for Creating Efficient Reports
Using Access Features to Filter Data
Reporting in Access Projects
Reporting in Access Databases
Reporting on OLAP Data
Summary
Internet Features in Access and SQL Server
Publishing SQL Server Data to the Web
XML in SQL Server 2000
Access Internet Features
Summary
Architecting Distributed n-Tier Applications
Overview of n-Tier Development
Creating Middle-Tier Components
Security and Connection Pooling
Summary
Deployment, Tuning, and Maintenance
Tuning
Monitoring Performance
Backup and Maintenance
Deployment
Summary
Resources
Books
Web Sites
Useful Downloads
Magazines and Journals
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×