Features
- Cover Type: Paperback with 432 pages
- Published by: For Dummies
- Edition: 1st Edition December 26, 2006
- Written in: English
- ISBN 10 Number: 0470046120
- ISBN 13 Number: 978-0470046128
-
Book Dimensions:
9.1 x 7.4 x 1 inches
- Weighs: 1.5 pounds
Product Description
Reduce stress with timesaving database shortcuts
Explore database basics and build tables and reports that corral your data
Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, here's where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other Office applications, use wizards to automate your work, and much more.
Discover how to
* Create a new Access database
* Import and export data
* Build forms for efficient data entry
* Search tables for specific data
* Construct custom reports
* Customize your database navigation
Back Cover Copy
Reduce stress with timesaving database shortcuts Explore database basics and build tables and reports that corral your data Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, here's where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other Office applications, use wizards to automate your work, and much more.
Discover how to - Create a new Access database
- Import and export data
- Build forms for efficient data entry
- Search tables for specific data
- Construct custom reports
- Customize your database navigation
Reader ReviewsMy spouse volunteered to take on a data collection and manipulation project for a non-profit using Access. Here is her report: I was familiar with the basics of relational database design, and had used Access to a limited extent about 8 years ago. I had a good understanding of the data and how it would be used, so designing a robust database was pretty straightforward. My limitation was the nuts and bolts mechanics of using Access, especially the new 2007 version. I collected about 5 books on Access 2007 from the library, and this is the one really dove into, and ultimately ended up buying. I would say that if you are using Access 2007 you should be sure to buy a book specific to 2007, not earlier versions. I really like the format of the book--it is organized into logical sections that are easy to follow. I especially like the way the infomation is presented-- there are plenty of examples with adequate illustrations, but the basic ideas are well explained before the examples, so that I found it easy just to sit down and read it to absorb most of the basic ideas. Then after I had acquired a good overview of, say, forms and their applications, I went back to the examples to try them out on my own data. Many of the other books I used explained the concepts only through the examples, so unless you were actually sitting at the computer following each and every step it was difficult to gather the fundamental concepts. I think the sections on basic database design concepts would be adequate for those not so familiar with relational databases. I did find one major omission that is critical enough that I ended up buying another book to supplement this one. I did not find any reference to action queries such as update, append, and delete. These have been really crucial to me as I consolidate date from many different sources, and the lack of info on action queries is glaring! (I'll admit that I didn't read EVERY word of this book, so I guess it is possible that I somehow overlooked it, but I was read the first 250 out of 350 pages pretty carefully.) I ended up buying "The Unofficial Guide to Access 2007" by Jim Keogh to supplement, but I'll warn you even that one has misinformation on the format of update queries... All in all, though, I found this book to be a great basic introduction--concisely written, in an easily digested style. Very useful.