 |
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
|