Microsoft Office Access 2007 All-in-One Desk Reference

Name: Microsoft Office Access 2007 All-in-One Desk Reference
Price: 3.61 USD
Availability: InStock
ISBN: 9780470036495

ISBN-10: 0470036494

ISBN-13: 9780470036495

Edition: 2006

Authors: Alan Simpson, Alison Barrows, April Wells, Margaret Levine Young, Jim McCarter

List price: $29.99

30 day, 100% satisfaction guarantee!

Marketplace

4 new & used from $3.61

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Access "X" All-in-One Desk Reference For Dummies is being updated to cover all the latest features and capabilities of Access "X" which is due out in Fall 2006. This title provides new and inexperienced Access users and beginning programmers with nine task-oriented minibooks that cover beginning to advanced-level material. It can be read from cover to cover or can be used as a reference for learning how to accomplish specific tasks. Each minibook is designed to cover a specific aspect of Access. Book 1introduces Access and database design. Books 2 through 6 cover tables, queries, forms, reports, and macros. Book 7 covers database administration, including database housekeeping and securing…

Book details

List price: $29.99
Copyright year: 2006
Publisher: John Wiley & Sons, Incorporated
Publication date: 12/26/2006
Binding: Paperback
Pages: 768
Size: 7.25" wide x 9.00" long x 1.50" tall
Weight: 2.486



Introduction



Essential Concepts



Introducing Access 2007.



Getting Started, Getting Around.



Creating a Database from Templates.



Designing Your Database the Relational Way.



Tables.



Creating and Modifying Tables.



Entering and Editing Data in Datasheets.



Sorting, Finding, and Filtering Data.



Importing and Exporting Data.



Avoiding "Garbage In, Garbage Out".



Relating Your Tables and Protecting Your Data.



Queries.



Creating Select Queries.



Letting Queries Do the Math.



Doing Neat Things with Action Queries and Query Wizards.



Viewing Your Data from All Angles Using Crosstabs and PivotTables.



Forms.



Designing and Using Forms (and Reports).



Jazzing Up Your Forms (and Reports).



Creating Smarter Forms.



Doing Calculations in Forms (and Reports).



Reports.



Creating and Spiffing Up Reports.



Printing Beautiful Reports.



Creating Charts and Graphs from Your Data.



Macros: Automating Stuff in Access.



Making Macros Do the Work.



Making Macros Smarter.



Database Administration.



Database Housekeeping.



Sharing the Fun - and the Database: Managing Multiuser Access.



Securing Your Access Database.



Programming in VBA.



What the Heck Is VBA?



Writing Code.



Writing Smarter Code.



Controlling Forms with VBA.



Using SQL and Recordsets.



Debugging Your Code



Installing Microsoft Access


Index