
Access 2007: The Missing Manual
By Matthew MacDonaldMissing 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
- Download (372 kb)
Chapter 2
Longest word in English
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
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
- Download (344 kb)
Chapter 9
Screencast: Using Pivot Tables to View DataAdventureWorks.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
- Download (944 kb)
BoutiqueFudge.accdb
- Download (3.8 Mb)
Chapter 11
BoutiqueFudge.accdb
- Download (6.9 Mb)
CacophoneMusic.accdb
- Download (1.5 Mb)
Chapter 12
BoutiqueFudge.accdb
- Download (756 kb)
Chapter 13
BoutiqueFudge.accdb
- Download (688 kb)
Projects.accdb
- Download (316 kb)
Chapter 14
Screencast: Creating a Custom SwitchboardBoutiqueFudge.accdb
- Download (620 kb)
CacophoneMusic.accdb
- Download (1.9 Mb)
Chapter 15
VeriSign
AnimalBreeder.accdb
- Download (356 kb)
BoutiqueFudge.accdb
- Download (672 kb)
Chapter 16
BoutiqueFudge.accdb
- Download (660 kb)
Happy.jpg
- Download (2 kb)
Sad.jpg
- Download (2 kb)
Chapter 17
Luhn algorithm
VBA (Visual Basic for Applications) reference
Microsoft�s Office Developer Center
BoutiqueFudge.accdb
- Download (860 kb)
MyDocument.doc
- Download (20 kb)
MyHouse.accdb
- Download (508 kb)
Chapter 18
ASP.NET
Chapter 19
XML tutorial
DatingService.accdb
- Download (680 kb)
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