Microsoft Access VBA Programming for the Absolute Beginner
Microsoft Access VBA Programming for the Absolute Beginner
ISBN: 1598633937
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: Michael Vine
- BackCover
- BackCover
- Access VBAProgramming
- Introduction
- Who Should Read This Book?
- Part I: Understanding the MS Access Environment
- Chapter 1: Introduction toVBA for Applications
- History of Microsoft Access
- Developing in Access
- The Future of Microsoft Access
- Summary
- Chapter 2: Designing anAccess Application
- Steps in the Development Process
- Definition and Analysis of Requirements
- Evaluation of Requirements
- Development of the Design
- Implementation and Testing
- Documentation
- Maintenance
- Summary
- Chapter 3: Access DevelopmentWithout VBA
- System Architecture
- Understanding a Database Application
- Working Without VBA
- Events
- Naming Conventions
- Predefined Templates
- Switchboard Manager
- Summary
- Chapter 4: Customizing theAccess Environment
- Customizing Shortcut Menus
- Creating Menus
- Attaching Code to a Custom Menu Item
- Summary
- Part II: Understanding the Visual Basic forApplications Environment
- Chapter 5: Introducing the VBAProgramming Environment
- Introduction to VBA
- The VBA Model
- The Concept of Objects
- The VBA Editor
- Summary
- Chapter 6: Programming Fundamentals Using VBA
- Control Structures
- Arrays
- Summary
- Chapter 7: Understanding theVisual Basic Editor
- Highlights of the Menu System
- The Debug, Edit, and UserForm Toolbars
- The Project Explorer
- Managing Modules
- Properties Window
- The Object Browser
- References
- Using VBA Editor Options
- Getting Help
- Starting a New Procedure in the VBA Editor
- Summary
- Chapter 8: VBA LanguageComponents
- Objects in VBA
- Intrinsic Constants
- Basic VBA Programs Using Forms
- Connecting with Microsoft Access
- SQL (Structured Query Language)
- SQL and VBA
- Output
- Summary
- Chapter 9: Sub Procedures
- Declaring a Procedure
- Functions
- Parameters
- Design and Scope
- Global and Static Variables
- Using Procedures to Change a Database Structure
- Summary
- Chapter 10: Debugging VBACode
- The Err Object
- The Errors Collection
- Tools for Debugging Code
- Summary
- Chapter 11: FunctionProcedures
- Subs vs. Functions
- Built-in Functions
- Date and Time Functions
- Payment Function
- Summary
- Part III: Interacting with VBA
- Chapter 12: Forms
- Assigning Recordsets Dynamically
- Appending and Editing Data
- Controlling Controls in Forms
- Summary
- Chapter 13: Reports
- Anatomy of a Report
- Report Wizard
- Specialized Reports
- Calling the Report from VBA
- Creating a Report Programmatically
- Summary
- Chapter 14: Menus andToolbars
- Creating a Toolbar
- Menus
- Submenus
- Summary
- Chapter 15: Changing theAccess Environment
- Changing Options
- Summary
- Part IV: Advanced Access Programming Techniques
- Chapter 16: DatabaseSecurity
- Access and Security
- User-Level Security
- Security and Access 2003
- Summary
- Chapter 17: Access and theMicrosoft Office Environment
- Shared Objects
- Connecting with Other Microsoft Office Products
- Summary
- Chapter 18: Access and theWeb
- The Mechanics of the Web
- Data Access Pages
- XML (Extended Markup Language)
- Summary
- Chapter 19: Upgrading
- Microsoft Access vs. SQL Server
- Access Data Projects
- Working with an ADP File
- Summary
- Part V: Application Development
- Chapter 20: MultiuserApplications
- Sharing the Database
- Handling Resource Contention and Conflicts
- Improving Application Performance
- Summary
- Chapter 21: BeyondMicrosoft Access
- VBA and Microsoft Office
- Visual Basic
- VBScript
- Transition to Microsoft .NET
- Summary
- Appendix: The DoCmd Object
- AddMenu
- ApplyFilter
- Beep
- CancelEvent
- Close
- CopyDatabaseFile
- CopyObject
- DeleteObject
- DoMenuItem
- Echo
- FindNext
- FindRecord
- GoToControl
- GoToPage
- GoToRecord
- Hourglass
- Maximize
- Minimize
- MoveSize
- OpenDataAccessPage
- OpenDiagram
- OpenForm
- OpenFunction
- OpenModule
- OpenQuery
- OpenReport
- OpenStoredProcedure
- OpenTable
- OpenView
- OutputTo
- PrintOut
- Quit
- Rename
- RepaintObject
- Requery
- Restore
- RunCommand
- RunMacro
- RunSQL
- Save
- SelectObject
- SendObject
- SetMenuItem
- SetWarnings
- ShowAllRecords
- ShowToolbar
- TransferDatabase
- TransferSpreadsheet
- TransferSQLDatabase
- TransferText
- Index
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- List of Figures
- List of Tables
Microsoft Access VBA Programming for the Absolute Beginner
ISBN: 1598633937
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: Michael Vine