or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
34 used & new from £4.69

Have one to sell? Sell yours here
 
   
Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer)
 
 

Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer) (Paperback)

by Patricia Cardoza (Author), Teresa Hennig (Author), Graham Seach (Author), Armen Stein (Author) "What is Microsoft Access? ..." (more)
3.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £26.99
Price: £16.54 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £10.45 (39%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Friday, November 13? Choose Express delivery at checkout. See Details
22 new from £7.79 12 used from £4.69

Frequently Bought Together

Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer) + Learn Access VBA 2003 With The Smart Method + Microsoft Access 2003 Forms, Reports and Queries (Business Solutions)
Price For All Three: £38.89

Show availability and delivery details


Customers Who Bought This Item Also Bought

Learn Access VBA 2003 With The Smart Method

Learn Access VBA 2003 With The Smart Method

by Mike Smart
5.0 out of 5 stars (15)  £11.38
Beginning Access 2003 VBA (Programmer to Programmer)

Beginning Access 2003 VBA (Programmer to Programmer)

by Denise Gosnell
3.2 out of 5 stars (4)  £17.89
Expert One-on-one Microsoft Access Application Development

Expert One-on-one Microsoft Access Application Development

by Helen Feddema
£22.94
Microsoft Access 2003 Forms, Reports and Queries (Business Solutions)

Microsoft Access 2003 Forms, Reports and Queries (Business Solutions)

by Paul McFedries
4.0 out of 5 stars (1)  £10.97
How to Do Everything with Microsoft Office Access 2003

How to Do Everything with Microsoft Office Access 2003

by Virginia Andersen
4.5 out of 5 stars (4)  £10.47
Explore similar items

Product details

  • Paperback: 984 pages
  • Publisher: John Wiley & Sons (8 April 2004)
  • Language English
  • ISBN-10: 0764559036
  • ISBN-13: 978-0764559037
  • Product Dimensions: 23.4 x 18.8 x 5.6 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon.co.uk Sales Rank: 190,988 in Books (See Bestsellers in Books)

    Popular in these categories:

    #5 in  Books > Computing & Internet > Databases > Applications > Access > Reference
    #12 in  Books > Computing & Internet > Databases > Applications > Access > Programming
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   Access Programmer opens new browser window
ApprovedDatabaseDevelopers.co.uk  -  Get free quotes from top UK MS Access Database Developers 
  
 

Product Description

Product Description

What is this book about?

Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more.

In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features.

You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications.

What does this book cover?

Here are some of the things you′ll discover in this book:

  • How to take advantage of the built–in Access object library, using Access commands and executing them from any Access toolbar
  • What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data
  • How to configure custom menus for your Access database applications
  • Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs
  • How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information
  • Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code

Who is this book for?

This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.



From the Back Cover

Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more.

In this book, a crack team of programmers including two Microsoft MVPs shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features.

You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server®, and how to use VBA in Access to control and enhance other Office applications.

What you will learn from this book

  • How to take advantage of the built–in Access object library, using Access commands and executing them from any Access toolbar
  • What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data
  • How to configure custom menus for your Access database applications
  • Ways to transfer information between Access and Excel, Word, Outlook®, and other Office programs
  • How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information
  • Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code

Who this book is for

This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.

Wrox Programmer’s References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.


Inside This Book (Learn More)
First Sentence
What is Microsoft Access? Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(2)
(1)

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer)
54% buy the item featured on this page:
Access 2003 Vba Programmer's Reference (Wrox Press) (Programmer to Programmer) 3.0 out of 5 stars (2)
£16.54
Learn Access VBA 2003 With The Smart Method
26% buy
Learn Access VBA 2003 With The Smart Method 5.0 out of 5 stars (15)
£11.38
How to Do Everything with Microsoft Office Access 2003
7% buy
How to Do Everything with Microsoft Office Access 2003 4.5 out of 5 stars (4)
£10.47
Access VBA Programming for Dummies
7% buy
Access VBA Programming for Dummies 3.2 out of 5 stars (4)
£9.69

 

Customer Reviews

2 Reviews
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
3.0 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
3 of 3 people found the following review helpful:
5.0 out of 5 stars It does what is says on the tin (well, cover), 24 Jul 2008
By R. S. Bacon "Aresby" (Milton Keynes, UK) - See all my reviews
(REAL NAME)   
I'd had this book in my hands less than 60 seconds before I found a chapter on the ins and outs of DAO vs ADO methods of accessing the database - and the why the two need to be carefully separated. Got me out of a hole immediately and made the whole thing (no pun intended) much, much clearer.

Nicely laid out, lots of code fragments to illustrate points and some larger self-contained subroutines to put the points to bed together.

It assumes you know at least something about Access and VBA otherwise you really would be struggling to keep up; but as an experienced VB programmer (but not in Access) this really did drop me in the deep end but let me keep running.

I'm glad I bought it, even though it's early days yet.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
1.0 out of 5 stars Too High Brow, 6 Nov 2009
By Mark Lidster (London, United Kingdom) - See all my reviews
(REAL NAME)   
In the course of my job over the last 20 years I've had to buy numerous examples of these kind of manuals, so I feel I am well placed to comment on this type of material.

This tome is quirky and provides too many obscure examples of how you might want to configure Access. The VBA content is limited and not orientated to real world examples. The content on reporting is scant at best and provides little above intermediate knowledge. Tell me what mainstream DB application doesn't have an integral reporting suite?

Save your money unless insomnia is your thang!!
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.