Microsoft Office Access 2007 VBA

Name: Microsoft Office Access 2007 VBA
Price: 5.69 USD
Availability: InStock
ISBN: 9780789737311

ISBN-10: 0789737310

ISBN-13: 9780789737311

Edition: 2008

Authors: Scott Diamond, Brent Spaulding

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $5.69

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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… frequently in their daily work. You have serious work to get done and you can't spend all day reading a computer book. This book teaches you the essential skills you need to automate your databases as quickly as possible. Although written for Access 2007, the techniques and concepts covered will work in most versions of Microsoft Access. Highlights of This Book Include - Navigating within the Visual Basic Editor - Using variables, constants, and data types - Employing built-in functions - Creating procedures - Understanding object-and event-driven coding - Working with arrays - Understanding scope - Working with forms - Using selection controls - Creating reports - Exploring menus, navigation, and ribbons - Using object models - Working with data - Defining database schema - Using the Windows API - Working with XML files - Exploring Access SQL On the Website Download database files used in the book at www.quepublishing.com. Category Office Applications Covers Visual Basic for Applications User LevelIntermediate - Advanced Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20+ years, he has designed databases on a wide range of platforms, including dBASE, FoxPro, SQL/DS, Lotus Approach, Lotus Notes, and, for the past 10 years, Microsoft Access. Scott has worked as a consultant, both in-house and freelance, and as a support professional at firms that are among the leaders in their industries. Scott spends some of his free time answering questions at the premier site for Access support: http: //www.utteraccess.com. Brent Spaulding started writing applications about 20 years ago and has utilized Microsoft Access since version 2.0. He looks forward to using Access well into the future. In July 2007, he received the Microsoft MVP award for Access, which recognizes his talent and contributions to the Access community. Front cover bullets: Edit and debug your code Use looping and conditional statements Understand the Access object- and event-driven architecture Automate data entry Learn how to use variables for dynamic automation Create user-friendly applications for others Create custom functions and objects Customize the user interface Manipulate data and objects with code

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.00" long x 0.90" tall
Weight: 1.386
Language: English



Introduction



The Building Blocks



Advantages of Access and VBA Understanding Where Access Fits in Office Understanding Access Programming Choices


Macros


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


Constants


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


Subroutines


Functions


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