Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.

  • Apple
  • Android
  • Windows Phone
  • Android

Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.

Prix Kindle : EUR 20,16

EUR 1,34 (6%)

TVA incluse

Ces promotions seront appliquées à cet article :

Certaines promotions sont cumulables avec d'autres offres promotionnelles, d'autres non. Pour en savoir plus, veuillez vous référer aux conditions générales de ces promotions.

Envoyer sur votre Kindle ou un autre appareil

Envoyer sur votre Kindle ou un autre appareil

Access 2007 VBA Programming For Dummies par [Stockman, Joseph C., Simpson, Alan]
Publicité sur l'appli Kindle

Access 2007 VBA Programming For Dummies Format Kindle

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
EUR 20,16

Longueur : 412 pages Optimisé pour de plus grands écrans Langue : Anglais
  • En raison de la taille importante du fichier, ce livre peut prendre plus de temps à télécharger

Descriptions du produit

Présentation de l'éditeur

If you’ve been using Access for a while, you’re probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:
  • Basic programming skills and concepts
  • Explanations of modules, procedures, objects, and arguments
  • Access-unique programming activities, including SQL and recordsets
  • How to use the Visual Basic editor
  • Creating dialog boxes, lists, drop-down menus, and functions
  • Integrating with other Office applications
  • Ready-to-use VBA code examples to type in or copy and paste from the Web

Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you’ve never had it before.

Quatrième de couverture

Customize combo and list boxes

Go beyond forms and reports and build custom database solutions

Need to know how VBA works in Access 2007? This plain–English guide introduces you to the fundamentals of VBA programming, helping you get the most out of your Access apps and giving you practical code examples for immediate use in your databases. You′ll see how to control Access through VBA and apply powerful real–world VBA solutions.

Discover how to

  • Create simple VBA programs
  • Program Access forms
  • Manage Access tables with SQL and recordsets
  • Test and debug your code
  • Use VBA with multiple databases
  • Integrate with other Office apps

Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 15447 KB
  • Nombre de pages de l'édition imprimée : 412 pages
  • Pagination - ISBN de l'édition imprimée de référence : 0470046538
  • Editeur : For Dummies; Édition : 1 (21 mai 2007)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ASIN: B004OC07C6
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Moyenne des commentaires client : Soyez la première personne à écrire un commentaire sur cet article
  • Classement des meilleures ventes d'Amazon: n°430.248 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)
  •  Voulez-vous faire un commentaire sur des images ou nous signaler un prix inférieur ?

click to open popover

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoile

Commentaires client les plus utiles sur (beta) HASH(0x9da8836c) étoiles sur 5 63 commentaires
63 internautes sur 64 ont trouvé ce commentaire utile 
HASH(0x9dd92360) étoiles sur 5 Great beginning book, but one significant shortcoming... 7 mars 2008
Par peterf - Publié sur
Format: Broché
My spouse volunteered to take on a data collection and manipulation project for a non-profit using Access. Here is her report:

I was familiar with the basics of relational database design, and had used Access to a limited extent about 8 years ago. I had a good understanding of the data and how it would be used, so designing a robust database was pretty straightforward. My limitation was the nuts and bolts mechanics of using Access, especially the new 2007 version. I collected about 5 books on Access 2007 from the library, and this is the one really dove into, and ultimately ended up buying. I would say that if you are using Access 2007 you should be sure to buy a book specific to 2007, not earlier versions.

I really like the format of the book--it is organized into logical sections that are easy to follow. I especially like the way the infomation is presented-- there are plenty of examples with adequate illustrations, but the basic ideas are well explained before the examples, so that I found it easy just to sit down and read it to absorb most of the basic ideas. Then after I had acquired a good overview of, say, forms and their applications, I went back to the examples to try them out on my own data. Many of the other books I used explained the concepts only through the examples, so unless you were actually sitting at the computer following each and every step it was difficult to gather the fundamental concepts.

I think the sections on basic database design concepts would be adequate for those not so familiar with relational databases.

I did find one major omission that is critical enough that I ended up buying another book to supplement this one. I did not find any reference to action queries such as update, append, and delete. These have been really crucial to me as I consolidate date from many different sources, and the lack of info on action queries is glaring! (I'll admit that I didn't read EVERY word of this book, so I guess it is possible that I somehow overlooked it, but I was read the first 250 out of 350 pages pretty carefully.) I ended up buying "The Unofficial Guide to Access 2007" by Jim Keogh to supplement, but I'll warn you even that one has misinformation on the format of update queries...

All in all, though, I found this book to be a great basic introduction--concisely written, in an easily digested style. Very useful.
57 internautes sur 58 ont trouvé ce commentaire utile 
HASH(0x9dd924b0) étoiles sur 5 Lots of issues ... 23 juillet 2008
Par Amazon Customer - Publié sur
Format: Broché
I bought this book for the same reason I buy any "For Dummies" book, to decrease my ramp up time on a particular subject. Generally I can blow through one of these books in a few days and move on to more advanced books on that topic. Disappointingly, I was unable to achieve this goal with 'Access 2007 for Dummies'.

First of all this book starts out assuming that you have a database to work with and makes no effort in teaching you how to build a database from the ground up. Continuing on the assumption that you have your own database (filled with data) that you are going to be working with, the author has to stay in a "high level mode" for the rest of the book. Most of the book has vague references and examples that read something like "If you have X type of data in a Y type of structure you may want to try something like Z". Well, I don't have a my own database filled with this type of data, so, I went looking on the publishers web site for example databases to work with. I was happy when I found out there were example databases on the publishers site, but further disappointed to find out that these examples are rarely used. This makes following along by example next to impossible. The few times when these example databases are used they don't entirely match up to the screenshot's in the book . Which brings me to books use of screenshots. Screenshots are generally a good thing when working with a GUI application such Access. However, the screenshots are off little use due to the fact that the screenshots are of the entire application window, rather than being cropped to show you the control in question. So, when the author is referencing a specific control such as a small button you have to hunt and peck your way through the grayscale image trying to find the button that looks depressed.

After all of the fore mentioned pitfalls I still continued through the book. I was really interested in getting to the sections on charting and switchboarding. Once again, I was disappointed. The author claims that Access 2007 has no charting capability and the reader should use Excel or PowerPoint instead. First of all, this is incorrect. Charting is available in Access 2007 via the "Design View" in a report. Secondly, the author gives no instruction on how to create charts in Excel or PowerPoint as he advises the reader to do. The chapter on switchboards is all of 11 pages long (mostly screenshots) and contains next to no information on how to get these set up and working. As a matter of fact I could not get any of the switchboard examples to work properly with the example databases provided by the publisher.

In the end I ended up learning quite a bit about Access. However, most of what I learned was done with online research while trying to stumble through this book. Getting through this book took me about 4 times longer than it should have due to a the above mentioned problems. All and all this ended up being a waste of time for someone who was short on time in the first place.
28 internautes sur 34 ont trouvé ce commentaire utile 
HASH(0x9dd927ec) étoiles sur 5 Excellent Book on Customizing Access 2 avril 2007
Par John Matlock - Publié sur
Format: Broché
Some years ago Microsoft created a specialized programming language to allow extensions to be made to the normal modes of operation allowed in their Office suite. The language was fairly well thought out to be applicable to applications as different as word processing, spreadsheets or data bases. They called it Visual Basic for Applications shortened to VBA. It has worked remarkable well. Down theough the years there have been relatively few changes to VBA.

This book is on VBA as specifically oriented to the Microsoft Access database program. But if you learn Access VBA, you are not far from knowing how to use VBA on any of the other Office components.

While this is an Access book, it is specifically on VBA, it assumes that you already know about how to build a table, and about rows and columns. It also assumes that you have some familiarty with other Access features such as building queries.

Access goes to a great deal of effort to avoid having to use the underlying SQL language. There are a couple of chapters on SQL for the total beginner. In the long run, you will probably want to know more.

You can't design one book to do everything in about 400 pages. This "dummies" book concentrates on VBA. That's enough for one book. It does a good job on VBA. You may want to fill out your bookshelf with Access for Dummies and SQL for Dummies.
14 internautes sur 16 ont trouvé ce commentaire utile 
HASH(0x9dd92324) étoiles sur 5 Good Introduction to Access and the new Ribbon 21 février 2007
Par John Matlock - Publié sur
Format: Broché
Access is the most popular database program in the world. The reason is two fold:

1. It's very easy to use. Microsoft has gone to a great deal of effort to make the program fit in with the rest of the Office system so that knowing Word or Excel gives you a good bit of the background you need to use Access.

2. Access is part of the Microsoft Office package, so you probably get it when you get Word and Excell.

There's always a question about just how good Access really is. And the answer is that it's pretty good for databases up to perhaps 50 megabytes with no more than a few thousand accesses a day. Above that go to something bigger like SQL Server.

This book starts with a discussion about databases in general and what you might use one to do. Then,like all of the books on the other Office 2007 packages, it begins talking about Microsoft's new Ribbon interface that replaces the look that Access has had for years.

The Access front end is very powerful. It has been worked on for years to keep you from having to learn how to program in the direct language the database engine understands -- SQL.

That's my main complaint about people who use Access, and the books written for them. Just a few pages introducing SQL and giving the reserved words for the Access (Jet) database would be a big help.
6 internautes sur 6 ont trouvé ce commentaire utile 
HASH(0x9dd92ccc) étoiles sur 5 Authors have lost touch 20 février 2010
Par D. Smith - Publié sur
Format: Broché
I was incredibly disappointed with this book. For instance by page 12, no screen prints or pictures have been provided to support the convoluted language meant for those already familiar.

This was a waste of time for me as a beginner. How can you progress if the "techie" language is not further broken down and, demonstrated.

Now who is the dummy?
Ces commentaires ont-ils été utiles ? Dites-le-nous