Access 2016 Programming Pocket Primer
Access 2016 Programming Pocket Primer

Author: Julitta Korol
Publisher: Mercury
Pages:200
ISBN: 978-1942270812
Print:194227081X
Audience: Novice Access programmers
Rating: 2.5
Reviewer: Kay Ewbank

This is a book designed to get people started on the fundamentals of Access programming, but it ignores the parts you really need to know.

Access has one of the richest programming environments for database programmers, because you get access to all the elements such as tables, queries, forms and reports, and can control them from your code. Unfortunately, this book doesn't teach how to do any of this, instead taking a standard programming approach.

 

Banner

The book opens with a chapter introducing Access VBA, the different types of Access procedures and modules. How well a complete novice would cope with this is hard to tell, and I think it might have been clearer if this chapter had come later in the book once the Visual Basic editor and Access VBA fundamentals had been introduced.

The second chapter, which covers the Visual Basic editor followed by Access VBA Fundamentals, is where Korol introduces data types, variables and constants. 

A chapter on built-in and custom functions is next, followed by an introduction to conditionals - If and Case. The next chapter covers the different types of loops, starting with Do..While and Do..Until, then going on to For loops. Arrays are tackled next, including parameter arrays, with a chapter on object collections completing the main material. The book ends with a chapter on the built-in tools for testing and debugging.

There is some good material in this book, but some of the more advanced topics seemed out of place in a pocket primer that describes its aim as 'a short book to get you started'. If a reader needs to be told what a variable is, or a simple If statement, it's going to be quite a while before they're likely to want to tackle parameter arrays, custom functions or object collections.

 

pocketprimer

 

More worryingly, the material you really are going to need if you want to write Access code - how to interact with Access tables, fields, queries and reports - isn't covered at all.

I could find just one mention of Access storing data in tables. There was no coverage of concepts such as RecordSets, Database objects, making connections to databases and database objects. There's no mention of DAO versus ADO, and which one to choose. When describing form creation, the controls are set up as unbound, and while you're shown how to assign values to an object collection, there's no mention of how to assign values to actual fields in tables. Access is a great programming environment, but this book ignores the parts that make it great, and treats it instead as just a classic programming language.

 

To keep up with our coverage of books for programmers, follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.

Banner


Kotlin in Action

Author: Dmitry Jemerov and Svetlana Isakova
Publisher: Manning
Pages: 360
ISBN: 978-1617293290
Print: 1617293296
Rating: 4.5
Reviewer: Mike James

Kotlin is suddenly a very important language. Can a book by one of its pioneers help you get the most from it?



The Mobile Application Hacker’s Handbook

Authors: Dominic Chell, Tyrone Erasmus, Shaun Colley and Ollie Whitehouse
Publisher: Wiley
Pages: 816
ISBN: 978-1118958506
Print: 1118958500
Kindle: B00TSA6KLG
Aimed at: mobile developers
Rating: 4.5
Reviewed by: Kay Ewbank

Covering how to write apps that don’t fall foul of vulnerabilities, a more  [ ... ]


More Reviews

Related Reviews

Access 2010 in Depth

Access 2010 Programming by Example with VBA, XML and ASP

Access 2010: The Missing Manual

Access 2013 Inside Out

Access 2013: The Missing Manual

 

Last Updated ( Thursday, 14 July 2016 )
 
 

   
Banner
RSS feed of book reviews only
I Programmer Book Reviews
RSS feed of all content
I Programmer Book Reviews
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.