Microsoft Office Access 2007 On Demand [Paperback]

Steve Johnson (Author), Perspection Inc. (Author)

Book Description

ISBN-10: 0789736411 | ISBN-13: 978-0789736413 | Publication Date: January 9, 2007 | Edition: 1

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

Editorial Reviews

About the Author

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.

Excerpt. © Reprinted by permission. All rights reserved.

Introduction

How You'll Learn

• How This Book Works
• What's New
• Keyboard Shortcuts
• Step-by-Step Instructions
• Real World Examples
• Workshop
• Microsoft Certified Applications Specialist
• Get More on the Web

Welcome to Microsoft Office Access 2007 On Demand, a visual quick reference book that shows you how to work efficiently with Microsoft Office Access. This book provides complete coverage of basic to advanced Access skills.

How This Book Works

You don't have to read this book in any particular order. We've designed the book so that you can jump in, get the information you need, and jump out. However, the book does follow a logical progression from simple tasks to more complex ones. Each task is presented on no more than two facing pages, which lets you focus on a single task without having to turn the page. To find the information that you need, just look up the task in the table of contents or index, and turn to the page listed. Read the task introduction, follow the step-by-step instructions in the left column along with screen illustrations in the right column, and you're done.

What's New

If you're searching for what's new in Access 2007, just look for the icon: New!. The new icon appears in the table of contents and through out this book so you can quickly and easily identify a new or improved feature in Access 2007. A complete description of each new feature appears in the New Features guide in the back of this book.

Keyboard Shortcuts

Most menu commands have a keyboard equivalent, such as Ctrl+P, as a quicker alternative to using the mouse. A complete list of keyboard shortcuts is available on the Web at http://www.perspection.com.

Step-by-Step Instructions

This book provides concise step-by-step instructions that show you "how" to accomplish a task. Each set of instructions include illustrations that directly correspond to the easy-to-read steps. Also included in the text are timesavers, tables, and sidebars to help you work more efficiently or to teach you more in-depth information. A "Did You Know?" provides tips and techniques to help you work smarter, while a "See Also" leads you to other parts of the book containing related information about the task.

Real World Examples

This book uses real world examples files to give you a context in which to use the task. By using the example files, you won't waste time looking for or creating sample files. You get a start file and a result file, so you can compare your work. Not every topic needs an example file, such as changing options, so we provide a complete list of the example files used through out the book. The example files that you need for project tasks along with a complete file list are available on the Web at http://www.perspection.com.

Workshop

This book shows you how to put together the individual step-by-step tasks into indepth projects with the Workshop. You start each project with a sample file, work through the steps, and then compare your results with project results file at the end. The Workshop projects and associated files are available on the Web at http://www.perspection.com.

Microsoft Certified Applications Specialist

This book prepares you for the Microsoft Certified Applications Specialist (MCAS) exam for Microsoft Office Access 2007. Each MCAS certification exam has a set of objectives, which are organized into broader skill sets. To prepare for the certification exam, you should review and perform each task identified with a MCAS objective to confirm that you can meet the requirements for the exam. Throughout this book, content that pertains to an objective is identified with the following MCAS logo and objective number next to it.

Get More on the Web

In addition to the information in this book, you can also get more information on the Web to help you get up to speed faster with Access 2007. Some of the information includes:

Transition Helpers

• Only New Features. Download and print the new feature tasks as a quick and easy guide.

Productivity Tools

• Keyboard Shortcuts. Download a list of keyboard shortcuts to learn faster ways to get the job done.

More Content

• Photographs. Download photographs and other graphics to use in your Office documents.
• More Content. Download new content developed after publication. For example, you can download a complete chapter on Office SharePoint Server 2007.

You can access these additional resources on the Web at http://www.perspection.com.

© Copyright Pearson Education. All rights reserved.

Product Details

• Paperback: 448 pages
• Publisher: Que; 1 edition (January 9, 2007)
• Language: English
• ISBN-10: 0789736411
• ISBN-13: 978-0789736413
• Product Dimensions: 9.1 x 7.6 x 0.7 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #470,787 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

15 of 16 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 Microsoft Certified Application Specialist, so upon completion of the book you should be ready to take the test.

I have only one minor complaint about the book. I know, you aren't supposed to talk SQL with Access, but sometimes you almost have to. On page 156 they say 'If you know SQL....' But even if you know SQL, you need to know the reserved words.I'd really like to see just a few pages in an appendix talking about things like the reserved words in the Jet engine.

6 of 8 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 

David Pease "moviefan" (Seattle, WA) - See all my reviews
(REAL NAME)   

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.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Good Book for Class, September 26, 2010

By 

SunnySideUp24 - See all my reviews

Amazon Verified Purchase

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.