Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime
and start saving today with fast, free delivery
Amazon Prime includes:
Fast, FREE Delivery is available to Prime members. To join, select "Try Amazon Prime and start saving today with Fast, FREE Delivery" below the Add to Cart button.
Amazon Prime members enjoy:- Cardmembers earn 5% Back at Amazon.com with a Prime Credit Card.
- Unlimited Free Two-Day Delivery
- Streaming of thousands of movies and TV shows with limited ads on Prime Video.
- A Kindle book to borrow for free each month - with no due dates
- Listen to over 2 million songs and hundreds of playlists
- Unlimited photo storage with anywhere access
Important: Your credit card will NOT be charged when you start your free trial or if you cancel during the trial period. If you're happy with Amazon Prime, do nothing. At the end of the free trial, your membership will automatically upgrade to a monthly membership.
-67% $13.19$13.19
Ships from: Amazon Sold by: Shakespeare Book House
$11.87$11.87
Ships from: Amazon Sold by: Martistore
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Access 2010: The Missing Manual 1st Edition
Purchase options and add-ons
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
Let’s face it--learning the tricks and techniques of database design can be a bit of a slog. But if you’re just starting out with Access, here are five key insights that can help you understand how the database world works. Keep these points in mind, and you’ll be on the inside track to mastering Access.
3. There are two ways to work with a database: as a designer and as a user. The database designer is the person who sets up the database. The database designer has the responsibility of laying out the tables, building the queries, and knocking together some nice reports and forms (assuming you want all those features). By comparison, the database user is the person who uses the tables, queries, reports, and forms in day-to-day life. The user reviews records, makes changes, and fills the tables up with data.
Depending on what type of database you’re creating (and what you want to accomplish), you may be both the database designer and the database user. But it’s important to realize that these are distinct tasks. In fact, when using a properly designed database, database users don’t need to be particularly skilled with Access. They can just work with the forms and reports that the database designer created.
4. Sooner or later, you’ll need macros. To become an Access expert, you must first learn to design a logical, consistent set of tables and add the relationships that link them together. Next, you must learn to build the other types of objects--queries, forms, and reports--that make it easier to perform common tasks. At some point, while tackling this second stage, you’ll run into a challenge that forces you to step up to the third level of Access mastery: macros.
Macros are miniature programs that perform custom tasks. The good news is that in Access 2010, you can design your own macros without becoming a programmer. You just need to drag, drop, and arrange a sequence of ready-made macro commands into the Access macro designer. For example, you can use macros to build buttons that send emails, start printouts, make updates, or just take you around your database.
5. Expert user, meet Visual Basic. Some people stop their Access journey at this point, content to use tables, forms, reports, and macros to do all their work. But if you want to see everything Access has to offer, you need to take a look at its high-powered Visual Basic engine. Using VB code, you can do almost anything, from validating a credit card to leading a customer through an order process (two examples that are discussed in Access 2010: The Missing Manual). And if you’re willing to pick up some basic programming concepts, you can use code to transform a simple database into a cohesive database application—for example, something that looks more like the traditional desktop programs you run on your computer.
- ISBN-109781449382377
- ISBN-13978-1449382377
- Edition1st
- PublisherO'Reilly Media
- Publication dateJuly 27, 2010
- LanguageEnglish
- Dimensions7.32 x 1.76 x 9.09 inches
- Print length830 pages
Frequently bought together
Customers who bought this item also bought
Editorial Reviews
About the Author
Product details
- ASIN : 1449382371
- Publisher : O'Reilly Media; 1st edition (July 27, 2010)
- Language : English
- Paperback : 830 pages
- ISBN-10 : 9781449382377
- ISBN-13 : 978-1449382377
- Item Weight : 3.14 pounds
- Dimensions : 7.32 x 1.76 x 9.09 inches
- Best Sellers Rank: #1,551,348 in Books (See Top 100 in Books)
- #4 in ODBC Networking
- #109 in Microsoft Access Database Guides
- #131 in Computer Programming Structured Design
- Customer Reviews:
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon-
Top reviews
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
2. Unfortunately, if you are NEW to a particular software--especially if you are TOTALLY brand new--these "missing manual" books may not be the ONLY books that you'll find necessary. It is possible that you could get away with just this one book but probably you'd be well advised to buy a "beginners" book, probably one that is in full color. I don't know why a full color book is better for beginners, but this seems to be the case. This is what I recommend if you are a neophyte.
3. With respect to Access 2010 software: this particular software does have a steep learning curve. I have had previous experience with a DOS based relational database in the mid to late 1980's and learning Access 2010 has still not been easy for me. I sometimes think that after I learn Access 2010 to a fuller extent I would be able to write a better "beginner's manual" than those available. But in my opinion nothing could exceed the brilliance and quality of Matthew MacDonald's "Access 2010 the missing manual". BUY THIS BOOK.
/s/ JGH Access 2010: The Missing Manual
I appreciated Matthew MacDonald's consistent writing style, it contrasts with the obviously committee written mish mash of The Access Bible. The style is breezy and light without being trivial or meandering. Examples are clear and to the point without confusion.
When learning Access and VBA one thing that becomes instantly and painfully obvious is that there are many many ways to skin a cat. MacDonald avoids this by avoiding most of the confusion in Access. For example the ADO vs. DAO confusion rates two paragraphs whereas The Access Bible gives it most of a chapter without delivering any clarity.
In conclusion, if you already know Excel and want to move up in your data handling skill this is a great place to start. If I had one request it would be for more depth in using VBA.
Top reviews from other countries
I would have liked only one thing to be explored more in depth and that is designing your tables / database. While the book explains very well where to click and what steps to follow, it falls in my opinion a bit short on explaining what actually makes a good table. Perhaps a few pages on normalisation etc would have been very useful. After all this is the foundation of your database and this subject definitely can not be overlooked. Of course there are plenty of resources online to read about this but for the novice user it would be very helpful to have this included in the book.
Still, brilliant book overall and does the job fantasticly! 5/5
目次もあり内容も非常に幅広く網羅されている。説明も丁寧。こういったものを日本でも翻訳して出版出来ないものか。
私は良い本と思います。
Very well presented, explained and illustrated. I downloaded the kindle version which is fine and works well but as many will tell you a hardback copy is best so you can easily scim through and find what your looking for, something that kindle does allow you to do but not the same as a real book, so after xmas I will purchase the hard copy for work.