Access 2010: The Missing Manual

Missing Manuals

by Matthew MacDonald

Go from Access novice to true master with the professional database design tips and crystal-clear explanations in this book. You'll learn all the secrets of this powerful database program so you can use your data in creative ways -- from creating product catalogs and publishing information online to producing invoices and reports. 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 brand-new 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, Computers, Nonfiction, Business, Technology, 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 · Rating 4 out of 5]

ك

[Jonathan · Rating 5 out of 5]

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 · Rating 5 out of 5]

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 · Rating 4 out of 5]

Very helpful book - I refer to it often.

[Leighanne · Rating 4 out of 5]

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 · Rating 4 out of 5]

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