Access 2007: The Missing Manual Missing CD

Errata

View Errata for this book

Submit your own Errata

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

Website

Task Scheduler Tutorial

Website

Bobblehead.accdb

Download (372 kb)

Chapter 2

Longest word in English

Website

AnimalBreeder.accdb

Download (716 kb)

Bobblehead (BadDataTypes).accdb

Download (556 kb)

Bobblehead.accdb

Download (868 kb)

Contacts.accdb

Download (964 kb)

FictionalCharacters.accdb

Download (312 kb)

Chapter 3

Bobblehead.accdb

Download (556 kb)

DatingService.accdb

Download (672 kb)

PastaShop.accdb

Download (512 kb)

Chapter 4

Bobblehead.accdb

Download (556 kb)

DatingService.accdb

Download (672 kb)

DatingServiceLookup.accdb

Download (704 kb)

DatingServiceLookupWithTable.accdb

Download (672 kb)

Chapter 5

Bobblehead.accdb

Download (764 kb)

BobbleheadRelationships.accdb

Download (764 kb)

BobbleheadRelationships_MultiValue.accdb

Download (764 kb)

BoutiqueFudge.accdb

Download (3.8 Mb)

CacophoneMusic.accdb

Download (1.5 Mb)

Chapter 6

BoutiqueFudge.accdb

Download (3.8 Mb)

CacophoneMusic.accdb

Download (1.5 Mb)

Chapter 7

Access functions

Website

BoutiqueFudge.accdb

Download (3.8 Mb)

Chapter 8

BoutiqueFudge.accdb

Download (3.8 Mb)

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