|
" Access 2007 programming by example with VBA, XML, and ASP / "
Julitta Korol.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1047780
|
| Doc. No
|
:
|
b802150
|
| Main Entry
|
:
|
Korol, Julitta.
|
| Title & Author
|
:
|
Access 2007 programming by example with VBA, XML, and ASP /\ Julitta Korol.
|
| Publication Statement
|
:
|
Plano, Tex. :: Wordware Pub.,, ©2008.
|
| Series Statement
|
:
|
Wordware's database library
|
| Page. NO
|
:
|
1 online resource.
|
| ISBN
|
:
|
143568141X
|
|
|
:
|
: 159822042X
|
|
|
:
|
: 9781435681415
|
|
|
:
|
: 9781598220421
|
| Contents
|
:
|
-- The IsArray Function -- The Erase Function -- The LBound and UBound Functions -- Errors in Arrays -- Parameter Arrays -- Chapter Summary -- Chapter 8: Custom Collections and Class Modules -- Terminology -- Working with Collections -- Declaring a Custom Collection -- Adding Objects to a Custom Collection -- Removing Objects from a Custom Collection -- Creating Custom Objects -- Creating a Class -- Variable Declarations -- Defining the Properties for the Class -- Creating the Property Get Procedures -- Creating the Property Let Procedures -- Creating the Class Methods -- Creating an Instance of a Class -- Event Procedures in the Class Module -- Creating the User Interface -- Running the Custom Application -- Watching the Execution of Your VBA Procedures -- Chapter Summary -- Chapter 9: Debugging VBA Procedures and Handling Errors -- Testing VBA Procedures -- Stopping a Procedure -- Using Breakpoints -- Removing Breakpoints -- Using the Immediate Window in Break Mode -- Using the Stop Statement -- Adding Watch Expressions -- Removing Watch Expressions -- Using QuickWatch -- Using the Locals Window and the Call Stack Dialog Box -- Stepping Through VBA Procedures -- Stepping Over a Procedure -- Stepping Out of a Procedure -- Running a Procedure to Cursor -- Setting the Next Statement -- Showing the Next Statement -- Stopping and Resetting VBA Procedures -- Understanding and Using Conditional Compilation -- Navigating with Bookmarks -- Trapping Errors -- Generating Errors to Test Error Handling -- Chapter Summary -- Part II -- Access VBA Programming with DAO and ADO -- Chapter 10: Data Access Technologies in Microsoft Access -- Understanding Database Engines: Jet/ACE -- Understanding Access Versions and File Formats -- Understanding Library References -- Overview of Object Libraries in Microsoft Access -- The Visual Basic for Applications Object Library (VBA) -- The Microsoft Access 12.0 Object Library -- Microsoft Office 12.0 Access Database Engine Object Library -- The Microsoft Access DAO 3.6 Object Library -- The Microsoft ActiveX Data Objects 2.7 Library (ADO) -- Creating a Reference to the ADO Library -- Understanding Connection Strings -- Using ODBC Connection Strings -- Creating and Using ODBC DSN Connections -- Creating and Using DSN-less ODBC Connections -- Using OLE DB Connection Strings -- Connection String via a Data Link File -- Opening Microsoft Access Databases -- Opening a Microsoft Jet Database in Read/Write Mode with DAO -- Opening a Microsoft Jet Database in Read/Write Mode with ADO -- Opening a Microsoft Access Database in Read-Only Mode with DAO -- Opening a Microsoft Jet Database in Read-Only Mode with ADO -- Opening a Microsoft Jet Database Secured with a Password -- Opening a Microsoft Jet Database with User-Level Security -- Connecting to the Current Access Database -- Opening Other Databases, Spreadsheets, and Text Files from Access 2007 -- Connecting to an SQL Server Database -- Opening a Microsoft Excel Spreadsheet -- Opening a Text File Using ADO -- Creating a New Access Database -- Creating a Database with DAO -- Creating a Database with ADO -- Copying a Database -- Copying a Database with DAO -- Copying a Database with File System Object -- Database Errors -- Compacting a Database -- Chapter Summary -- Chapter 11: Creating and Accessing Database Tables and Fields -- Creating a Microsoft Access Table and Setting Field Properties (DAO Method) -- Creating a Microsoft Access Table and Setting Field Properties (ADO Method) -- Copying a Table -- Deleting a Database Table -- Adding New Fields to an Existing Table -- Removing a Field from a Table -- Retrieving Table Properties -- Retrieving Field Properties -- Linking a Microsoft Access Table -- Linking a dBASE Table -- Linking a Microsoft Excel Spreadsheet -- Listing Database Tables -- Listing Tables and Fields -- Listing Data Types -- Changing the AutoNumber -- Chapter Summary -- Chapter 12: Setting Up Primary Keys, Indexes, and Table Relationships -- Creating a Primary Key Index -- Creating a Single-Field Index -- Adding a Multiple-Field Index to a Table -- Listing Indexes in a Table -- Deleting Table Indexes -- Creating Table Relationships -- Chapter Summary -- Chapter 13: Finding and Reading Records -- Introduction to DAO Recordsets -- Opening and Closing Various Types of Recordsets -- Opening a Snapshot and Counting Records -- Retrieving the Contents of a Specific Field in a Table -- Moving between Records in a Table -- Finding Records in a Table-Type Recordset -- Finding Records in Dynasets or Snapshots -- Finding the nth Record in a Dynaset or Snapshot -- Introduction to ADO Recordsets -- Cursor Types -- Lock Types -- Cursor Location -- The Options Parameter -- Opening a Recordset -- Opening a Recordset Based on a Table or Query -- Opening a Recordset Based on an SQL Statement -- Opening a Recordset Based on Criteria -- Opening a Recordset Directly -- Moving Around in a Recordset -- Finding the Record Position -- Reading Data from a Field -- Returning a Recordset as a String -- Finding Records Using the Find Method -- Finding Records Using the Seek Method -- Finding a Record Based on Multiple Conditions -- Using Bookmarks -- Using Bookmarks to Filter a Recordset -- Using the GetRows Method to Fill the Recordset -- Chapter Summary -- Chapter 14: Working with Records -- Adding a New Record with DAO -- Adding a New Record with ADO -- Modifying a Record with DAO -- Modifying a Record with ADO -- Editing Multiple Records with ADO -- Deleting a Record with DAO -- Deleting a Record with ADO -- Copying Records to an Excel Spreadsheet -- Copying Records to a Word Document -- Copying Records to a Text File -- Filtering Records Using the SQLWHERE Claus -- Filtering Records Using the Filter Property -- Sorting Records -- Chapter Summary -- Chapter 15: Creating and Running Queries with DAO/ADO -- Creating a Select Query Manually -- Creating a Select Query with DAO -- Creating a Select Query with ADO -- Executing an Existing Select Query with ADO -- Modifying an Existing Query.
|
|
|
:
|
Machine derived contents note: Table of Contents -- Acknowledgments -- Introduction -- Part I -- Introduction to Access 2007 VBA Programming -- Chapter 1: Writing Procedures in Modules -- Procedure Types -- Module Types -- Standard Modules -- Writing Procedures in a Standard Module -- Executing Your Procedures and Functions -- Class Modules -- Events, Event Properties, and Event Procedures -- Why Use Events? -- Walking Through an Event Procedure -- Compiling Your Procedures -- Placing a Database in a Trusted Location -- Chapter Summary -- Chapter 2: The Visual Basic Editor (VBE) -- Understanding the Project Explorer Window -- Understanding the Properties Window -- Understanding the Code Window -- Other Windows in the VBE -- On-the-Fly Syntax and Programming Assistance -- List Properties/Methods -- Parameter Info -- List Constants -- Quick Info -- Complete Word -- Indent/Outdent -- Comment Block/Uncomment Block -- Using the Object Browser -- Using the VBA Object Library -- Using the Immediate Window -- Chapter Summary -- Chapter 3: Variables, Data Types, and Constants -- What Is a Variable? -- What Are Data Types? -- Creating Variables -- Declaring Variables -- Specifying the Data Type of a Variable -- Using Type Declaration Characters -- Assigning Values to Variables -- Forcing Declaration of Variables -- Understanding the Scope and Lifetime of Variables -- Procedure-Level (Local) Variables -- Module-Level Variables -- Public (Global) Variables -- Understanding and Using Temporary Variables -- Creating a Temporary Variable with a TempVars Collection Object -- Retrieving Names and Values of TempVar Objects -- Using Temporary Global Variables in Expressions -- Removing a Temporary Variable from a TempVars Collection Object -- Understanding and Using Static Variables -- Understanding and Using Object Variables -- Finding a Variable Definition -- What Type Is This Variable? -- Using Constants in VBA Procedures -- Intrinsic Constants -- Grouping Constants with the Enum Type -- Chapter Summary -- Chapter 4: Passing Arguments to Procedures and Functions -- Writing a Function Procedure -- Specifying the Data Type for a Function's Result -- Passing Arguments by Reference and by Value -- Using Optional Arguments -- Using the IsMissing Function -- Built-in Functions -- Using the MsgBox Function -- Returning Values from the MsgBox Function -- Using the InputBox Function -- Converting Data Types -- Using Master Procedures and Subprocedures -- Chapter Summary -- Chapter 5: Decision Making with VBA -- If.Then Statement -- Multi-Line If.Then Statement -- Decisions Based on More Than One Condition -- If.Then.Else Statement -- If.Then.ElseIf Statement -- Nested If.Then Statements -- Select Case Statement -- Using Is with the Case Clause -- Specifying a Range of Values in a Case Clause -- Specifying Multiple Expressions in a Case Clause -- Chapter Summary -- Chapter 6: Repeating Actions in VBA -- Using the Do.While Statement -- Another Approach to the Do.While Statement -- Using the Do.Until Statement -- Another Approach to the Do.Until Statement -- For.Next Statement -- ForEach.Next Statement -- Exiting Loops Early -- Nested Loops -- Chapter Summary -- Chapter 7: Working with Arrays -- Declaring Arrays -- Array Upper and Lower Bounds -- Using Arrays in VBA Procedures -- Arrays and Looping Statements -- Using a Two-Dimensional Array -- Static and Dynamic Arrays -- Array Functions -- The Array Function.
|
| Abstract
|
:
|
"Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can be created, managed, and customized with Visual Basic for Applications (VBA) a powerful programming language built into Access. Hundreds of hands-on examples and projects throughout the book show users how to take charge of their Access databases with programming. Learn how to: Write and debug your programming code with the Visual Basic Editor. Access and manipulate databases with Data Access Objects (DAO) and ActiveX Data Objects (ADO). Use the Data Definition Language (DDL) to enforce data integrity and manage database security. Modify the behavior of forms, reports, and controls by writing event procedures. Publish dynamic Access data to the web using Active Server Pages (ASP) and Extensible Markup Language (XML). Work with the new features for tables, forms, reports, macros, and templates that are available in the Access 2007 user interface."--Resource description page.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
XML (Document markup language)
|
| Subject
|
:
|
Computer Science.
|
| Subject
|
:
|
COMPUTERS-- Programming Languages-- SQL.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Engineering Applied Sciences.
|
| Subject
|
:
|
XML (Document markup language)
|
| Subject
|
:
|
XML (Document markup language)
|
| Subject
|
:
|
Active server pages.
|
|
|
:
|
Microsoft Access.
|
|
|
:
|
Microsoft Visual Basic for applications.
|
|
|
:
|
Active server pages.
|
|
|
:
|
Active server pages.
|
|
|
:
|
Microsoft Access.
|
|
|
:
|
Microsoft Access.
|
|
|
:
|
Microsoft Visual Basic for applications.
|
|
|
:
|
Microsoft Visual Basic for applications.
|
| Dewey Classification
|
:
|
005.75/65
|
| LC Classification
|
:
|
QA76.9.D3K65733 2008eb
|
| |