Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Access 2007 VBA Programmer's Reference
Access 2007 VBA Programmer's Reference (Paperback)
Order Options List Price Online Price Save Availability
Delivery:

To home, business or free to our stores. Click for more info.

     

Available through New & Used Online only

 
Click & Collect:

Order now to collect from 6pm today. In stock items only. Click for more info.

     

Stores - out of stock

 
New & Used:

Our marketplace sellers will deliver to your chosen address. Click for more info.

From £11.28  

In stock at one or more sellers.

Buy - Select Seller

Product Synopsis

Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphical user interface) elements that previously required VBA code, as well as new VBA features. The book also discusses how to create and name variables, how to use Data Access Object (DAO) and ActiveX Data Object (ADO) to manipulate data both within Access and within other applications, proper error handling techniques, and advanced functions such as creating classes and using APIs. Key new objects such as using Macros and the Ribbon are explored, too, as are forms and reports, the two most powerful tools for working with and displaying data. Working with other applications is covered extensively both in a general nature and for working specifically with Microsoft Office applications, Windows SharePoint Services, and SQL Server.

Of course, this book wouldn't be complete without discussing security issues and the Developer Extensions. The Chapters Chapters 1--5 provide material that you need if you're new to Access or VBA. After a review of Access 2007's new features, you explore the building blocks of VBA, including objects, properties, methods, and events. And you're introduced to the VBA Editor and its various debugging tools. Chapters 6 and 7 focus on using VBA to access data. Both DAO and ADO provide methods for accessing data in Microsoft Access and other external data sources such as Informix, SQL Server, and a variety of accounting programs. Chapters 8 and 9 provide detailed information on executing and debugging VBA code. Every development project needs some debugging, even if you're an expert developer. You'll see some easy ways to debug your code, and get some tips and tricks to make the tedious process of debugging a bit easier. Error handling is for more than just trapping problems and preventing crashes. It provides a powerful tool for interacting with users and adding functionality to programs.

Chapters 10 and 11 tackle forms and reports, two Access objects that can make particularly heavy use of VBA. In many applications, forms and reports control what the user can see and do. With the advent of report browsers, nearly all of the events that were available on forms are now accessible on reports. So, in addition to using code to show or hide sections of reports and to provide special formatting, you can now drill into the data underlying the report. These two chapters are packed with information; you'll see how to use split screens on forms, create professional image controls, format reports based on cross tab queries, enhance interactive reports, alternate row colors, and much more. Advanced VBA programming information begins in the next four chapters (12--15) -- creating classes in VBA, using APIs, and using SQL and VBA. Because the Office Ribbon is new, there is a chapter dedicated to explaining how to customize and work with the ribbon. Chapters 16--22 provide information about working with other programs, working with Windows, and controlling access to your applications and files. They also discuss some techniques for deploying database solutions.

You'll learn to create tasks and e-mail in Outlook, perform a mail merge in Word, export data to an Excel spreadsheet, and take information from Access, create a graph, and insert that graph into PowerPoint. Windows SharePoint services can help your applications share data across the Web. You'll see how new file formats add to network and Access security. In addition, you'll work with client/server development, learn to take advantage of Windows Registry and explore the Access Developer Extensions, essentially a Microsoft add-in, before you tackle macro security. The Appendixes As a developer, you can often spend hours going from source to source looking for reference material. The authors have applied the principles of relational databases (doing the work once so it can be used many times in multiple ways) to the appendixes, providing a compilation of data from a myriad of sources. Appendix A addresses the issues and processes of upgrading, converting, and compatibility. The other 12 appendixes provide lists and tables that complement specific chapters in the book.

You'll find detailed lists of objects for both DAO and ADO as well as the Access object model and Windows Registry. The appendixes on naming conventions and reserved words provide invaluable information that not only can strengthen your programming style but can save you from using terms or characters that can cause hours of needless pain and frustration in debugging and correcting. The last appendix is filled with tips and tricks to make it easier and faster for you to develop professional applications, all solicited from MVPs and developers around the world. The initial chapters are written in a tutorial format with detailed examples. True to the Wrox Programmer's Reference standard format, the book includes numerous reference appendixes with details on the various object models you might use when writing VBA code in Access. It also provides a detailed primer on the Windows Registry and a listing of common API functions you might want to use in your code. Real-world examples are given for many, if not most, of the programming topics covered in this book.

These are just of few of the topics and examples that are included: *How to control access to data based on database login information.*How to create custom reports based on information entered on a form.*How to leverage report browse -- the new interactive report feature that enables drilling into data on reports.*How to summarize and graphically display data using cross-tab reports.*How to use VBA to transfer data between Access and other Office programs such as Outlook, Word, and Excel.*How to configure custom ribbons, toolbars, and menus for your Access database applications.*How to use the image controls for more intuitive and professional looking forms.

Computing & IT >> Databases >> Data capture & analysisComputing & IT >> Databases >> Database design & theory >> Relational databasesComputing & IT >> Databases >> Database software >> AccessComputing & IT >> Databases >> Distributed databasesComputing & IT >> Databases >> Object-oriented databases Publisher: John Wiley & Sons Inc Publication Date: 01/03/2007 ISBN-13: 9780470047033  Details: Type: Paperback Format: Books
Availability: Available through New & Used Online only  

More books by Teresa Hennig

More books by Rob Cooper

More books by Geoffrey L. Griffith

More books by Armen Stein

Leave Review

Delivery

Please note for the New & Used Marketplace different terms and conditions apply.

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location1st BookEach additional bookAverage Delivery Time
UK Second ClassAvailable free for orders over £10* or £2.50Available free for orders over £10* or £1.003-7 Days
UK First Class£4.50£1.001-2 Days
UK Courier£7.00£1.001-2 Days
Western Europe** Courier£17.00£3.002-3 Days
Western Europe** Airmail£5.00£1.504-14 Days
USA / Canada Courier£20.00£3.002-4 Days
USA / Canada Airmail£7.00£3.004-14 Days
Rest of World Courier£22.50£3.003-6 Days
Rest of World Airmail£8.00£3.007-21 Days

* Available free for orders over £10 = When offered a delivery preference choose 'For Cheapest Postage' for our freepost in the UK offer. This is not available on the 'For Faster Delivery' option.

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

Foyles Marketplace

Special Terms on Marketplace orders

Please note special terms and condition apply and customers placing orders are accepting these terms. See our Full Terms, Delivery Rates and Times. Specifically we are unable to accept cancellation or amendment to Marketplace orders once placed.

All sellers despatch within 48 hours, but postage times and costs vary depending on your location and that of the seller. As such the UK delivery price is displayed as a guide only.

Condition Seller Postage Price

Good

Sellers Comments:

Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, may not include cdrom or access codes. Customer service is our top priority!

  •  
  •  
  •  
  •  

HPB-Richardson

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£11.28

Earns 45 Foyalty points

Price including delivery to the UK = £19.43

Add to Basket

Good

Sellers Comments:

Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, and may not include cd-rom or access codes. Customer service is our top priority!

  •  
  •  
  •  
  •  

HPB-Naperville

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£13.53

Earns 54 Foyalty points

Price including delivery to the UK = £21.68

Add to Basket

Very Good

Sellers Comments:

None

  •  
  •  
  •  
  •  

Book Closeouts

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£16.08

Earns 64 Foyalty points

Price including delivery to the UK = £24.23

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

Paperbackshop International

Available Qty: 10

United Kingdom

From United Kingdom

£2.95 3-10 business days

£16.35

Earns 65 Foyalty points

Price including delivery to the UK = £19.30

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

indoo.com

Available Qty: 100

United States

From United States

£8.15 21-28 business days

£20.06

Earns 80 Foyalty points

Price including delivery to the UK = £28.21

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

Paperbackshop

Available Qty: 771

United States

From United States

£8.15 21-28 business days

£20.50

Earns 82 Foyalty points

Price including delivery to the UK = £28.65

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

Paperbackshop

Available Qty: 10

United States

From United States

£8.15 21-28 business days

£22.91

Earns 91 Foyalty points

Price including delivery to the UK = £31.06

Add to Basket

Good

Sellers Comments:

None

  •  
  •  
  •  
  •  

Big Planet Books

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£24.58

Earns 98 Foyalty points

Price including delivery to the UK = £32.73

Add to Basket

Good

Sellers Comments:

None

  •  
  •  
  •  
  •  
  •  

One Stop Text Books Store

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£26.08

Earns 104 Foyalty points

Price including delivery to the UK = £34.23

Add to Basket

Good

Sellers Comments:

None

  •  
  •  
  •  
  •  

CRB

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£26.12

Earns 104 Foyalty points

Price including delivery to the UK = £34.27

Add to Basket

Good

Sellers Comments:

None

  •  
  •  
  •  
  •  

omgtextbooks

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£26.25

Earns 105 Foyalty points

Price including delivery to the UK = £34.40

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

Kenton Books

Available Qty: 1

United Kingdom

From United Kingdom

£2.95 3-10 business days

£29.42

Earns 117 Foyalty points

Price including delivery to the UK = £32.37

Add to Basket

Fine/Like New

Sellers Comments:

None

  •  
  •  
  •  
  •  

Paperbackshop

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£40.70

Earns 162 Foyalty points

Price including delivery to the UK = £48.85

Add to Basket

Good

Sellers Comments:

TEXT ONLY. NO ACCESS CODE. Used texts with varying degrees of highlighting and wear. Email for details. Could be a former library book.

  •  
  •  
  •  
  •  

Greensboro Books

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£49.21

Earns 196 Foyalty points

Price including delivery to the UK = £57.36

Add to Basket

Very Good

Sellers Comments:

Great customer service. You will be happy!

  •  
  •  
  •  
  •  

booklab

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£57.74

Earns 230 Foyalty points

Price including delivery to the UK = £65.89

Add to Basket

Very Good

Sellers Comments:

None

  •  
  •  
  •  
  •  

More Books

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£57.74

Earns 230 Foyalty points

Price including delivery to the UK = £65.89

Add to Basket

New

Sellers Comments:

Brand New, Perfect Condition. May Ship From Overseas, Free Upgrade to Priority Shipping.

  •  
  •  
  •  
  •  

Shopazam

Available Qty: 1

United States

From United States

£8.15 21-28 business days

£60.01

Earns 240 Foyalty points

Price including delivery to the UK = £68.16

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

PROFESSIONAL & ACADEMIC bookst

Available Qty: 29

United States

From United States

£8.15 21-28 business days

£64.59

Earns 258 Foyalty points

Price including delivery to the UK = £72.74

Add to Basket

New

Sellers Comments:

Great customer service. You will be happy!

  •  
  •  
  •  
  •  

booklab

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£88.97

Earns 355 Foyalty points

Price including delivery to the UK = £97.12

Add to Basket

New

Sellers Comments:

None

  •  
  •  
  •  
  •  

More Books

Available Qty: 2

United States

From United States

£8.15 21-28 business days

£88.97

Earns 355 Foyalty points

Price including delivery to the UK = £97.12

Add to Basket

You might also like

Explore Microsoft Access 2000: Brief
Joseph J. Adamski
 
From£16.53 Buy - Select Seller
Distributed and Multi-Database Systems
Bobak, Angelo, R;
 
£74.00£66.6010%Add to Basket
Principles of Data Fusion Automation
Antony, Richard T.;
 
£128.00£115.2010%Add to Basket
A Practitioner's Guide to Upgrading ...
Talebzadeh, Mich;
 
£30.00£27.0010%Add to Basket
Your Shopping Basket
Total number of items: 0
Sub total: £0.00
Edit Basket Go to Checkout
Select Currency: $ £
enCounter Culture
Signed Books and Copies
Animators Survival Kit
Latest Blog
Helping kids discover London's wildlife
23/10/2014

Autumn's natural wonders, even in a city like London, can offer all manner of fun and adventure this half-term, suggests Laura from our Royal Festival Hall shop.

GUEST BLOG: Poetry and art - a wartime romance
17/10/2014

Christiana Spens, illustrator and Director of 3:AM Press, looks at the the important relationship between books and the artwork that adorns them.

A book is for life, not just for GCSE
14/10/2014

Charlotte from our Bristol branch on how the books we read at school often resonate with us throughout lives, as well as starting us out on a lifelong journey of literary discovery.

View all Blog Entries
Twitter
© W&G Foyle Ltd
Version: 1.0.0.19527