Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
Published on 22. December 2006
Book
Paperback/Softback
768 pages
978-0-470-03649-5 (ISBN)
Description
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 minibooks 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
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 minibooks 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
More details
Edition
1. Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Dimensions
Height: 23.3 cm
Width: 18.5 cm
Thickness: 4 cm
Weight
1043 gr
ISBN-13
978-0-470-03649-5 (9780470036495)
Schweitzer Classification
Other editions
Additional editions
Alan Simpson | Margaret Levine Young | Alison Barrows
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
E-Book
03/2011
Wiley
€20.99
Available for download
Alan Simpson | Margaret Levine Young | Alison Barrows
Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
E-Book
06/2007
Wiley
€20.99
Available for download
Persons
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 and 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.
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 and 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.
Content
Introduction.
Book I: Essential Concepts.
Chapter 1: Introducing Access 2007.
Chapter 2: Getting Started, Getting Around.
Chapter 3: Creating a Database from Templates.
Chapter 4: Designing Your Database the Relational Way.
Book II: Tables.
Chapter 1: Creating and Modifying Tables.
Chapter 2: Entering and Editing Data in Datasheets.
Chapter 3: Sorting, Finding, and Filtering Data.
Chapter 4: Importing and Exporting Data.
Chapter 5: Avoiding "Garbage In, Garbage Out".
Chapter 6: Relating Your Tables and Protecting Your Data.
Book III: Queries.
Chapter 1: Creating Select Queries.
Chapter 2: Letting Queries Do the Math.
Chapter 3: Doing Neat Things with Action Queries and Query Wizards.
Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.
Book IV: Forms.
Chapter 1: Designing and Using Forms (and Reports).
Chapter 2: Jazzing Up Your Forms (and Reports).
Chapter 3: Creating Smarter Forms.
Chapter 4: Doing Calculations in Forms (and Reports).
Book V: Reports.
Chapter 1: Creating and Spiffing Up Reports.
Chapter 2: Printing Beautiful Reports.
Chapter 3: Creating Charts and Graphs from Your Data.
Book VI: Macros: Automating Stuff in Access.
Chapter 1: Making Macros Do the Work.
Chapter 2: Making Macros Smarter.
Book VII: Database Administration.
Chapter 1: Database Housekeeping.
Chapter 2: Sharing the Fun -- and the Database: Managing Multiuser Access.
Chapter 3: Securing Your Access Database.
Book VIII: Programming in VBA.
Chapter 1: What the Heck Is VBA?
Chapter 2: Writing Code.
Chapter 3: Writing Smarter Code.
Chapter 4: Controlling Forms with VBA.
Chapter 5: Using SQL and Recordsets.
Chapter 6: Debugging Your Code.
Appendix: Installing Microsoft Access.
Index.
Book I: Essential Concepts.
Chapter 1: Introducing Access 2007.
Chapter 2: Getting Started, Getting Around.
Chapter 3: Creating a Database from Templates.
Chapter 4: Designing Your Database the Relational Way.
Book II: Tables.
Chapter 1: Creating and Modifying Tables.
Chapter 2: Entering and Editing Data in Datasheets.
Chapter 3: Sorting, Finding, and Filtering Data.
Chapter 4: Importing and Exporting Data.
Chapter 5: Avoiding "Garbage In, Garbage Out".
Chapter 6: Relating Your Tables and Protecting Your Data.
Book III: Queries.
Chapter 1: Creating Select Queries.
Chapter 2: Letting Queries Do the Math.
Chapter 3: Doing Neat Things with Action Queries and Query Wizards.
Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.
Book IV: Forms.
Chapter 1: Designing and Using Forms (and Reports).
Chapter 2: Jazzing Up Your Forms (and Reports).
Chapter 3: Creating Smarter Forms.
Chapter 4: Doing Calculations in Forms (and Reports).
Book V: Reports.
Chapter 1: Creating and Spiffing Up Reports.
Chapter 2: Printing Beautiful Reports.
Chapter 3: Creating Charts and Graphs from Your Data.
Book VI: Macros: Automating Stuff in Access.
Chapter 1: Making Macros Do the Work.
Chapter 2: Making Macros Smarter.
Book VII: Database Administration.
Chapter 1: Database Housekeeping.
Chapter 2: Sharing the Fun -- and the Database: Managing Multiuser Access.
Chapter 3: Securing Your Access Database.
Book VIII: Programming in VBA.
Chapter 1: What the Heck Is VBA?
Chapter 2: Writing Code.
Chapter 3: Writing Smarter Code.
Chapter 4: Controlling Forms with VBA.
Chapter 5: Using SQL and Recordsets.
Chapter 6: Debugging Your Code.
Appendix: Installing Microsoft Access.
Index.