Microsoft Access Developer's Guide to SQL Server

ISBN-10: 0672319446

ISBN-13: 9780672319440

Edition: 2000

Authors: Mary Chipman, Andy Baron

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:
You have reached 400 XP and carrot coins. That is the daily max!
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
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Customers also bought

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

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.

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?
SQL Server Fundamentals
SQL Server Editions
SQL Server Graphical Components
The Server
The Database
What's New in SQL Server 2000
Installing SQL Server
Understanding SQL Server Security
Why Security Is Important
Letting Users In
Understanding Permissions
What About Access Security?
Upsizing Access Security Permissions on Tables
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
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
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
Designing and Creating a SQL Server Database
Designing a Relational Database
Implementing Your Design in SQL Server 2000
Introduction to Transact-SQL (T-SQL)
Defining Transact-SQL
Referring to Objects
Selecting Data
Updating Data with Action Queries
Using Transact-SQL Functions
Programming in Transact-SQL
Other Querying Techniques
Creating and Optimizing Views
Defining Views
Creating and Modifying Views
Using Views to Update Data
Indexed Views
Optimizing Views and Queries
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
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
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
Internet Features in Access and SQL Server
Publishing SQL Server Data to the Web
XML in SQL Server 2000
Access Internet Features
Architecting Distributed n-Tier Applications
Overview of n-Tier Development
Creating Middle-Tier Components
Security and Connection Pooling
Deployment, Tuning, and Maintenance
Monitoring Performance
Backup and Maintenance
Web Sites
Useful Downloads
Magazines and Journals
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.