Alison Barrows, Margaret Levine Young, Joseph C. Stockman

Access 2010 All-In-One for Dummies

• Broschiertes Buch

Produktbeschreibung

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!

Produktdetails

• Verlag: Wiley & Sons
• 1. Auflage
• Seitenzahl: 792
• Erscheinungstermin: 3. Mai 2010
• Englisch
• Abmessung: 235mm x 191mm x 42mm
• Gewicht: 1174g
• ISBN-13: 9780470532188
• ISBN-10: 0470532181
• Artikelnr.: 28708045

Autorenporträt

Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference. Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies. Joseph C. Stockman is an independent consultant, software designer, and author.

Inhaltsangabe

Introduction. Book I: Essential Concepts. Chapter 1: Introducing Access
2010. Chapter 2: Getting Started, Getting Around. Chapter 3: Designing Your
Database the Relational Way. Book II: Tables for Storing Your Data. Chapter
1: Creating and Modifying Tables. Chapter 2: Refi ning Your Table in Design
View. Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet.
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 (or Getting Information from Your Data). 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
for Editing Data. 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 Subforms (and Reports).
Book V: Reporting in Words and Pictures. Chapter 1: Creating and Spiffi ng
Up Reports. Chapter 2: Printing Beautiful Reports. Chapter 3: Creating
Charts and Graphs from Your Data. Book VI: Automation with Macros. 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: 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. Book IX: Going Beyond Access. Chapter 1: Automation
with Other Offi ce Programs. Chapter 2: Using Access as a Front-End to SQL
Server. Chapter 3: Using Access with SharePoint. Appendix: Installing
Microsoft Access. Index.