Errata

View Errata for this book

Submit your own Errata
Access 2007: The Missing Manual

Access 2007: The Missing Manual

By Matthew MacDonald

Missing CD-ROM

Sample Files

  • Download all sample files--except the large AdventureWorks database, which you can download separately here (4.7 Mb)--in a zip file (7.3 Mb) or download individual files here.

    Notes

    General note:
    When you first open some of the more complex databases in later chapters, you might not see all the database objects in the navigation pane at first. Some groups might be collapsed to draw your attention to specific objects that are important for the given example. Read Chapter 14 for complete information about how the navigation pane works, and how to show or hide just what you want.

    Note for Marketing.accdb database (Chapter 8)
    Before running the TransferNames query in the Marketing.accdb database, open the query in design view (right-click it and choose Design) and click the Query Tools | Design --> Query Type --> Append button. Click the Browse button, and browse to (and select) the Sales.accdb database, wherever you've placed it on your computer.

    Note for AdventureWorks.accdb database (Chapter 9)
    Using the AdventureWorks.accdb database, open the OrderedItems query and Switch to PivotTable View to see the pivot table.

Chapter 1

Access Developer's Toolkit

Task Scheduler Tutorial

Bobblehead.accdb

Chapter 2

Longest word in English

AnimalBreeder.accdb

Bobblehead (BadDataTypes).accdb

Bobblehead.accdb

Contacts.accdb

FictionalCharacters.accdb

Chapter 3

Bobblehead.accdb

DatingService.accdb

PastaShop.accdb

Chapter 4

Bobblehead.accdb

DatingService.accdb

DatingServiceLookup.accdb

DatingServiceLookupWithTable.accdb

Chapter 5

Bobblehead.accdb

BobbleheadRelationships.accdb

BobbleheadRelationships_MultiValue.accdb

BoutiqueFudge.accdb

CacophoneMusic.accdb

Chapter 6

BoutiqueFudge.accdb

CacophoneMusic.accdb

Chapter 7

Access functions

BoutiqueFudge.accdb

Chapter 8

BoutiqueFudge.accdb

Marketing.accdb

  • Download (392 kb)
    Note: Before running the TransferNames query in the Marketing.accdb database, open the query in design view (right-click it and choose Design) and click the Query Tools | Design --> Query Type --> Append button. Click the Browse button, and browse to (and select) the Sales.accdb database, wherever you've placed it on your computer.

Sales.accdb

Chapter 9

Screencast: Using Pivot Tables to View Data

AdventureWorks.zip

  • Download (4.7 Mb)
    Note: Using the AdventureWorks.accdb database, open the OrderedItems query and Switch to PivotTable View to see the pivot table.

Chapter 10

Snapshot Viewer

Adobe Reader

Save As PDF Add-in

Bobblehead.accdb

BoutiqueFudge.accdb

Chapter 11

BoutiqueFudge.accdb

CacophoneMusic.accdb

Chapter 12

BoutiqueFudge.accdb

Chapter 13

BoutiqueFudge.accdb

Projects.accdb

Chapter 14

Screencast: Creating a Custom Switchboard

BoutiqueFudge.accdb

CacophoneMusic.accdb

Chapter 15

VeriSign

AnimalBreeder.accdb

BoutiqueFudge.accdb

Chapter 16

BoutiqueFudge.accdb

Happy.jpg

Sad.jpg

Chapter 17

Luhn algorithm

VBA (Visual Basic for Applications) reference

Microsoft�s Office Developer Center

BoutiqueFudge.accdb

MyDocument.doc

MyHouse.accdb

Chapter 18

ASP.NET

Chapter 19

XML tutorial

DatingService.accdb

Chapter 20

System requirements for SQL Server

.NET Framework 2.0

SQL Server Express

Knowledge Base

Chapter 21

SharePoint Services

SharePoint 30-day free trial

Appendix A

Customizing the ribbon