did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781592007233

Microsoft Access Vba Programming For The Absolute Beginner

by
  • ISBN13:

    9781592007233

  • ISBN10:

    1592007236

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 2005-03-14
  • Publisher: Cengage Learning Ptr
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $29.99

Summary

If you are new to programming with Microsoft Access VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the for the absolute beginner series teach the principles of programming through simple game creation. Covering Access 2003, "Microsoft Access VBA Programming for the Absolute Beginner" provides you with the skills that you need for more practical Access VBA programming applications and shows you how to put these skills to use in realworld scenarios. Best of all, by the time you finish this book, you will be able to apply the basic principles you've learned to the next programming language you tackle.

Author Biography

Michael Vine currently works full time at a Fortune 100 company as an IT Project Manager overseeing the development of enterprise data warehouses

Table of Contents

Introduction xiii
Chapter 1 ACCESS ESSENTIALS 1(34)
Getting Started with Access 2003
1(2)
System Requirements
2(1)
Migrating to Access 2003
3(1)
Your First Access Database
3(28)
Creating an Access Database
4(4)
Tables and Fields
8(4)
Relationships
12(2)
Forms
14(2)
Common Controls
16(5)
Hungarian Notation
21(1)
Bound Controls
21(2)
Startup Forms and Dashboards
23(3)
Queries
26(5)
Getting Help with Access 2003
31(1)
Chapter Summary
32(3)
Chapter 2 INTRODUCTION TO ACCESS VBA 35(32)
The Event-Driven Paradigm
35(1)
Object-Based Programming
36(1)
The VBA IDE
37(4)
Introduction to Event Procedures
39(1)
Introduction to VBA Statements
40(1)
Accessing Objects and Their Properties
41(11)
The Forms Collection
42(1)
The Me Keyword
43(1)
Assignment Statements
44(1)
Command and Label Objects
45(5)
Getting User Input with Text Boxes
50(2)
Variables and Beginning Data Types
52(7)
Variable Naming Conventions
56(1)
Variable Scope
57(1)
Option Statements
58(1)
VBA Arithmetic and Order of Operations
59(1)
Chapter Program: Fruit Stand
60(5)
Chapter Summary
65(2)
Chapter 3 CONDITIONS 67(30)
If Blocks
67(5)
Nested If Blocks
69(1)
Compound If Blocks
70(2)
Select Case Structures
72(2)
Dialog Boxes
74(5)
Message Box
74(3)
Input Box
77(2)
Common Controls Continued
79(9)
Option Group
80(2)
Option Buttons
82(3)
Check Boxes
85(2)
Toggle Buttons
87(1)
Chapter Program: Hangman
88(7)
Chapter Summary
95(2)
Chapter 4 LOOPING STRUCTURES 97(24)
Introduction to Looping Structures
97(6)
Do While
99(1)
Do Until
100(1)
Loop While
101(1)
Loop Until
102(1)
For
102(1)
List and Combo Boxes
103(8)
Adding Items
105(3)
Removing Items
108(2)
Managing Columns
110(1)
Random Numbers
111(3)
Chapter Program: Math Quiz
114(4)
Chapter Summary
118(3)
Chapter 5 FUNCTIONS CONTINUED 121(26)
String-Based Functions
121(8)
UCase
122(1)
LCase
122(2)
Len
124(1)
StrComp
125(1)
Right
126(1)
Left
127(1)
Mid
128(1)
InStr
128(1)
Date and Time Functions
129(4)
Date
130(1)
Day
130(1)
WeekDay
130(1)
Month
131(1)
Year
131(1)
Time
131(1)
Second
132(1)
Minute
132(1)
Hour
133(1)
Now
133(1)
Conversion Functions
133(2)
Val
134(1)
Str
134(1)
Chr
134(1)
Asc
135(1)
Formatting
135(5)
Formatting Strings
137(1)
Formatting Numbers
137(1)
Formatting Date and Time
138(2)
Chapter Program: Secret Message
140(4)
Chapter Summary
144(3)
Chapter 6 CODE REUSE AND DATA STRUCTURES 147(34)
Code Reuse
147(7)
Introduction to User-Defined Procedures
149(2)
Subprocedures
151(1)
Function Procedures
151(1)
Arguments and Parameters
152(2)
Standard Modules
154(3)
Arrays
157(7)
Single-Dimension Arrays
158(2)
Two-Dimensional Arrays
160(1)
Dynamic Arrays
161(2)
Passing Arrays as Arguments
163(1)
User-Defined Types
164(5)
Type and End Type Statements
164(1)
Declaring Variables of User-Defined Type
165(1)
Managing Elements
166(3)
Chapter Program: Dice
169(8)
Chapter Summary
177(4)
Chapter 7 DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING 181(32)
Debugging
181(8)
Stepping Through Code
182(1)
Breakpoints
183(2)
Immediate Window
185(1)
Locals Window
186(1)
Watch Window
186(3)
Input Validation
189(4)
IsNumeric
189(2)
Checking a Range of Values
191(2)
Error Handling
193(5)
The Err Object
195(2)
The Debug Object
197(1)
File Processing
198(7)
About Sequential File Access
199(1)
Opening a Sequential Data File
199(1)
Reading Sequential Data from a File
200(1)
Writing Sequential Data to a File
201(1)
Closing Data Files
202(1)
Error Trapping for File Access
203(2)
Chapter Program: Trivial Challenge
205(5)
Chapter Summary
210(3)
Chapter 8 MICROSOFT JET SQL 213(26)
Introduction to Jet SQL
213(3)
Data Manipulation Language
216(17)
Simple SELECT Statements
216(2)
Conditions
218(3)
Computed Fields
221(1)
Built-In Functions
222(3)
Sorting
225(2)
Grouping
227(1)
Joins
228(3)
INSERT INTO Statement
231(1)
UPDATE Statement
232(1)
DELETE Statement
232(1)
Data Definition Language
233(2)
Creating Tables
233(1)
Altering Tables
234(1)
DROP Statement
235(1)
Chapter Summary
235(4)
Chapter 9 DATABASE PROGRAMMING WITH ADO 239(38)
ADO Overview
239(1)
Connecting to a Database
240(4)
Working with Recordsets
244(1)
Introduction to Database Locks
245(18)
Introduction to Cursors
246(1)
Retrieving and Browsing Data
247(10)
Updating Records
257(2)
Adding Records
259(2)
Deleting Records
261(2)
Chapter Program: Choose My Adventure
263(11)
Chapter Summary
274(3)
Chapter 10 OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA 277(26)
Introduction to Object-Oriented Programming
277(1)
Creating Custom Objects
278(13)
Working with Class Modules
279(2)
Property Procedures
281(3)
Method Procedures
284(3)
Creating and Working with New Instances
287(4)
Working with Collections
291(3)
Adding Members to a Collection
291(1)
Removing Members from a Collection
292(1)
Accessing a Member in a Collection
293(1)
For Each Loops
293(1)
Chapter Program: Monster Dating Service
294(7)
Chapter Summary
301(2)
Chapter 11 MICROSOFT OFFICE OBJECTS 303(22)
Introduction to Microsoft Office Objects
303(1)
Assistant Object
304(9)
Balloon Object
310(3)
Command Bars
313(3)
CommandBarControl Object
314(1)
CommandBarButton Object
315(1)
FileDialog Object
316(3)
Chapter Program: Animated Math
319(4)
Chapter Summary
323(2)
Chapter 12 INTRODUCTION TO DATA ACCESS PAGES AND ACCESS SECURITY 325(24)
Introduction to Data Access Pages
325(11)
Creating Data Access Pages
327(4)
Adding Group Levels
331(4)
Publishing Data Access Pages
335(1)
Introduction to Access Security
336(10)
Activating Logon Procedures
336(2)
Enabling User-Level Security
338(4)
Connecting to a Workgroup
342(2)
Securing Access from Data Access Pages
344(2)
Chapter Summary
346(3)
Appendix A COMMON CHARACTER CODES 349(2)
Appendix B KEYBOARD SHORTCUTS FOR THE CODE WINDOW 351(2)
Appendix C TRAPPABLE ERRORS 353(6)
INDEX 359

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program