e-Book Microsoft Access 2010 VBA Macro Programming download

by Richard Shepherd

ISBN: 0071738576
ISBN13: 978-0071738576
Language: English
Publisher: McGraw-Hill Education; 1 edition (November 15, 2010)
Pages: 400
Category: Programming
Subategory: Technologies

Download ePub Download Fb2

ePub size: 1890 kb
Fb2 size: 1168 kb
DJVU size: 1721 kb

Rating: 4.8
Votes: 723
Other Formats: mbr lit rtf azw

VBA and Macros Microsoft Excel 2010.

91 MB·3,589 Downloads. Excel® 2016 VBA and Macros - pearsoncmg. 85 Pages·2015·739 KB·11,500 Downloads. VBA and Macros Microsoft Excel 2010. 41 MB·2,176 Downloads·New! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days.

2010 VBA and macros: save time and supercharge excel 2010 with VBA and macros. Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint. 2016 VBA and Macros Contents at a Glance Excel® 2016 VBA and Macros. Mastering VBA for Microsoft Office 2016. 36 MB·14,279 Downloads·New!

Since this book concentrates on VBA modules, macros will not be discussed further.

Richard Shepherd has developed advanced databases for budgeting, business planning, trading reporting, and profit and loss reporting for major banks and corporations in the United Kingdom.

ASCII Character Codes; Index. Excel VBA ( macro programming ) level 1 21-22 ?·

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Develop custom Access VBA macros

Perfect for power users, Microsoft Access 2010 VBA Macro Programming reveals how to maximize the features and functionality of Access 2010. You'll get in-depth details on Access VBA programming and application development followed by 20 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. This practical resource then explains how to include the subroutines in the Access menu system and transform a set of interrelated VBA macros into an Access add-in package. Create your own Access 2010 VBA macros right away with help from this hands-on guide.

Learn how to:

Create and enhance forms and reportsDesign custom dialog boxes and buttonsDevelop custom menus for the RibbonUse SQL queries with VBACreate table macrosUse Office object models to interact with other Microsoft applicationsCreate and manipulate charts and graphsWork with external databasesAdd functionality to your programs with API callsAnimate objects in AccessEnhance database securityCreate audit trailsHandle large text filesTransfer data via FTP

Comments:

Shadowredeemer

Lately I've bought a lot of Access 2010 and Excel 2010 books. I'm noticing a disturbing trend. In the "good old days" there would be a CD ROM with course examples included so you didn't have to type in the code. Now we have the web.

But each book hides the example code URL or doesn't bother to include it at all.

This is one of those books that makes you search high and low for the URL. I haven't found it yet.

At first flyover, this appears to be a very strong book. But still ... I feel cheated that I don't have the example code to go with it.

This is a followup to my earlier review.

I contacted the author using the email address in the book. No reply.

After a lot of work, I found customer support at McGraw-Hill. It took them two days to tell me that data on exercise files was not in their database. One of their reps asked me why I would want such a thing.

Most of the code in the text should be easy to type in, however the very useful Win32API code is quite tedious to type. I expect code to be available on CD or web site. I don't think there is any excuse to not have it.

If I could edit my star rating, it would be 3 stars because of the missing code files.

Vertokini

I have never programmed a stitch in my life before, but I do have some background in having done some SQL administration.

I have been learning MS Access for two weeks now, using what I could find through searches on the web, as well as the MS help files, so my knowledge of Access is somewhat limited.

This book starts exactly where I needed it to start - with the most basic of explanations of things like - where do you actually write your VBA code, what are modules and objects and so on.

It explains it in very simple straight forward English, but it gets the message across of how to use VBA to do the things I need to be able to do, effectively.

riki

I had some difficulty understanding this from the beginning of the book. Feel the author is not communicate=ing with me effectively. What exactly is VBA Macro Programming? I'm no expert yet, but I thought that when you write VBA it goes into MODULES. Maybe there's a need to get the definitions, language cleared up ??? Maybe after reading the Korol book I'll be able to decipher this one.

Onaxan

This book has some great routines, such as creating an audit trail field to document changes to records in a database, and I gleaned some useful information about creating and using "Union Queries" in access, although such was only a side point of one of the chapters. In general, I found books like "VBA access for Dummies" much more complete in many respects than this one. I agree with many commenters on VBA access books: 2010 VBA Macro Programming and others could definitely use more distinct examples and real world breakdown of useful code rather than a snipet here and a snipet there. "VBA access for Dummies" is one of the better ones, especially for beginners and low intermediates.

Granirad

Good book but as others have stated the title is misleading. I do my programming in VBA and bought this because I wanted to look more into the macro-side of things (for future up-scaling to SQL Server).

Despite the title, this book is almost entirely focused on VBA code. Macro's are almost non-existent in the book.

Don't get me wrong though...there is some good stuff in here and I'm happy I made the purchase, but buyer beware.

Goodman

came to this with programming background (FORTRAN, IDL, R, some Python) so wanted to get a fast intro to VBA / Access for work (never used either before). Very clear description of VBA syntax, useful examples, good overview of main objects and object oriented programming, gets you started integrating with other Office programs easily. Very consumable text (got through 75% of the text in 1 week).

Highly recommend

Cordantrius

Microsoft Access 2010 VBA Macro Programming
So far, the book seems to be well-written. I do buy books to see example code; not to practice typing. I'm wondering why this issue exists in 2012. Does even sharing the source via the web cost too much?

I have had this book for some time but haven't really had a chance to use it until now. Like other reviewers, I was frustrated that I was having to type code when it should be readily available in electronic version for copy/paste/edit. After doing a Google search for the title of the book, I went to the link on the McGraw-Hill website. On the left side of the page, plain as day, it says Code Download. I downloaded it (its a word document) and opened it and there is all the code. So as far as I am concerned, the only shortcomming of this book has been rectified. The code is great, indepth, facinating and with the code file so that you don't have to type in the code from scratch, this is a book every Access Developer should have. If you don't want to go search for the link, its [...]