Access Junkie - MVP Alumnus - SDET Access

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

 

Microsoft Access 2010 Inside Out

 

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

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

 

Microsoft Access 2010 Inside Out

 

My new 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 untill 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."

 

 

 

I hope you enjoy it!

 


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:
http://office.microsoft.com/en-us/access/HA102326851033.aspx


Create an Access 2007 database using templates:
http://office.microsoft.com/en-us/access/HA102326861033.aspx


Build forms in Access 2007 using design tools:
http://office.microsoft.com/en-us/access/HA102326841033.aspx


Automate applications with macros in Access 2007:
http://office.microsoft.com/en-us/access/HA102326831033.aspx

 

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

 

You can see more information about this comprehensive guide to using Office 2007

by following this link:

http://jaldous.spaces.live.com/blog/cns!E96EF855D659204A!1897.entry

 

 

Back to top