Access 2007 AIO Desk Reference For Dummies

From the Back Cover
Give your Access confidence a boost by mastering the new interface!
Your one-stop guide to the revised, mode user-friendly release of Access.

Access 2007 got a total makeover, and this all-in-one guide helps you work with confidence even if you’re all new to Access. The individual work with confidence even if you’re all new to Access. The individual mini books show you how to create and work with tables, queries, forms, reports, and macros; manage databases; and program Access with VBA.

Discover how to:

Create a database quickly and easily from templates
Sort, find, and filter data
Use queries to gather data
Perform calculations in forms
Automate actions with macros
Secure your Access database
About the Author
Alan Simpson is the author of over 115 computer books on all sorts of topics: Windows, databases, Web-site design and development, programming, and network administration. His books are published throughout the world, in over a dozen languages, and have sold millions of copies. Though definitely in the techno-geek category, we let him contribute anyway because sometimes people like that come in handy.
Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and(stab from the past) PC-File and Javelin, including The Internet For Dummies (Wiley) and Windows XP Home Edition: The Complete Reference (Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high-school computer clubs. Her other passions are her children, music, Unitarian Universalism(www.uua.org), reading, and anything to do with cooking or eating.

Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3,and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. In real life she hangs out with her “guys” — Parker, 6, and Mason, 4, and Evan 2 — and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.

April Wells is a graduate of the University of Pittsburgh nd holds an MBA from West Texas A&M. She is a database administrator with expertise in a wide variety of enterprise database software programs, including Oracle, DB2, MySQL, and Access. She is the author of several books and white papers on database software and is a frequent public speaker, trainer, and consultant.

Related Articles

Microsoft Office Access 2007 All-in-One Desk Reference for Dummies

– Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover beginning to advanced-level material
– Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros
– Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web
– Access is the world’s leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Access 2010 All-in-One for Dummies

The all-in-one reference to all aspects of Microsoft Access 2010
If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.

Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010
Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web
Helps you build database solutions that integrate with the Web and other enterprise data sources
Offers plenty of techniques, tips, and tricks to help you get the most out of Access

This all-in-one guide contains everything you need to start power-using Access 2010!

Microsoft Office Access 2007 VBA Programming For Dummies

If you’ve been using Access for a while, you’re probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:
– Basic programming skills and concepts
– Explanations of modules, procedures, objects, and arguments
– Access-unique programming activities, including SQL and recordsets
– How to use the Visual Basic editor
– Creating dialog boxes, lists, drop-down menus, and functions
– Integrating with other Office applications
– Ready-to-use VBA code examples to type in or copy and paste from the Web

Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you’ve never had it before.

WordPerfect 12 for Dummies

Do you take the shortest route instead of the side roads when you’re trying to get somewhere? Do you choose the streamlined model instead of one loaded with gizmos and gadgets? Do you value ease over extras? WordPerfect 12 is practical software designed to help you create great-looking, readable documents. Whether you’re a recent convert from longhand (welcome to the modern world) or a word processing pro, WordPerfect12 For Dummies covers what you need to know, including:
The basics, like using menus and toolbars, saving, editing, and printing files, getting help, and more
Editing and formatting text, adding page numbers, charts, cool fonts, borders, backgrounds, and more
Using templates to make your life easier
Creating envelopes and labels and doing multiple mailings
Using the compatibility toolbars, Workspace Manager, Office Ready template browser, and wireless office capabilities
Creating and integrating columns, tables and graphics
Creating Web pages, Adobe Acrobat Documents, XML files, and even Microsoft Office documents
Publishing your document as a Web Page
WordPerfect12 For Dummies was written by Margaret Levine Young, David C. Kay, and Richard Wagner, all computer gurus who have written or contributed to other For Dummies books and numerous computer books. After it shows you how to do what you need to do, it inspires you to do things you probably didn’t know you could do, such as:

Changing Workspaces to the WordPerfect Legal mode if you need to create legal documents
Choosing from 26 different tool bars to fit the way you work and what you’re working on
Using WordPerfect Office Ready for 40 additional templates
Printing bar codes
Using Microsoft Outlook contact information in Word Perfect

First you’ll get comfortable with WordPerfect 12, and then you’ll get confident and want to explore more. Whether you are a beginner, need a quick refresher, or want to take advantage of the advanced functions, with its complete index, WordPerfect12 For Dummies will be the reference you rely on.

WordPerfect 12 for Dummies

Do you take the shortest route instead of the side roads when you’re trying to get somewhere? Do you choose the streamlined model instead of one loaded with gizmos and gadgets? Do you value ease over extras? WordPerfect 12 is practical software designed to help you create great-looking, readable documents. Whether you’re a recent convert from longhand (welcome to the modern world) or a word processing pro, WordPerfect12 For Dummies covers what you need to know, including:

The basics, like using menus and toolbars, saving, editing, and printing files, getting help, and more
Editing and formatting text, adding page numbers, charts, cool fonts, borders, backgrounds, and more
Using templates to make your life easier
Creating envelopes and labels and doing multiple mailings
Using the compatibility toolbars, Workspace Manager, Office Ready template browser, and wireless office capabilities
Creating and integrating columns, tables and graphics
Creating Web pages, Adobe Acrobat Documents, XML files, and even Microsoft Office documents
Publishing your document as a Web Page

WordPerfect12 For Dummies was written by Margaret Levine Young, David C. Kay, and Richard Wagner, all computer gurus who have written or contributed to other For Dummies books and numerous computer books. After it shows you how to do what you need to do, it inspires you to do things you probably didn’t know you could do, such as:

Changing Workspaces to the WordPerfect Legal mode if you need to create legal documents
Choosing from 26 different tool bars to fit the way you work and what you’re working on
Using WordPerfect Office Ready for 40 additional templates
Printing bar codes
Using Microsoft Outlook contact information in Word Perfect

First you’ll get comfortable with WordPerfect 12, and then you’ll get confident and want to explore more. Whether you are a beginner, need a quick refresher, or want to take advantage of the advanced functions, with its complete index, WordPerfect12 For Dummies will be the reference you rely on.