Skip to content

Microsoft Acess 2002 Programming in 24 Hours

ISBN-10: 0672320983

ISBN-13: 9780672320989

Edition: 2002

Authors: Paul Kimmel

List price: $29.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Offering practical solutions for the non-programmer who wants to move into programming, this text shows how to increase the effectiveness and reliability of Access applications.
Customers also bought

Book details

List price: $29.99
Copyright year: 2002
Publisher: Pearson Education
Publication date: 8/14/2001
Binding: Paperback
Pages: 576
Size: 7.50" wide x 9.25" long x 1.25" tall
Weight: 2.134
Language: English

Introduction
Access Programming 101
What's New in Access 2002
New Side Panes for Easier Navigation
Customizing Menus and Toolbars
Spell-Checking Data
Editing Options
Speech Command and Control
Collaborating Online
Network Places
Remove Author Information
Introducing ActiveX Data Objects
Programming Objects
Adding Data to Web Pages
Access Projects
Summary
QandA
Workshop
Exploring VBA
Understanding How Access VBA Works
Learning Access VBA Keywords
Access Operators and Operands
Data: What a Program Knows
Putting It All Together
Prelude to Advanced Topics
Summary
QandA
Workshop
Storing Your Program's Data
How Memory Is Used
Declaring Variables
Data Assignment and Evaluation
Be Explicit
Using Pop-up Hints
Using the Locals Window
Using the Watches Window
Running Code in the Immediate Window
Employing the Call Stack
Summary
QandA
Workshop
Controlling Program Flow and Performing Calculations
What Goes into an Equation
Understanding Operator Count
Using Arithmetic Operators
Performing Comparisons
The Truth of Logical Operators
Concatenate It
Who Has Precedence Here?
Special Operators
Summary
QandA
Workshop
Writing Code to Manage Your Access Data
Learning to Write Conditional Code
A Programmer's Traffic Cop
Tidying Up Nested Conditional Statements
Want to Go for a Spin?
Take It Once Around the Block
Iterating Through Data
Iterating Collections of Data
Short-circuiting Code
Using the Switch Function
Summary
QandA
Workshop
Managing Your Database
Access 2002 Is Backward Compatible with Access 2000
Creating a Database
Managing a Table with Code
Iteratively Inputting User Data
Using Conditional Code to Find Data
Summary
QandA
Workshop
Using Advanced Data Types to Manage Data
Understanding OLE Automation
Using the ADODB Object
Using the ADOX Object
Summary
QandA
Workshop
Using Access Resources to Get the Job Done
Solving Problems a Piece at a Time
The Mechanics of Writing Subroutines
The Mechanics of Writing Functions
Programming Rules of Thumb
Tying It All Together
Summary
QandA
Workshop
Using Macros As Learning Aids
Creating a Macro 101
Using CopyObject
Using DeleteObject
The Keys to the City
Importing Data
Using Macro Resources in Code
To Macro or Not to Macro
Summary
QandA
Workshop
Employing Access Predefined Solutions
Using String-Handling Functions
Formatting Data
Using Date and Time Functions
Managing File I/O
Dynamic User Input Functions
Using Function, Method, Property, and Statement References
Summary
QandA
Workshop
Defining Data Types and Using Arrays and Collections
Making the Complex Simple: Creating Your Own Data Types
Understanding Aggregation
Using the Type Declaration
What Kind of Data Can Go into My Type?
Declaring Instances of User Types
Defining Enumerated Types
Putting It All Together
Summary
QandA
Workshop
Managing Varying Amounts of Data
Understanding Arrays
Declaring Arrays
Using Arrays to Store Data
Functions for Managing Arrays
Returning Arrays from a Function
Things You Should Do When Using Arrays
Sorting Array Data
Summary
QandA
Workshop
Storing Information in a Collection
Understanding Collections
Declaring Collection Variables
Managing a Data Collection
Places You'll Find Collections
Summary
QandA
Workshop
Database Programming in Access
Managing Your Code
Naming Conventions
Using Whitespace Consistently
Managing Complexity
Commenting Guidelines
Understanding the Benefits of Code Reuse
Testing and Debugging
Managing Data
Summary
QandA
Workshop
Data Programming Made Easy with ADODB
Connecting to a Database
Managing a Recordset
Finding Records
Copying Data to a Collection Object
Using AddItem and RemovItem
Finding ActiveX Data Objects Resources Online
Summary
QandA
Workshop
Using Advanced SQL Techniques
Using the SELECT Statement
Inserting New Data
Updating Data
Deleting Data
Calling Functions in SQL Code
Writing Stored Procedures
Querying a SQL Server Database
Summary
QandA
Workshop
Master Error Handling
Removing Bugs
Scaffolding
Trapping Code
Tracing Code
Asserting Assumptions
Using Compiler Directives
Making Debug Code Read-Only
Development Versus Deployment Error Handling
Summary
QandA
Workshop
Adding Code to Handle Errors
Comparing Error-Handling Styles
Writing Error Handlers
Clearing the Error Handler
Writing Silent Error Handlers
Using the Err Object
Using Error Handlers to Validate User Input
Creating the Resource-Protection Block Idiom
Reviewing the Debug Object
Summary
QandA
Workshop
Creating Access User Interfaces
Creating Custom Forms and Reports
Using Form Wizards
Customizing Wizard Forms
Testing Your Form
Defining a Report
Setting the Startup Point for Your Program
Summary
QandA
Workshop
Adding Data to Web Pages
Comparing Intranets to Internets
Understanding Web Pages
Building the Database Used for the Demo
Using Wizards to Generate Web Pages
Using Web Page Design Tools
Adding a PivotTable to Web Pages
XML's Role in Access
Summary
QandA
Workshop
Object-Oriented Programming in Access
Class Programming Basics
Understanding the Need for Classes
Creating Your First Class
Hiding Information to Make Code Easier to Use
Defining Class Methods
Defining Properties
Writing Initialization and Termination Code
Writing a New Class
Creating an Instance of a Class
Summary
QandA
Workshop
Adding Capabilities to Your Data Types
Defining the Objective
Understanding When to Write a Class
Applying Basic Principles of Object-Oriented Design
Extending Existing Classes
Testing Your New Class
Using the Strings Class
Summary
QandA
Workshop
Writing Access Add-Ins
Introducing Add-Ins
Defining an Error-Logging Database
Defining a Viewer for the Error Log
Testing the Error Logging Add-In Database
Installing and Uninstalling Add-ins
Going for a Test Drive
Summarizing the Process
Summary
QandA
Workshop
Managing Outlook Contact Information
Understanding Outlook 2002
Introducing the Outlook Object Model
Viewing Outlook Contacts in Access
Updating Outlook Information
Searching the Body of a Mail Item
Undeleting Mail Items
Sending Mail to Contacts Automatically
Summary
QandA
Workshop
Appendix
Answers
Index