Home > Store > Databases > Access

larger cover

Add To My Wish List

Microsoft Office Access 2007 On Demand

  • By Steve Johnson, . Perspection Inc.
  • Published Dec 30, 2006 by Que. Part of the On Demand series.
    • Copyright 2007
    • Dimensions: 7-1/2x9-1/8
    • Pages: 448
    • Edition: 1st
    • Book
    • ISBN-10: 0-7897-3641-1
    • ISBN-13: 978-0-7897-3641-3
    • eBook (Adobe DRM)
    • ISBN-10: 0-7686-7449-2
    • ISBN-13: 978-0-7686-7449-1

Register your product to gain access to bonus material or receive a coupon.

  • Description
  • Reviews
  • Sample Content

Product Author Bios

Steve Johnson has written more than 35 books on a variety of computer software, including Microsoft Office 2007 and 2003, Microsoft Windows XP, Apple Mac OS X Panther, Macromedia Flash MX 2004 and 8, Macromedia Director MX 2004, Macromedia Fireworks, and Adobe Photoshop CS and CS2. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. When time permits, he likes to travel to such places as New Hampshire in October, and Hawaii. Steve and his family live in Pleasanton, California, but can also be found visiting family all over the western United States.

Microsoft Office Access 2007

 

For those who would rather be shown how than told how

 

 

See How To

  • Create databases more efficiently using a new results-oriented interface
  • Use tools for building a database that makes information easier to find and use
  • Import data from other programs, HTML, XML files, and other databases
  • Use forms, filters, queries, and reports to capture and analyze data
  • Discover ways to prevent data corruption and unauthorized access
  • Share your data with others through interactive web pages
  • Put your newly acquired skills to work using the online workshops
  • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts
  • Use Groove and SharePoint Team Services to collaborate and share documents and information
  • Prepare for the Microsoft Certified Application Specialist (MCAS) exam

 

 

On the Web

This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com

 

Author Bio

Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more

 

Includes MCAS Exam Objectives!

This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.

 

Category Database

Covers    Microsoft Office Access 2007

User Level    Beginning–Intermediate

 

 

1 Getting Started with Access

2 Touring Access Databases

3 Planning and Creating a Custom Database

4 Working with Fields

5 Working with Tables

6 Locating Specific Information Using a Query

7 Simplifying Data Entry with Forms

8 Creating Reports to Convey Information

9 Improving the Appearance of Forms and Reports

10 Working on the Web

11 Importing and Exporting Information

12 Managing a Database

13 Protecting and Securing a Database

14 Customizing Access

15 Enhancing a Database with Programming

16 Working Together on Office Documents

New Features

Microsoft Certified Applications Specialist

Index

Customer Reviews

16 of 17 people found the following review helpful
5.0 out of 5 stars A Painless Way to Get Started, February 18, 2007
By 
John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   
This review is from: Microsoft Office Access 2007 On Demand (Paperback)
Microsoft Access is easily the most popular database on the planet. Why? Because it's a part of the Microsoft Office Suite of products. It's not all that strong a database, but it's powerful enough for databases up to 50 megabytes and a few thousand hits a day. And that fits the vast majority of the applications people have in their day to day work.

This book is a show and tell book. That is it has lots and lots of screen shots that show what your screen should look like as it tells you what's being done. This is a great way to handle a tutorial type book. As you go through the book, first you learn the general concepts of what a database is and what it does. Then you learn about Microsoft's new 'Ribbon' the new concept in user interfaces. From there you go on to learning about defining tables, putting data in and getting it out of the database, all the things that you would expect to want to know.

As an added feature, this books meets the objectives for the... Read more
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


7 of 9 people found the following review helpful
5.0 out of 5 stars Perfect for beginners and as a reference for experts, September 26, 2007
By 
This review is from: Microsoft Office Access 2007 On Demand (Paperback)
The "On Demand" series has been invaluable for me earning my certifications. They are easy to read, well laid out and beautifully illustrated in color. I highly reccomend these books.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


2 of 2 people found the following review helpful
4.0 out of 5 stars Good Book for Class, September 26, 2010
Amazon Verified Purchase(What's this?)
This review is from: Microsoft Office Access 2007 On Demand (Paperback)
This book was good for my Database Management & Design class.

The book could have been better if it provided more examples but overall, it was a great purchase.
I used it along with the examples on the Microsoft website.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Share your thoughts with other customers:
 See all 4 customer reviews...

Online Sample Chapter

Planning and Creating a Custom Database

Table of Contents

1 Getting Started with Access

2 Touring Access Databases

3 Planning and Creating a Custom Database

4 Working with Fields

5 Working with Tables

6 Locating Specific Information Using a Query

7 Simplifying Data Entry with Forms

8 Creating Reports to Convey Information

9 Improving the Appearance of Forms and Reports

10 Working on the Web

11 Importing and Exporting Information

12 Managing a Database

13 Protecting and Securing a Database

14 Customizing Access

15 Enhancing a Database with Programming

16 Working Together on Office Documents

New Features

Microsoft Certified Applications Specialist

Index

Downloadable Sample Chapter

Download the Introduction

Download Chapter 3: Planning and Creating a Custom Database

 
Best Value

Book + eBook Bundle  $67.98  $41.79

Book Price: $31.99
eBook Price: $9.80

Buy

This book includes free shipping!

Buy

Book  $39.99  $31.99

Usually ships in 24 hours.

This book includes free shipping!

Buy

eBook (Adobe DRM)  $27.99  $22.39

About Adobe DRM eBooks

Information This eBook requires the free Adobe® Digital Editions software.

Before downloading this DRM-encrypted PDF, be sure to:


  • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
  • Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
Purchase Reward: One Month Free Subscription
By completing any purchase on InformIT, you become eligible for an unlimited access one-month subscription to Safari Books Online.

Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.