Ships from: Avenel, NJ
Usually ships in 1-2 business days
Ships from: Idyllwild, CA
Usually ships in 1-2 business days
Ships from: San Jose, CA
Usually ships in 1-2 business days
Want a NOOK? Explore Now
Microsoft Office Access 2007
For those who would rather be shown how than told how
See How To
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
IntroductionIntroductionHow You'll Learn
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
You can access these additional resources on the Web at http://www.perspection.com.
© Copyright Pearson Education. All rights reserved.
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
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.
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.
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.
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.
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.
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 .
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 .
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.
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:
You can access these additional resources on the Web at http://www.perspection.com .
© Copyright Pearson Education. All rights reserved.
Overview
Microsoft Office Access 2007
For those who would rather be shown how than told how
See How To