Skip to content

Microsoft Office Access 2007 VBA

Spend $50 to get a free DVD!

ISBN-10: 0789737310

ISBN-13: 9780789737311

Edition: 2008

Authors: Scott B. Diamond, Brent Spaulding

List price: $39.99
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
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!


Business Solutions Microsoft(R) Office Access 2007 VBA Develop your Access 2007 VBA expertise instantly with proven techniques Microsoft Office Access 2007 VBA builds on the skills you've already developed in creating database applications and helps you take them to the next level--using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming language. Even if you've never programmed, this book will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before. Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access…    
Customers also bought

Book details

List price: $39.99
Copyright year: 2008
Publisher: Pearson Education
Publication date: 11/27/2007
Binding: Paperback
Pages: 408
Size: 7.00" wide x 9.25" long x 1.00" tall
Weight: 1.386
Language: English

The Building Blocks
Advantages of Access and VBA Understanding Where Access Fits in Office Understanding Access Programming Choices
Using SQL
Using VBA
Using the Visual Basic Editor First Look at the Visual Basic Editor Explaining VBA Modules Entering and Running Code
Debugging Code
Saving Code Getting Help on Code
Coding Shortcuts Good Coding Habits
Using a Naming Convention
Indenting Documenting
Using Variables, Constants, and Data Types Declaring Variables and Constants
Declaring Variables
Using Option Explicit
Naming Variables
Declaring Constants VBA Data Types Referencing Syntax Case Study
Using Form References
Using Built-In Functions What Are Functions? Converting Data Types
Converting to a Boolean Data Type
Converting to a Date Data Type
Converting to an Integer Data Type
Converting to a String Data Type
Converting to a Variant Data Type
Converting Null Values Working with Date Functions
Returning the Current Date
Performing Date Arithmetic
Determining the Difference Between Two Dates
Extracting Parts of Dates
Creating Dates from the Individual Parts
Creating Dates from String Values
Extracting a Specific Date or Time Portion
A Conversion and Date Example Using Mathematical Functions
The Abs Function
The Int Function
The Rnd Function
A Mathematical Functions Example Using Financial Functions
The Ddb Function
The FV Function
The Pmt Function
The Rate Function
A Financial Functions Example Manipulating Text Strings
The Asc Function
The Chr Function
The Case Functions
The Len Function
The Left, Right, and Mid Functions
The Replace Function
The Split Function
The Trim Functions Formatting Values
Applying User-Defined Formats Domain Aggregate Functions
The DLookup Function
The DCount Function
The DMax/DMin Functions Using the Is Functions Interaction
The MsgBox Function
The InputBox Function Case Study:Add Work Days
Building Procedures Types of Procedures
Assigning a Data Type to a Function
Public Versus Private Passing Arguments
Using Optional Arguments and Default Values
Passing Arguments By Reference
Passing Arguments By Value Error Handling
Using On Error Resume Next
Using On Error Goto
Conditional and Looping Statements Introducing Flow of Control Statements Using If...Then...Else
A Simple If Statement
More Complex Conditions
Including an Else Clause
Including an ElseIf Clause Using Select Case Using For...Next
Using the Step Clause
Other Ways to Set the Counter
Nesting For...Next Loops
Aborting a For...Next Loop Using Do Loops
A Simple Do Loop
Do Loop Flavors
Aborting a Do Loop Using GoTo Case Study: Calculating Bonuses
Working with Arrays Introducing Arrays Declaring a Fixed-Size Array Understanding an Array s Index
Using Option Base Working with Array Elements
Assigning Array Elements
Using Array Element Values Arrays with Multiple Dimensions Expanding to Dynamic Arrays
About ReDim
Erase Statement
Object and Event-Driven Coding Understanding Objects
Creating Objects in Code
Reading and Set