Simpson / Young / Barrows Microsoft Office Access 2007 All-in-One Desk Reference For Dummies

1. Auflage 2011
ISBN: 978-1-118-05052-1
Verlag: John Wiley & Sons
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 768 Seiten, E-Book

* Updated to cover all the latest features and capabilities ofAccess 2007, this resource provides new and inexperienced Accessusers with eight task-oriented minibooks that cover begininning toadvanced-level material

* Each minibook covers a specific aspect of Access, such asdatabase design, tables, queries, forms, reports, and macros

* Shows how to accomplish specific tasks such as databasehousekeeping, security data, and using Access with the Web

* Access is the world's leading desktop database solution and isused by millions of people to store, organize, view, analyze, andshare data, as well as to build powerful, custom database solutionsthat integrate with the Web and enterprise data sources

Autoren/Hrsg.

Simpson, Alan

Young, Margaret Levine

Barrows, Alison

Wells, April

McCarter, Jim

Inhaltsverzeichnis

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 QueryWizards.
Chapter 4: Viewing Your Data from All Angles Using Crosstabs andPivotTables.
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: ManagingMultiuser 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.

Über Autor(innen)

Alan Simpson is the author of over 115 computer books on allsorts of topics: Windows, databases, Web-site design anddevelopment, programming, and network administration. His books arepublished throughout the world, in over a dozen languages, and havesold millions of copies. Though definitely in the techno-geekcategory, we let him contribute anyway because sometimes peoplelike that come in handy.
Margaret Levine Young has co-authored several dozencomputer books about the Internet, UNIX, WordPerfect, Access, and(stab from the past) PC-File and Javelin, including The InternetFor Dummies (Wiley) and Windows XP Home Edition: TheComplete Reference (Osborne/McGraw-Hill). She met her futurehusband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computerclub before there were high-school computer clubs. Her otherpassions are her children, music, Unitarian Universalism(www.uua.org), reading, and anything to do with cooking oreating.
Alison Barrows has authored or co-authored books onWindows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3,and other topics. In addition to writing books, Alison writes andedits technical documentation and training material. In real lifeshe hangs out with her "guys" -- Parker, 6, andMason, 4, and Evan 2 -- and tries to carve out some time topractice yoga. Alison lives with her family in centralMassachusetts.
April Wells is a graduate of the University of Pittsburghand holds an MBA from West Texas A&M. She is a databaseadministrator with expertise in a wide variety of enterprisedatabase software programs, including Oracle, DB2, MySQL, andAccess. She is the author of several books and white papers ondatabase software and is a frequent public speaker, trainer, andconsultant.