Amazon no longer offers textbook rentals. We do!

Microsoft Access Vba Programming For The Absolute Beginner

by: Vine, Michael

Microsoft Access Vba Programming For The Absolute Beginner

by: Vine, Michael

ISBN 13:
9781592007233
ISBN 10:
1592007236
Edition: 2nd
Format: Paperback
Copyright: 03/14/2005
Publisher: Cengage Learning Ptr
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

Introduction

xiii

Chapter 1 ACCESS ESSENTIALS

(34)

Getting Started with Access 2003

(2)

System Requirements

(1)

Migrating to Access 2003

(1)

Your First Access Database

(28)

Creating an Access Database

(4)

Tables and Fields

(4)

Relationships

(2)

Forms

(2)

Common Controls

(5)

Hungarian Notation

(1)

Bound Controls

(2)

Startup Forms and Dashboards

(3)

Queries

(5)

Getting Help with Access 2003

(1)

Chapter Summary

(3)

Chapter 2 INTRODUCTION TO ACCESS VBA

(32)

The Event-Driven Paradigm

(1)

Object-Based Programming

(1)

The VBA IDE

(4)

Introduction to Event Procedures

(1)

Introduction to VBA Statements

(1)

Accessing Objects and Their Properties

(11)

The Forms Collection

(1)

The Me Keyword

(1)

Assignment Statements

(1)

Command and Label Objects

(5)

Getting User Input with Text Boxes

(2)

Variables and Beginning Data Types

(7)

Variable Naming Conventions

(1)

Variable Scope

(1)

Option Statements

(1)

VBA Arithmetic and Order of Operations

(1)

Chapter Program: Fruit Stand

(5)

Chapter Summary

(2)

Chapter 3 CONDITIONS

(30)

If Blocks

(5)

Nested If Blocks

(1)

Compound If Blocks

(2)

Select Case Structures

(2)

Dialog Boxes

(5)

Message Box

(3)

Input Box

(2)

Common Controls Continued

(9)

Option Group

(2)

Option Buttons

(3)

Check Boxes

(2)

Toggle Buttons

(1)

Chapter Program: Hangman

(7)

Chapter Summary

(2)

Chapter 4 LOOPING STRUCTURES

(24)

Introduction to Looping Structures

(6)

Do While

(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

Amazon no longer offers textbook rentals. We do!

Microsoft Access Vba Programming For The Absolute Beginner

Microsoft Access Vba Programming For The Absolute Beginner

9781592007233

1592007236

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Microsoft Access Vba Programming For The Absolute Beginner

Microsoft Access Vba Programming For The Absolute Beginner

9781592007233

1592007236

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review

Related Products