Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
Access Inside Out Books

 

Microsoft Access 2013 Inside Out

 

My new book on Access 2013 is now available for purchase!

Here is a link to the book on Amazon's site:

 

Microsoft Access 2013 Inside Out

The Microsoft Access development team focused their resources this time on enabling Access users to create and design Access web apps to use with a SharePoint server running Access Services, including Office 365. You can work with your web app inside a web browser. The web app features are a lot to cover, so the first 600 pages of my 2013 book is completely devoted to working with Access web apps. This book has approximately 800 printed pages, plus an additional 1100+ pages of extra chapters and articles available for download.

 

There are many books concerning Access 2013 on the market, but no other book gives you as many insights, tips, and tricks as this one does concerning Access 2013 web apps. I have the unique experience of testing the product every day in my job as a Software Test Engineer for the Access team. Throughout the course of writing this book, I consulted with the program managers, developers, and other testers who worked on Access 2013. With this book, you'll learn first hand about all the new web app features in Access 2013 from the people who designed, developed, and tested the program.

Included with the book are sample Access web apps and traditional desktop databases that you can use to follow along with my chapter examples. You can also use these to study other feature areas in more detail that I couldn't cover within the text. My Access web app samples are very complex and demonstrate many different techniques you can use in your own Access web apps.

 

Here are just a few of the new Access 2013 web app features covered in this book:

  • Build an Access Services web app with Microsoft SharePoint Server and Office 365
  • Create tables in your Access web app using built-in templates
  • Automate your Access web app with data macros
  • Aggregate and display your web app data using totals queries
  • Use the new Autocomplete control to quickly search for related data
  • Create a Summary view to consolidate and group information
  • Display related data on your views with the new Related Items control
  • Package your web app for use by others in your organization
  • Use the SharePoint Store to install Access web apps
  • Change SharePoint theme styles to quickly change the look and feel of your entire app
  • Create UI macros to automate your app in a web browser
  • Work with your app in a web browser and make changes to your app
  • Create custom Action Bar buttons

 

There is much more material in the book, too. This truly is the most comprehensive book on Access 2013. You definitely get your money’s worth out of this comprehensive resource!

 

 

I hope you enjoy it!

 


Microsoft Access 2010 Inside Out

 

Here is a link to the book on Amazon's site for the 2010 edition of my Access Inside Out book:

 

Microsoft Access 2010 Inside Out

My book covering Access 2010 is even larger than the 2007 release. The Microsoft Access development team added many new features to this release including the ability to publish your database to a SharePoint server running Access Services and work with your application inside a web browser. When you have a product as feature rich as Access is and then add an entirely new server element into the picture, there was a lot of new material to cover. This book has approximately 1400 printed pages, plus an additional 400 pages of extra chapters and articles on the accompanying CD.

 

There are many books concerning Access 2010 on the market, but no other book gives you as many insights, tips, and tricks as this one does. I have the unique experience of testing the product every day in my job as a Software Test Engineer for the Access team. Throughout the course of writing this book, I consulted with the program managers, developers, and other testers who worked on Access 2010. With this book, you'll learn first hand about all the new features in Access 2010 from the people who designed, developed, and tested the program.

The accompanying CD is packed full of sample client and web databases that you can use to follow along with my chapter examples. You can also use these to study other feature areas in more detail that I couldn't cover within the text.

 

You can view a demo of my main Access Services web application used in this book on the Access Show: Access Services Demo

 

Here are just a few of the new Access 2010 features covered in this book:

  • Designing web tables
  • Using Application Parts
  • Using Data Type Parts to quickly add new fields or groups of fields to your tables
  • Creating data macros to add business logic to the data layer
  • Exploring the new Logic Designer to create macros
  • Working with web queries
  • Using web templates
  • Designing web forms that display in a web browser
  • Using shared images throughout your forms and reports
  • Changing theme styles to quickly change the look and feel of your entire application
  • Designing web reports that display in a web browser
  • Creating web macros to automate your application in a web browser
  • Publishing your web database to a SharePoint 2010 Server to create an Access Services site
  • Working with your application in a web browser, making changes to your application, and synchronizing those changes to the server
  • Instantiating web templates on the server
  • Customizing the ribbon and Backstage view
  • Creating your own custom Application Parts, Data Type Parts, and database templates

There is much more material in the book, too. This truly is the most comprehensive book on Access 2010 and you'll get the unique perspective from the people who helped created the program. You definitely get your money’s worth out of this comprehensive resource!

 

Here is some feedback I have received on my book:

 

"I bought your book and have just finished all 1,440 pages of instruction, doing about 70% of the examples and how-tos. I simply have to express my admiration to you for this simply monumental work. I cannot fathom the hours this book must have taken. The results are nothing short of phenomenal.

You are a genius and I just have to say so."

 

 

"...the BOSS app is by far the best reference for unlearning VBA and learning how to apply macros.

I was counting the days until your book came out and it was worth the wait."

 

"I just bought your book Access 2010 Inside Out and want to tell you how impressed I am. I've never before bought a book that was so large that some of the chapters were delivered via CD with the book rather than printed in the book. Your book is the best source I have found to learn the new web database features of Access 2010. It is a godsend."

 

"I took several Access Tutorials and visited lots of websites to learn how to program (had never used VBA). I consider myself pretty savvy on the concepts of databases and programming, but I was really struggling. That is until one of my searches turned up a reference to your book "Access 2010 Inside/Out". I compared it to the other books available and then purchased it. I learned more from your book in one day than I had learned in 2 weeks using the other references. It is a great book. You write the way designers think and work. It makes a tremendous difference."

 

"Your Microsoft Access 2010 Inside Out book is clearly the easiest book to follow I've encountered on the subject, while at the same time covering all the little goodies that exist inside the application. Other books I've read with the same content are nearly impenetrable in their readability."

 


 

Microsoft Office Access 2007 Inside Out

 

Our Inside Out book covering Access 2007 is available for purchase. Here is a link to the book listing on Amazon's site:

 

Microsoft Office Access 2007 Inside Out

 

Visit the Microsoft Press site to learn more about our book and review important links:

http://www.microsoft.com/mspress/books/9784.aspx

 

I was honored with the opportunity to work side by side with the living legend John Viescas on this project. John is a renowned author, speaker, and Access database designer. He has been working with Access since version 1.0 came out in the early 1990s. We teamed up together to work on his latest book with the new Microsoft Office Access 2007 program.

 

John and I spent approximately a year of time becoming familiar with the 2007 release, testing the program for bugs, revising existing sample databases, and adding in new material. Working with John on this project was a rewarding experience in my life and I’m honored to count John as one of my friends. It’s hard to imagine that we completed this project while being separated by thousands of miles, one ocean, and nine time zones. (John lives in Paris, France and I live in the western United States!)

Our book is packed not only with information concerning Access 2007, but we also include topics about general database design and development. We also cover connecting your Access program to other data sources including Microsoft Windows SharePoint Services, Microsoft SQL Server, and Microsoft Visual FoxPro. Our book of course would not be complete without covering all the new features of Access 2007 including the new Office Fluent Ribbon interface, the Navigation Pane, the new Layout and Report views, and countless other additions. The accompanying CD comes packed with additional sample databases, articles, and chapters. We simply ran out of room in printed text so Microsoft Press added several chapters onto the CD. I believe there is around an additional 250 pages of printed material on the CD. You definitely get your money’s worth out of this comprehensive resource!

 

Microsoft Office Online posted four articles with material from our book. You can read them at the links below and decide for yourself if the book is right for you.

 

Exploring a desktop Access 2007 database:

https://support.office.com/article/561ff943-d8e0-481c-aeeb-f45390763a46
 

Create an Access 2007 database using templates:

https://support.office.com/article/7950eb23-64d3-4b60-8663-e22319463dd4
 

Build forms in Access 2007 using design tools:

https://support.office.com/article/4181b26d-e83d-4219-bd85-7010c4d6feb2
 

Automate applications with macros in Access 2007:

https://support.office.com/article/97fd7fe1-c92f-41f7-bb74-9ec980566b9c
 

I hope you enjoy reading this massive book. If you want to learn the "insides" of Access 2007, this is the book you need! It has everything and the kitchen sink!

 


2007 Microsoft Office System Inside Out

 

I'm also very pleased to report that Microsoft Press took six chapters from our Access 2007 Inside Out book and included them in the 2007 Microsoft Office System Inside Out  book. You can find more information about that book by visiting this page on the Microsoft Press web site:

Visit the Microsoft Press site to learn more about this book and review important links:

http://www.microsoft.com/MSPress/books/9712.aspx

 

 

 

Back to top