Access 2010: The Missing Manual

Missing Manuals

by Matthew MacDonald

Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book's easy step-by-step process, you'll quickly learn how to build and maintain a complete Access database, using Access 2013's new, simpler user interface and templates. You also get practices and tips from the pros for good database design--ideal whether you're using Access for school, business, or at home.The important stuff you need to Build a database with ease. Store information to track numbers, products, documents, and more.Customize the interface. Build your own forms to make data entry a snap.Find what you need fast. Search, sort, and summarize huge amounts of information.Put your data to use. Turn raw info into printed reports with attractive formatting.Share your data. Collaborate online with SharePoint and the Access web database.Dive into Access programming. Get tricks and techniques to automate common tasks.Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.

Genres: Reference, Nonfiction, Computers, Technology, Business, Programming, Self Help

834 pages, Kindle Edition

First published June 18, 2010

About the author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. He's particularly known for his books about building websites, which include a do-it-from-scratch tutorial (Creating a Website: The Missing Manual), a look at cutting-edge HTML5 (HTML5: The Missing Manual), and a WordPress primer (WordPress: The Missing Manual). He's also written a series of books about programming on and off the Web with .NET, teaches programming at Ryerson University, and is a three-time Microsoft MVP.

Reviews

[Thomas]

Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home.

The important stuff you need to know:

Build a database with ease. Store information to track numbers, products, documents, and more.
Customize the interface. Build your own forms to make data entry a snap.
Find what you need fast. Search, sort, and summarize huge amounts of information.
Put your data to use. Turn raw info into printed reports with attractive formatting.
Share your data. Collaborate online with SharePoint and the Access web database.
Dive into Access programming. Get tricks and techniques to automate common tasks.
Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.

[Fahad]

ك

[Jonathan]

For someone who had had prior experience with data manipulative/analytical software in education and professional background, my current job really needed me to take a step back and grasp/master all the basic + finer points of Microsoft Access, including integrating my macro and Visual Basic knowledge into database design, datasheet manipulation and data management. MacDonald's manual is superb- I can imagine all levels of Access experience- from my relative inexperience to the more proficient user- gaining and learning a great deal from reading this book. It really helped me sharpen my knowledge of how SQL is integrated into Access' query structure, how to design and perfect forms, and the fine minutia of relational database generation. Highly recommended!

[Amanda Huber]

The instructions were very clear and very detailed in creating basic to advanced databases. I felt comfortable creating, editing, and manipulating databases after reading this book and still find it helpful for reference to specific sections. The examples were entertaining and gave a broad perspective of how a database can be used based on your needs. As a library assistant keeping track on hundreds of newly aquired library items I find databases to be the most useful and most organized method for record keeping and pulling information. Honing my skills in access databases with the help of this book has made my job easier and more efficient.

[Dianne]

Very helpful book - I refer to it often.

[Leighanne]

Not as detailed as I wanted, but I still learned a lot. Where can I find "the missing manual that teaches you to make access do everything"

[Earl]

Overall a great reference book for MS Access. Definately recommend to another for learning MS Access and database fundamentals.