Flylib.com
Microsoft Access VBA Programming for the Absolute Beginner
Microsoft Access VBA Programming for the Absolute Beginner
ISBN: 1598633937
EAN: 2147483647
Year: 2006
Pages: 214
Authors:
Michael Vine
BUY ON AMAZON
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
Year: 2006
Pages: 214
Authors:
Michael Vine
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Making Programs Think Branching Statements and Subroutines
Number Crunching Mathematical and Relational Operators and Commands
Playing Intro Movies and Cut-Scenes
Multiplayer Programming The Crazy Carnage Game
Epilogue
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Filling Out Forms
Laying Out Forms
Adding Basic Controls and Lists
Formatting Forms
Connecting Forms to Databases
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Initial Startup and Common Pitfalls
Auditing the Kanban
Appendix C Two-Bin Kanban Systems
Appendix D Organizational Changes Required for Kanban
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Team change
Organizational change
Part II - The Applications
Cultural change
IT-based process change
An Introduction to Design Patterns in C++ with Qt 4
Identifiers, Types, and Literals
Composite Pattern: Parents and Children
Type Identification and qobject_cast
public, protected, and private Derivation
Points of Departure
Understanding Digital Signal Processing (2nd Edition)
WINDOWS
Chapter Eight. Quadrature Signals
THE ZOOM FFT
DESIGNING VERY HIGH-ORDER FIR FILTERS
Section D.1. STATISTICAL MEASURES
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies