Log In
Or create an account -> 
Imperial Library
  • Home
  • About
  • News
  • Upload
  • Forum
  • Help
  • Login/SignUp

Index
Title Contents Acknowledgements Introduction
Is This Book for You? Conventions Used in This Book Icons and Alerts How This Book Is Organized Guide to the Examples
Part I: Access Building Blocks Chapter 1: An Introduction to Database Development
The Database Terminology of Access Relational Databases Access Database Objects and Views A Five-Step Design Method Summary
Chapter 2: Creating Access Tables
Getting Started with Access 2007 Creating a Database The Access 2007 Environment Creating a New Table Creating tblContacts Changing a Table Design Understanding tblContacts Field Properties Setting the Primary Key Indexing Access Tables Printing a Table Design Saving the Completed Table Manipulating Tables in a Database Window Adding Records to a Database Table Understanding the Attachment Data Type Summary
Chapter 3: Designing Bulletproof Databases
Data Normalization Table Relationships Integrity Rules Understanding Keys Summary
Chapter 4: Selecting Data with Queries
Understanding Queries Creating a Query Selecting Fields Displaying the Recordset Working with Fields Changing the Sort Order Displaying Only Selected Records Printing a Query’s Recordset Saving a Query Adding More Than One Table to a Query Working with the Table/Query Pane Adding Fields from More Than One Table Understanding Multi-Table Query Limitations Creating and Working with Query Joins Understanding Table Join Types Summary
Chapter 5: Using Operators and Expressions in Access
What Are Operators? Moving beyond Simple Queries Entering Single-Value Field Criteria Entering Multiple Criteria in One Field Entering Criteria in Multiple Fields Creating a New Calculated Field in a Query Summary
Chapter 6: Working with Datasheet View
Understanding Datasheets The Datasheet Window Opening a Datasheet Entering New Data Navigating Records in a Datasheet Changing Values in a Datasheet Using the Undo Feature Copying and Pasting Values Replacing Values Adding New Records Deleting Records Displaying Records Sorting and Filtering Records in a Datasheet Printing Records Summary
Chapter 7: Creating Basic Access Forms
Adding Forms Using the Ribbon Adding Controls Selecting Controls Manipulating Controls Understanding Properties Summary
Chapter 8: Working with Data on Access Forms
Using Form View Changing Values in a Form Printing a Form Working with Form Properties Adding a Form Header or Footer Changing the Layout Creating a Calculated Control Converting a Form to a Report Summary
Chapter 9: Presenting Data with Access Reports
Understanding Reports Creating a Report with Report Wizards Printing a Report Saving the Report Starting with a Blank Form Banded Report Writer Concepts Creating a Report from Scratch Making the Report Presentation Quality Summary
Part II: Programming Microsoft Access Chapter 10: VBA Programming Fundamentals
Understanding the Limitations of Macros Introducing Visual Basic for Applications Understanding VBA Terminology Migrating from Macros to VBA Creating VBA Programs Understanding VBA Branching Constructs Repetitive Looping Working with Objects and Collections Using Compiler Directives Access 2007 Options for Developers Summary
Chapter 11: Mastering VBA Data Types and Procedures
The Access VBA Editor Using Variables Working with Data Types Understanding Subs and Functions Creating Functions Creating a Function to Calculate Taxes Summary
Chapter 12: Understanding the Access Event Model
Programming Events Common Events Form Event Procedures Control Event Procedures Event Order Report Event Procedures Report Section Event Procedures Summary
Chapter 13: Using Expressions in Queries and VBA Code
Understanding Expressions Understanding Functions Summary
Chapter 14: Accessing Data with VBA Code
Understanding SQL Creating Programs to Update a Table Summary
Chapter 15: Using the VBA Debugging Tools
Testing and Debugging Your Applications Understanding the Sources of Errors Using the Module Options Compiling VBA Code Traditional Debugging Techniques Using the Access Debugging Tools Summary
Part III: More Advanced Access Techniques Chapter 16: Working with External Data
Access and External Data Linking External Data Working with Linked Tables Using Code to Link Tables in Access Summary
Chapter 17: Importing and Exporting Data
Types of Imports and Exports Importing External Data Exporting to External Formats Summary
Chapter 18: Advanced Access Query Techniques
Using Calculated Fields Finding the Number of Records in a Table or Query Finding the Top (n) Records in a Query How Queries Save Field Selections Setting Query Properties Creating Queries That Calculate Totals Crosstab Queries Duplicate and Unmatched Queries SQL-Specific Queries Action Queries Summary
Chapter 19: Advanced Access Form Techniques
Setting Control Properties Working with Subforms Form Design Techniques Advanced Forms Techniques Using the Tab Control Using Dialog Boxes to Collect Information Summary
Chapter 20: Advanced Access Report Techniques
Hide Repeating Information Alphabetically Group Data Group on Date Intervals Create Numbered Lists Add Bullet Characters Add Emphasis at Runtime Hide a Page Header Avoid Empty Reports Start a New Page Number for Each Group Avoid Null Values in a Tabular Report Add More Information to Report Add the User’s Name to a Bound Report Add Vertical Lines between Columns Add a Blank Line Every n Records Even-Odd Page Printing Display All Reports in a Combo Box Use Different Formats in the Same Text Box Fast Printing from Queried Data Hide Forms during Print Preview A Few Quick Report Tips Use Snaking Columns in a Report Exploiting Two-Pass Report Processing Summary
Chapter 21: Building Multiuser Applications
Network Issues Database Open Options Splitting Databases for Network Access Locking Issues Record-Lock Error Handling Using Unbound Forms in Multiuser Environments Summary
Chapter 22: Integrating Access with Other Applications
Using Automation to Integrate with Office An Automation Example Using Word Collecting Data with Outlook 2007 Summary
Chapter 23: Integrating Access with SharePoint
What Is SharePoint? SharePoint Applications: Types of Web Sites What Is a SharePoint List? Introducing a SharePoint Services Web Site Integrating Access 2007 and SharePoint SharePoint and Different Operating Systems SharePoint Lists as External Data Summary
Chapter 24: Using ActiveX Controls
Understanding Objects Embedding Objects Linking Objects Creating a Graph or Chart Embedding a Graph in a Form Integration with Microsoft Office Summary
Chapter 25: Handling Errors and Exceptions
Dealing with Errors Which Errors Can Be Detected? Trapping Errors with VBA Summary
Part IV: Professional Database Development Chapter 26: Optimizing Access Applications
Understanding Module Load on Demand Using the Access 2007 Database File Format Distributing .accde Files Understanding the Compiled State Improving Absolute Speed Improving Perceived Speed Working with Large Program Databases in Access 2007 Summary
Chapter 27: Advanced Data Access with VBA
Adding an Unbound Combo Box Using the FindRecord Method Using the Bookmark to Locate a Record Filtering a Form Using Code Using a Query to Filter a Form Interactively Summary
Chapter 28: Bulletproofing Access Applications
What Is Bulletproofing? Characteristics of Bulletproof Applications Bulletproofing Goes Beyond Code Principles of Bulletproofing Develop to a Specification Securing the Environment Setting Startup Options in Code Disable Startup Bypass Providing User Feedback Adding Logging to Applications Summary
Chapter 29: Securing Access Applications
Understanding Jet Security Choosing a Security Level to Implement Creating a Database Password Using the /runtime Option Using the Current Database Options Using the Jet User-Level Security Model Using the Access Security Wizard Encrypting/Encoding a Database Decrypting/Decoding a Database Protecting Visual Basic Code Preventing Virus Infections Summary
Chapter 30: Using the Windows API
What Is the Windows API? Why Use the Windows API? DLL Documentation How to Use the Windows API API Examples Summary
Chapter 31: Using the Access Replication Features
Understanding Replication A Replication Demonstration Replication Pros and Cons Introducing the Access Replication Tools Creating a Replica Set Understanding Database Security in Replication Sets The Importance of Local Objects Resolving Replication Conflicts Replication Topologies Replication from the Developer’s Perspective Understanding the Changes to Database Objects Changes to the Design Master Structure Programming Replication Partial Replicas Advanced Replication Considerations Summary
Chapter 32: Object-Oriented Programming with VBA
Benefits of Object-Oriented Programming Other Advantages of Object-Oriented Programming Techniques Object-Oriented Programming Rules Using Property Procedures Extending the Product Class Product Methods Class Events Adding Events to Class Modules Summary
Chapter 33: Reusing VBA Code with Libraries
What Are Libraries? Creating Library Databases Debugging Library Databases Library Database Object References Summary
Chapter 34: Customizing Access Ribbons
Why Replace Toolbars and Menus? Working with the Access 2007 Ribbon Working with the Quick Access Toolbar Access 2007 Ribbons: The Developer’s Perspective The Ribbon Hierarchy Getting Started with Access 2007 Ribbons The Basic Ribbon XML Adding Ribbon Controls Using Visual Web Developer 2005 Managing Ribbons Completely Removing the Access 2007 Ribbon Summary
Chapter 35: Distributing Access Applications
Defining the Current Database Options Testing the Application before Distribution Polishing Your Application Bulletproofing an Application Summary
Chapter 36: Using Access Macros
Understanding Macros Multiaction Macros Macro Names Using Conditions Using Temporary Variables Handling Errors and Debugging Macros Embedded Macros Macros versus VBA Statements Summary
Part V: Access as an Enterprise Platform Chapter 37: Using XML in Access 2007
Introducing HTML and XML DAO, ADO, ADO.Net, Access 2007, and XML Summary
Chapter 38: SharePoint as a Data Source
Building Access Interfaces with SharePoint SharePoint Application Types Microsoft SharePoint Designer 2007 Summary
Chapter 39: Client/Server Concepts
The Parts of Client/Server Architecture Multitier Architecture What Is an OLTP Database? Access, Client/Server, and Multiple Tiers Summary
Chapter 40: SQL Server as an Access Companion
Connecting to SQL Server Working with SQL Server Objects from Access Summary
Chapter 41: Upsizing Access Databases to SQL Server
Upsizing Access and the Upsizing Wizard Summary
Part VI: Appendixes Appendix A: Access 2007 Specifications
Microsoft Access Database Specifications Access Data Projects (ADP) Specifications Microsoft SQL Server 2005 Database Specifications
Appendix B: What’s on the CD-ROM
System Requirements Using the CD Files and Software on the CD Troubleshooting
Appendix C: What’s New in Access 2007
The User Interface Tables Datasheet View Forms Reports Macros Security SharePoint Summary
Wiley Publishing, Inc. End-User License Agreement Further Reading
  • ← Prev
  • Back
  • Next →
  • ← Prev
  • Back
  • Next →

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab.

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion