Books!

[Leo_Coroneos]

Hey guys,

Just wondering what kind of books the community refer to in order to get better at Access? I have the following books:

Nene (R) Guide to Microsoft Access 2000 by Jill & Tony Luha (passed on from a schoolmate, just breezed through it because I know most of what it involves; seems like the basic principles of Access haven't changed all that much since then!)

Microsoft Access 2016 Programming Pocket Primer by Julitta Korol (just got it in the mail and am up to the section on VBE)

Access 2016 Bible by Michael Alexander (still waiting for it to arrive in the mail)

What do you guys read, if anything? Anything you can suggest to complement this reading material, for someone who is intermediate level of learning?

Cheers,
Leo C.

 

[Uncle Gizmo]

I subscribe to Safari online. 1000's of books, videos, courses on a wide variety of programming languages. You can search through all the books quickly and easily.. The videos by Bruce McPherson on Google Apps Script (VBA orientated) are particularly good if you are concerned that Access might be on it's last legs....

Sent from my SM-G925F using Tapatalk

 

[Leo_Coroneos]

Thanks for the recommendation and your reply. To get off-topic a bit, I am currently racking my brains over a particular problem: see my thread entitled "Opening report based on current Order" in the Reports forum of Access World Forums. I wonder if you could have a look and help out?

Cheers,
Leo C.

 

[Leo_Coroneos]

By the way, why might I be concerned that Access is on its last legs?

Seems like the perfect solution for my client, who needs to keep track of his accounts and orders, and to do it electronically.

Personally, I like Access, hence my purchase of the books I cited above.

 

[Uncle Gizmo]

why might I be concerned that Access is on its last legs?

People have been saying that MS Access is finished for years and years, as long as I can remember! The fact that it is still going is absolutely amazing and that fact alone demonstrates what a good product it is. However there is definitely a serious threat to it, and that is the cloud... Access itself does not play well with the cloud, and I don't foresee Microsoft making any serious attempts to get it working on with the cloud. Also, in a recent correspondence with someone I know who works within Microsoft, well I picked up a subtle hint. Not saying I know anyone that knows anything, might be just someone with a biased against Access. but you can't deny that change is more than likely afoot...

 

[Uncle Gizmo]

Thanks for the recommendation and your reply. To get off-topic a bit, I am currently racking my brains over a particular problem: see my thread entitled "Opening report based on current Order" in the Reports forum of Access World Forums. I wonder if you could have a look and help out?

Cheers,
Leo C.

I'm keeping clear of the Forum for a while, I'm still around and doing my moderator duty, however I don't get too involved in any threads unless they are of particular interest to me. I'm not particularly interested in Reports at the moment, however I did blog about reports on my website HERE:-

Generate Multiple Reports

I have no idea if this information will be of any help in answer to your particular question but I'm sure you will find something useful within it..

 

[ButtonMoon]

By the way, why might I be concerned that Access is on its last legs?

Umm, perhaps the fact that it is a niche product which Microsoft has left in suspended animation for over a decade. In the same period the market-leading products covering some of the same core capabilities (rapid application development, data management, data analytics, reporting) have seen an incredible amount of change and innovation.

Nobody has mentioned any good database design books yet. How about: Beginning Database Design by Clare Churcher; Practical Issues in Database Management (Fabian Pascal); Database Systems, the Complete Book (Garcia-Molina, Ullman, Widom)

 

[isladogs]

Thanks for the recommendation and your reply. To get off-topic a bit, I am currently racking my brains over a particular problem: see my thread entitled "Opening report based on current Order" in the Reports forum of Access World Forums. I wonder if you could have a look and help out?

Leo C.

Have you looked at my last reply to that thread?

 

[Mark_]

For books, I'd actually recommend a different source for your reading... Forum posts.

Try to figure out the answer to someone's question. You'll often find that what research you put in to figuring out not only their problem but a solution (as well as if their approach to their problem is correct) will teach you far more than any book I've ever read.

 

[Pat Hartman]

If you want a book on database design, ANY book that uses a relational database would offer sound advice. I haven't run into any books that specifically target Jet or ACE. If you find something for SQL Server or Oracle, or DB2, or MySQL, it will be applicable to Jet/ACE. When you get into SQL syntax, there are differences but the logic of how you design a properly normalized schema is universal.

My favorite book on VBA is quite old but since VBA actually hasn't changed much over the years, it is still a good pick/ Look for the Access Cookbook published by O'reilly. Version 2 is the newest version and it is pre A2007. What I like about it is that it provides little recipes for solving specific problems. In some cases, newer versions of Access have eliminated the need for some of the suggestions but it is still a good way to learn the basics of VBA coding. Another good one is FIXING Access Annoyances also by O'Reilly. This has a broader scope and addresses the "why" things are not working as you expect. And last but not least is Access Solutions - Tips, Tricks, and Secrets from MS Access MVPs. This is similar in concept to the Cookbook and is based on a newer version of Access.

If you like videos, Crystal has produced a bunch of helpful ones.

I haven't actually come across a good general application design book. They all seem to just jump in and talk about designing individual objects rather than how you would create an overall plan. Crystal offers a number of basic articles to get you started.

 

[Leo_Coroneos]

Have you looked at my last reply to that thread?

I have now. Thanks a lot, I really appreciate it.

 

[Leo_Coroneos]

Cheers gents, I'll keep those ideas and suggestions in mind.

@Mark, I'll see what I can do in the way of helping others out around here and just making myself useful in general.

@Pat, I don't like videos that much, I prefer books or something "tangible" that I can read offline of my all-too-small laptop. (Might have to upgrade my desktop computer to a Windows 10 box at some point, probably next year.) However, I've just bookmarked "LearnAccessByCrystal" on YouTube for future reference.

I'll let you guys know how I go with Julitta Korol's Access programming primer and the Access 2016 Bible.

We were all trained in Access (2013) at South Regional TAFE, where I completed my Certificates III and IV in Information Technology. The lecturer offered no hints or even the slightest suggestion that it might be going obsolete, and my current client likes the idea of me using the software that HE has purchased for our utility in order to get his business running more efficiently.

I'll keep you all up to date. Kind regards from Aus

 

[Leo_Coroneos]

Just got my Access 2016 Bible (by Michael Alexander and Dick Kusleika) in the mail. It's HUGE!

I am skipping through the first few chapters to see what I can glean from the book's intermediate-level contents... my housemate took one look at the huge tome and said, "well, I'll see ya in a fortnight!" (referring of course to me studying it intently!)

Hahah, I'll be busy studying it for sure, as well as my VBA programming primer. Been taking notes in an exercise book, I find this helps me memorise and assimilate critical concepts.

 

[jleach]

I've been a big fan of Wrox Professional Programmers series for many years. When I first got into Access I picked up a copy of their Access 2003 Programming book and still refer to it to this day when I need to do a collection class.

Since then I've read the 2010, 2013 and 2016 ones as well. 2010 is meh, covering Web Database (SP versions) which of course are defunct, and 2013 covered the usual regulars but with a focus on AWAs (also a dead avenue). 2016 is a bit more filled out and has updated information on ribbons and some of the newer features, so if you want a newer one that would be my recommendation. I do still tend to think that the 2003 version was much better though, having none of the new-yet-useless features since 2007 that the authors had to cover. The Inside Out books tend to get high praise as well, though I've never been through one myself. The author, Jeff Conrad aka the Access Junkie, was an MVP for years then hired by Microsoft and worked on the Access team for additional years. Probably wouldn't be a waste of money.

For SQL related stuff, anything by John Visceas (SQL for mere mortals). Another recent recipe-like book by a number of big names is called Effective SQL: 61 Specific Ways to Write Better SQL. Both of these though will pretty much ignore the query designer in favor of writing raw SQL, which is not a bad thing, IMO, though maybe not for starters.

There's a bunch of other areas besides just Access that can greatly improve your skills. Code Complete by Steve McConnell is one of the best books on the topic of writing code that I've ever read. Everyone should have a copy. SQL Performance Explained is superb, taking the relative layman into the black box that is the internals of the relational database engine. Software Requirements (3rd ed., MS Press) is a great book on what's probably the most boring topic there can be. Head First software development can help with how to manage a project. Sometimes they feel akin to "for dummies" books, but for a good general overview they're usually not a waste of money.

Learning other languages can be a huge help as well. If you have anything in mind let me know, I can probably offer a review of something there as well.

 

[isladogs]

Another excellent source of info is of course the many sites specialising in advice and examples for Access.

Here is a small selection of those I use regularly :
http://allenbrowne.com/tips.html (Allen Browne)

http://access.mvps.org/access/datetime/index.html (Dev Ashish)

http://codekabinett.com/index.php?Lang=2 (Phillip Stiefel)

http://www.helenfeddema.com/ (Helen Feddema aka Access Archon)

There are many more ...

Also excellent though more targeted at Excel is
http://www.cpearson.com/Excel/MainPage.aspx (Chip Pearson)

There are numerous excellent videos on You Tube
The best is probably the extensive series targeted at everybody from Beginner to Advanced by Steve Bishop (over 100 in all)

Tony Hine (Uncle Gizmo) also has many very good videos online

There are also many good videos on the Datapig website:
http://www.datapigtechnologies.com/AccessMain.htm - fairly old but still worth looking at

 

[Uncle Gizmo]

There's a very old book here:- http://c85.cemi.rssi.ru/access/books/A97ExSol/contents.htm getting on for 20 years old I reckon. I revisit it from time to time mainly nostalgically but it does have some interesting Concepts which are worth exploring..

Edit;-
By the way, the Author is the guy that come up with the "Leszynski Naming Convention"

 

[Uncle Gizmo]

This website is brilliant! Always got some new stuff on it, well worth keeping an eye on...

https://www.devhut.net/

 

[MarkK]

If you write code at all, you should read Clean Code, by Robert C. Martin

imo,
Mark

 

[isladogs]

Frankly, I think by providing lots of reference sources other than AWF, all of us who have contributed suggestions, including myself, should be instantly banned for advertising.

For further information, please see this thread starting at post 7
https://access-programmers.co.uk/forums/showthread.php?t=297262

EDIT - partly in case anyone doesn't realise I'm joking....
The Clean Code book looks great but the reviews state its written for java.
If anyone knows a good VBA equivalent, I'd be interested

 

[jdraw]

Leo,
I realize the subject here is Books!, but I'd like to mention that there are a number of free youtube videos by "Uncle Bob" (Robert C Martin) related to programming, design, code improvement....

A couple of books for the list:
Database Design for Mere Mortals by Michael Hernandez
SimplySQL by Rudy Limeback (used to be a free pdf)

Like others, I find some of the older books, including Access '97 Developers Handbook useful (maybe nostalgic as Tony mentioned).

I often mention this link to people getting into, or back into, database. It's pretty basic, but good for concepts.