skip to content
Access 2002 development unleashed Preview this item
ClosePreview this item
Checking...

Access 2002 development unleashed

Author: Stephen Forte
Publisher: [Indianapolis, Ind.] : Sams, ©2002.
Edition/Format:   Print book : EnglishView all editions and formats
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Stephen Forte
ISBN: 0672321203 9780672321207
OCLC Number: 47939320
Notes: Includes index.
Description: xxi, 835 pages : illustrations ; 24 cm
Contents: Part I Database Design Unleashed 5 --
1 What's New for Developers in Access 2002 7 --
User Interface Changes 8 --
Changes to the VBE 9 --
Compatibility with Access 2000 Databases 10 --
Database Conversion Error Logging 11 --
Offline Data Access Pages 11 --
Improved Integration with SQL Server 2000 12 --
Other Access 2002 Features 13 --
2 Planning the Development Process 15 --
Gathering Requirements 17 --
Architecture 24 --
Development Planning 24 --
Construction 28 --
3 Database Design and Normalization 45 --
The Relational Design Theory 48 --
4 Advanced Queries 59 --
Using the Query Object 60 --
Creating Queries in Access 62 --
Creating Advanced Queries 74 --
Mastering Totals Queries 75 --
Mastering Crosstab Queries 83 --
Mastering Parameter Queries 87 --
Mastering Pass-Through Queries 91 --
Mastering Data Definition Queries 93 --
5 The Microsoft Jet Database Engine 99 --
The History of Microsoft Jet 100 --
Using Jet 4.0 Features in Your Applications 103 --
Part II Data Access 117 --
6 Introduction to ActiveX Data Objects 119 --
History of Data Access 120 --
Microsoft's Universal Data Access Initiative 121 --
ActiveX Data Objects (ADO) 122 --
The ADO Object Model 125 --
Moving from DAO to ADO 142 --
The ADO Object Model Compared to DAO 145 --
7 Advanced ADO 147 --
Using the OLE DB Provider for Jet in Access 2002 148 --
Accessing Non-Relational Data with ADO 157 --
Advanced Data Manipulation with ADO 162 --
Data Definition with ADOX 167 --
Part III User Interfaces Unleashed 177 --
8 Advanced Form Design 179 --
Form Properties 180 --
Access Form Controls 189 --
Creating PivotTable and PivotChart Views 197 --
9 Enhancing Forms with ActiveX Controls 203 --
How to Use ActiveX Controls 204 --
Using ActiveX Controls 206 --
21 ActiveX Controls 210 --
Distributing ActiveX Controls 238 --
10 Reporting Unleashed 241 --
Approaching Reports 242 --
Understanding the Architecture of Access Reports 242 --
Building a Single Table Report Using the Report Wizard 244 --
Customizing Reports 247 --
Working with Subreports 256 --
Creating Simple Mailing Labels 259 --
Publishing a Report 262 --
Modifying a Report at Runtime 266 --
Building Reports Programmatically 274 --
Part IV VBA Unleashed 285 --
11 Creating Objects with Class Modules 287 --
Exploring the Benefits of Using Objects 289 --
Reviewing Objects, Properties, and Methods 291 --
Creating Classes 292 --
Creating Properties 292 --
Creating Methods 299 --
Creating Events 300 --
Using Objects 302 --
Creating Multiple Instances of an Object 304 --
Examining More Object Examples 304 --
Implementing an Error Handler Object 311 --
Using Objects with VBA Collections 312 --
12 Debugging Access Applications 317 --
Eliminating Logic Errors 318 --
Working with the Visual Basic Development Environment (IDE) 318 --
Working with the Debug Object 322 --
Using the Immediate Window 324 --
Using the Debugger 326 --
Using Conditional Compilation 331 --
Application Testing 335 --
Practice Debugging Techniques 335 --
13 Professional Error Handling 337 --
Eliminating Syntax Errors 338 --
Eliminating Logic Errors 341 --
Eliminating Runtime Errors 341 --
Errors in Various Applications 364 --
Error Handling With Nested Procedures 365 --
Advanced Error Topics 365 --
14 Application Optimization 369 --
Strengthening the Foundation: Hardware and Windows Optimization 371 --
Installing the Application for Optimal Performance 373 --
Optimizing the Configuration of the Jet Database Engine 374 --
Tools to Measure Performance 381 --
Looking Behind the Scenes 383 --
Optimizing the Database from the Start 384 --
Boosting Query Performance 387 --
Getting Forms to Run Faster 395 --
Writing Fast Code 400 --
Coding Tips and Hints 402 --
Part V Access Client Server 411 --
15 Introducing Access Data Projects and the Visual Tools 413 --
Introducing Access Data Projects 414 --
Using ADPs 415 --
Working with ADPs and Existing SQL Server Databases 419 --
Creating a Project Based on a New Database 428 --
16 Developing Access Front-Ends to Microsoft SQL Server 435 --
Client/Server Architecture: OLE DB Versus ODBC 436 --
Setting Up Your SQL Server Front-End Connection 436 --
Stored Procedures and SQL Pass-Through Queries 440 --
Reporting Against SQL Server in Access 2002 443 --
Using Forms in Your Application 448 --
Advanced Features of the SQL Server OLE DB Provider 450 --
Executing Commands with Parameters 452 --
Using a Connection Class 459 --
17 Access 2002 Front-Ends to Oracle 461 --
Accessing Oracle Data with Access 462 --
Functions in Oracle Versus Access 470 --
Understanding Views and Stored Procedures 482 --
Creating an Unbound Interface to Oracle 491 --
Part VI Interoperability 503 --
18 Using ActiveX Automation 505 --
Why Use Automation? 506 --
Distinguishing Automation Server Versus Automation Client 506 --
Determining Automation Resource Requirements 507 --
Understanding the Big Picture 507 --
Creating and Setting a Reference to Another Application 507 --
Assigning an Object Variable to an Application 512 --
Creating an Instance of the Application 513 --
Using the Automation Object's Properties and Methods 517 --
Releasing the Automation Object 517 --
Closing the Automation Server Application 519 --
Using the UserControl Property to Determine How an Application Was Opened 520 --
Using WithEvents to Expose Events of the Automation Server 520 --
Using the Automation Tips and Techniques 523 --
19 Integrating with Microsoft Office 529 --
Why Integrate with Microsoft Office? 531 --
Use the Right Tool 533 --
Using the Macro Recorder to Write Code 533 --
Using Auto Macros 535 --
Microsoft Forms 536 --
Object Browser 537 --
Class Arguments for Office Applications 537 --
Automation Example 538 --
Automating Word 540 --
Automating Excel 555 --
Automating PowerPoint 559 --
Automating Outlook 562 --
Automating Graph 567 --
20 Using Visual Basic with Access 571 --
Creating ActiveX Code Components 572 --
Creating ActiveX Controls 593 --
Part VII Multiuser Issues 615 --
21 Multiple Users and Database Locking 617 --
Understanding Multiuser Issues 618 --
Reviewing Jet's Multiuser Design 619 --
Understanding Jet's Multiuser Locking 619 --
Selecting the Proper Architecture 623 --
Working With Locks 623 --
Optimizing Multiuser Applications 631 --
Oracle/SQL Server Locking 632 --
22 Security 635 --
Elements of Security 636 --
Workgroup Creation 638 --
Users and Groups 641 --
Implementing Security Using Startup Options 649 --
Security Concerns with Replication 650 --
Security for Split Databases 651 --
Security for Client/Server 653 --
Securing a Database Step by Step 663 --
Common Security Errors 664 --
Part VIII Web Publishing with Access 2002 667 --
23 Configuring a Web Site for Web Publishing 669 --
Development Versus Production Environment 670 --
Choosing Your Platform 671 --
What Is the Option Pack? 673 --
Setting Up Your Web Server 675 --
Managing and Configuring Your Web Server 682 --
Securing Your Web Applications 692 --
What Is the Difference Between a Site and a Virtual Directory? 693 --
24 Web Enabling Access 2002 with Office Web Components 701 --
What Are the Office XP Web Components? 702 --
Using the Office Spreadsheet Control 703 --
Using the Office Chart Control 707 --
Using the Office PivotTable Control 711 --
25 Using Data Access Pages 715 --
Creating Your First Data Access Page 717 --
Implementing Interactive Drill-Downs 722 --
Incorporating the Office Web Components with DAPs 724 --
Scripting Data Access Pages 726 --
26 Web Publishing with Access 2002 and Active Server Pages 731 --
Using Active Server Pages 732 --
Understanding Active Server Pages 733 --
Getting Started with Active Server Pages 734 --
Active Server Pages 101 739 --
Real-Life Example: Establishing a Self-Maintaining Membership-Based Web Page 754 --
Access 2002 Web Publishing with XML 763 --
Creating Charts with the Chart Control 770.
Responsibility: Stephen Forte [and others].

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/47939320> # Access 2002 development unleashed
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "47939320" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/56732424#Place/indianapolis_ind> ; # Indianapolis, Ind.
   schema:about <http://dewey.info/class/005.7565/e21/> ;
   schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:about <http://experiment.worldcat.org/entity/work/data/56732424#CreativeWork/microsoft_access> ; # Microsoft Access.
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://viaf.org/viaf/5235776> ; # Stephen Forte
   schema:copyrightYear "2002" ;
   schema:datePublished "2002" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/56732424> ;
   schema:inLanguage "en" ;
   schema:name "Access 2002 development unleashed"@en ;
   schema:productID "47939320" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/47939320#PublicationEvent/indianapolis_ind_sams_2002> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/56732424#Agent/sams> ; # Sams
   schema:workExample <http://worldcat.org/isbn/9780672321207> ;
   umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA1V7012> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/47939320> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/56732424#Place/indianapolis_ind> # Indianapolis, Ind.
    a schema:Place ;
   schema:name "Indianapolis, Ind." ;
    .

<http://id.worldcat.org/fast/1371910> # Microsoft Access.
    a schema:CreativeWork ;
   schema:name "Microsoft Access." ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/5235776> # Stephen Forte
    a schema:Person ;
   schema:familyName "Forte" ;
   schema:givenName "Stephen" ;
   schema:name "Stephen Forte" ;
    .

<http://worldcat.org/isbn/9780672321207>
    a schema:ProductModel ;
   schema:isbn "0672321203" ;
   schema:isbn "9780672321207" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.