Best microsoft access database guides according to redditors

From one R newbie to another, I have found the website Quick-R to be the most helpful. I was roped into using R on my thesis and have had to learn everything as I go, so I don't have the background that a lot of other R users do. That said, it's nice to have a condensed, plain-english reference without all the alphabet soup of theory.

I also use A Beginner's Guide to R to figure out the basic stuff and R in Action for more advanced topics. I don't know what your statistical background is, but you should also try to find a solid stats book related to your field.

As a last bit, and this may not be a popular sentiment on this sub, but I have found very little help through the r-help files, mailing lists, or stackoverflow. Most times the posts are written by and for people with much greater ability than mine so I have a really hard time gleaning any useful information. Also, I have found that there are a lot of condescending attitudes throughout and it's soured me to those sources. In my experience, the R community at large is not very friendly towards beginners.

Good luck on your adventuRe.

If you're looking for web app help, I would suggest looking into ASP.Net MVC. Unless there's a reason why you need webforms, I would avoid them. Check out MVC and Razor syntax. It's easier to work with and there's a clear separation of concerns with the HTML and C# code.

Check out Professional ASP.Net Design Patterns for guidance on good structuring of an ASP.Net webform/MVC project.

Powershell in depth is really good after you get done with the month of lunches.

I have looked at a few books, though I feel a tad overwhelmed by the sheer volume of C# books out there. I am not interested in just Unity though, I don't want to use it as a crutch and want to be able to make programs/games outside of it as well. Here are a few I picked out that seemed good via reviews.

The C# Players Guide


Microsoft Visual C# 2012 Step-By-Step

Beginning Visual C# 2012 Programming

Unity Game Development in 24-Hours Sams Teach yourself

Sams Teach Yourself C# 2010 in 24 hours

Pro Unity Game Development with C#

C# Programming Cookbook for Unity3D

Learnign C# Programming With Unity 3D

I have this book and I can tell you that I have not read it.

Tell her to buy this

https://www.amazon.com/Shelly-Cashman-Microsoft-Office-2016/dp/1305870018/ref=sr_1_2?ie=UTF8&qid=1526979296&sr=8-2&keywords=microsoft+office+textbook&dpID=51N3EnlQtrL&preST=_SX218_BO1,204,203,200_QL40_&dpSrc=srch

Well; honestly; good luck.

Powerpivot / Power BI is a pretty new thing; it's undergone so much change in the last 2-3 years; I strongly doubt you'll find much as far as decent resources.

For Access:
http://www.crwsystems.mb.ca/ MIGHT be willing to recommend someone;

Red river teaches courses: http://me.rrc.mb.ca/catalogue/Course.aspx?RegionCode=PC&ProgCode=COMTP-NA&CourseCode=COMP-9048

If you honestly expect you can learn Access in an hour; just grab a decent book on whatever version you are stuck using; and go from there:
https://www.amazon.ca/Power-Pivot-BI-Excel-2010-2016/dp/1615470395
https://www.amazon.com/Access-2016-Bible-Michael-Alexander/dp/111908654X/ref=sr_1_1?s=books&ie=UTF8&qid=1481653678&sr=1-1&keywords=access+2016

Asp.net Wiki: Design Patterns Looks like a good place to start after a quick [google search] (https://www.google.com/webhp?sourceid=chrome-instant&ie=UTF-8&ion=1#hl=en&sclient=psy-ab&q=ASP.net%20web%20design%20patterns&oq=&aq=&aqi=&aql=&gs_l=&pbx=1&fp=87c6230bd8e448f1&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=731&bih=536).


Design Patterns on Amazon has a bigger list of books. I like the look of Professional Asp.net and it seems well reviewed and more recent (2010).

I am in the same position as you. I am finding this book particularly useful thus far
https://www.amazon.com/Microsoft-Access-2007-Data-Analysis/dp/0470104856

I bought it used for not a lot of money

Head first is a great book but I found Professional ASP.NET Design Patterns by Scott Millett to be a little more practical for me.

You might find this book helpful.

http://www.amazon.com/Microsoft-Office-2013-1st-Illustrated-ebook/dp/B00CXMWE66/

It's on the page, just have to switch from spiral bound to kindle.

R is perfect for this, for easily making graph and analyze data. [Cousera has a course on it that will start in September that I really recommend it] ( https://www.coursera.org/course/compdata). I start learned it from [this book] ( http://www.amazon.com/gp/aw/d/0387938362/). If you have some experience with Excel it help to grasp some concepts.

That and

• Powershell In Depth (2nd edition, new) - http://www.amazon.com/PowerShell-Depth-Don-Jones/dp/1617292184/
  
• Powershell Cookbook - http://www.amazon.com/Windows-PowerShell-Cookbook-Scripting-Microsofts/dp/1449320686/
  
  
  

Powershell in a Month of Lunches - https://www.amazon.com/Learn-Windows-PowerShell-Month-Lunches/dp/1617291080/ref=sr_1_1?s=books&ie=UTF8&qid=1467232090&sr=1-1&keywords=learn+powershell+in+a+month+of+lunches

Then, when you get the hang of it, Powershell In Depth https://www.amazon.com/PowerShell-Depth-Don-Jones/dp/1617292184/ref=sr_1_1?s=books&ie=UTF8&qid=1467232074&sr=1-1&keywords=powershell+in+depth

Outside of that, check out /r/PowerShell and work through the questions that people ask. No better way to learn than practice.

Thank you for responding!! Not quite the cover has a purple background with a blue flower (Link: https://www.amazon.com/Perspectives-Microsoft-Office-Access-2016/dp/1337251453 ). The ISBN of the book is 97813058801.

Ugh I need to buy this one. Can't find it anywhere on torrents or library genesis.

To relate my experience with books written for specifically for MS Access, I will caution that the books are heavily geared towards without within other MS applications, and you typically only need about half of the book to build a working application.

Also, the Access-specific books tend you leave you hanging when it comes to VBA (Visual Basic for Applications) scripting. VBA isn't a necessity, but it does have the potential to add some niceties when it comes to working with forms. Fortunately, most "cookbook" style VBA code is widely available on the internet.

That being said, I learned a lot from the Access 2016 Bible when I was teaching myself last year. I have a copy of the MS Access For Dummies for a previous version, but the reviews of the 2016 version aren't looking too good. Once again, with the plethora of information on the web, you can probably get away with not using a book at all, so it's more a matter of preference. And reading the other comments, I'm going to add another for Django up there...

The ____ for Dummies guides are always a good place, but if you want to get serious into understanding Excel you might just want to get the appropriate text book. That way if you want you can use it to get Microsoft Certification for it.

Here's some: It depends on which version of Microsoft Office you have:

• Textbook 1
  
  
• Textbook 2
  
  
• Textbook 3
  
  
• Dummy's Book 1
  
  
• Dummy's Book 2
  
  
• Dummy's Book 3
  
  Microsoft even offers some basic training courses by itself

Beginning Visual C# 2012 Programming is a good introduction. There's a digital version of it which is pretty nice, links from the ToC go to the proper page.

I got this Access Step-by-Step book for Kindle for about $10, and found it pretty good. I haven't finished it, so I'm not sure if it gets as advanced as you're looking for, but it's definitely a good start.

The Step-by-Step books are what Microsoft uses when they do their in-store personal training, for what that's worth.

For Excel, I started with this book (technically, the '97' version but the same author) : http://www.amazon.com/Sams-Teach-Yourself-Excel-Programming/dp/0672315432

I used a similar book to this for Access: http://www.amazon.com/Sams-Teach-Yourself-Microsoft-Access/dp/0672321033/ref=sr_1_2?s=books&ie=UTF8&qid=1342728350&sr=1-2&keywords=access+programming+21+days

Not too long after that I started programming MS Office for a living. 15 years later, I now program .NET, SQL, and WEB for a living, all from starting with Excel VBA.

Best of luck.

This is how I learnt it; the reference book Access 2010 Bible has several sections in it which explain the basics and what you need to know to get started with VBA

From here, use the Developer Reference as a reference for the objects available in each program; just click on the applications you work with

I personally would say a design patterns book that is less abstract. I like it when I can link it back to what I'm doing.

This is one I read that I thought was pretty good. However with limited exposure to asp.net it will probably be cryptic and possible more advanced than you are ready for (some of the amazon review state this also). But even without, the first couple chapters are summary chapters that don't have much code and go over the "big" design patterns and concepts.

So maybe a later pickup, if you're in .NET you'll be doing ASP.NET eventually, so i'd say the book is relevant for you if not now sometime in the future.

http://www.amazon.com/gp/product/0470292784/ref=oh_details_o00_s00_i00

Professional ASP.NET Design Patterns

Kaufeld et al. is erudite and accessible.