Whoa! What happened to menu bars, toolbars, and all that other stuff I used to have? Well, in case you haven’t noticed yet, they’re all gone. Of course, if you never used Access before in your life, then you’re starting fresh, so never mind. Whether you never used any version of Microsoft Access, and aren’t even sure what a “version” is, you’ve come to the right book.
The basic idea behind Microsoft Access is to allow individuals and small businesses to manage large amounts of information the way the big corporations do — with relational databases. The difference is that while the big boys spend millions on computer hardware, software, and staffs of nerdy database-administrator types, Access allows you to do it all yourself with a run-of-the-mill PC and a realistic software budget.
Microsoft Access 2007 is the latest-and-greatest version of a long line of Access versions, starting (not surprisingly) with Version 1. Not that this is the 2,007th version. Somewhere along the way Microsoft switched from using sequential numbers for versions to using years — an idea first pioneered by the automotive industry, which sells things like “2007 Ford Mustangs” as opposed to “Mustang Version 9.3’s.”
Without going into boring detail about what’s new in Access 2007, you find the usual kind of stuff you find in new versions these days — more power, more flexibility, more things you can do with it. And of course — along the lines of the Holy Grail of Everything Computerish these days — more taking advantage of everything the Internet has to offer. But the most noticeable change for the Access-experienced is a whole new look and feel — along with some new ways of doing things.
Introduction .................................................................1
Book I: Essential Concepts.............................................7
Chapter 1: Introducing Access 2007.................................................................................9
Chapter 2: Getting Started, Getting Around..................................................................17
Chapter 3: Creating a Database from Templates..........................................................39
Chapter 4: Designing Your Database the Relational Way ............................................55
Book II: Tables ...........................................................81
Chapter 1: Creating and Modifying Tables ....................................................................83
Chapter 2: Entering and Editing Data in Datasheets..................................................111
Chapter 3: Sorting, Finding, and Filtering Data...........................................................137
Chapter 4: Importing and Exporting Data ...................................................................151
Chapter 5: Avoiding “Garbage In, Garbage Out”.........................................................175
Chapter 6: Relating Your Tables and Protecting Your Data .....................................191
Book III: Queries ......................................................201
Chapter 1: Creating Select Queries .............................................................................203
Chapter 2: Letting Queries Do the Math......................................................................233
Chapter 3: Doing Neat Things with Action Queries and Query Wizards.................269
Chapter 4: Viewing Your Data from All Angles
Using Crosstabs and PivotTables .............................................................................291
Book IV: Forms .........................................................313
Chapter 1: Designing and Using Forms (and Reports) ..............................................315
Chapter 2: Jazzing Up Your Forms (and Reports)......................................................335
Chapter 3: Creating Smarter Forms .............................................................................357
Chapter 4: Doing Calculations in Forms (and Reports) ............................................385
Book V: Reports........................................................399
Chapter 1: Creating and Spiffing Up Reports .............................................................401
Chapter 2: Printing Beautiful Reports..........................................................................435
Chapter 3: Creating Charts and Graphs from Your Data ...........................................445
Book VI: Macros: Automating Stuff in Access .............471
Chapter 1: Making Macros Do the Work......................................................................473
Chapter 2: Making Macros Smarter..............................................................................493
Book VII: Database Administration ............................509
Chapter 1: Database Housekeeping .............................................................................511
Chapter 2: Sharing the Fun — and the Database:
Managing Multiuser Access........................................................................................527
Chapter 3: Securing Your Access Database ................................................................543
Book VIII: Programming in VBA.................................569
Chapter 1: What the Heck Is VBA? ...............................................................................571
Chapter 2: Writing Code ................................................................................................591
Chapter 3: Writing Smarter Code .................................................................................615
Chapter 4: Controlling Forms with VBA ......................................................................641
Chapter 5: Using SQL and Recordsets .........................................................................665
Chapter 6: Debugging Your Code .................................................................................677
Appendix: Installing Microsoft Access ........................687
Index .......................................................................693
Thursday, April 07, 2011
Most Ebook
Posted in: 
