
Access 2013: The Missing Manual
By Matthew MacDonaldMissing CD-ROM
Download all of the files for this book: Access2013TMM_missingCD.zip.
Note from the Author:
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.
There are no examples for chapters 19-23, because these chapters deal with ways to take your existing databases and deploy them or convert them (for example, on a network, in a SQL Server database, on the Web, and so on). You can use the databases from earlier chapters to try out these features. The files in the Chapter05 directory provide a good starting point, because they include simple databases with table relationships but no reports, forms, or code.
Missing Credits
Introduction
- Retired Access Features (page 13) - See a full list of features removed in Access 2013
- Microsoft Office (page 14) - Learn more about Office 365
- Registration (page 18) - Register your book
- Feedback (page 19) - Let us know how you like the book
- Errata Submit any errors you find
- Safari Books Online Read books online
Chapter 1: Creating Your First Database
- Access2013TMM_CH01.zip - Example file for Chapter 1
- SkyDrive (page 46) - Learn about Microsoft’s SkyDrive Cloud storage
Chapter 2: Building Smarter Tables
- Access2013TMM_CH02.zip - Example files for Chapter 2
- Longest Word in English (page 67) - Wikipedia article about the longest words in the English language
Chapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and More
- Access2013TMM_CH03.zip - Example files for Chapter 3
Chapter 4: Blocking Bad Data
- Access2013TMM_CH04.zip - Example files for Chapter 4
Chapter 5: Linking Tables with Relationships
- Access2013TMM_CH05.zip - Example files for Chapter 5
Chapter 6: Queries That Select Records
- Access2013TMM_CH06.zip - Example files for Chapter 6
Chapter 7: Essential Query Tricks
- Access2013TMM_CH07.zip - Example file for Chapter 7
- Tech on the Net (page 246) - Access Functions Resource
Chapter 8: Queries That Summarize Data
- Access2013TMM_CH08.zip - Example files for Chapter 8
Chapter 9: Queries That Change Tables
- Access2013TMM_CH09.zip - Example files for Chapter 9
Chapter 10: Creating Reports
- Access2013TMM_CH10.zip - Example files for Chapter 10
- Adobe Reader (page 324) - Download free Adobe Reader software
Chapter 11: Designing Advanced Reports
- Access2013TMM_CH11.zip - Example files for Chapter 11
Chapter 12: Creating Simple Forms
- Access2013TMM_CH12.zip - Example files for Chapter 12
Chapter 13: Designing Advanced Forms
- Access2013TMM_CH13.zip - Example files for Chapter 13
Chapter 14: Building a Navigation System
- Access2013TMM_CH14.zip - Example files for Chapter 14
Chapter 15: Automating Tasks with Macros
- Access2013TMM_CH15.zip - Example files for Chapter 15
- www.verisign.com (page 515) - Get a security certificate for your database
Chapter 16: Connecting Macros to Forms and Tables
- Access2013TMM_CH16.zip - Example files for Chapter 16
Chapter 17: Automating Tasks with Visual Basic
- Access2013TMM_CH17.zip - Example files for Chapter 17
- Visual Basic Reference (page 566) - Look up Visual Basic functions
- Visual Basic for Access (page 566, 580) - Visual Basic commands and techniques that work in Access
- Visual Basic Objects (page 580) - Full list of Visual Basic objects
Chapter 18: Writing Smarter Code
- Access2010TMM_CH18.zip - Example files for Chapter 18
- Visual Basic Data Types (page 593) - Full list of Visual Basic data types
- The Luhn Algorithm (page 602) - How the Luhn Algorithm works to validate numbers (such as credit card numbers)
- VBA for Word Developers (page 612) - Articles, references, and examples on programming Word with Visual Basic
- Visual Basic for Access (page 613) - Visual Basic commands and techniques that work in Access
Chapter 19: Sharing a Database on Your Network
- Microsoft Download Center (page 657) - Search for “access runtime” engine
Chapter 20: Building an Access Web App
- Microsoft’s Access Blog (page 677) - Read about Access Web Apps and other news
- Access Hosting (page 678) - Get online hosting for your Access 2013 database with SharePoint 2013
Chapter 21: Linking Access to SQL Server
- SQL Server System Requirements (page 734) - Learn how to install SQL Server 2012 on your computer
- SQL Server Express (page 735) - Download and install free SQL Server Express software
- Server Network Configuration (page 741) - Set up your SQL Server network
- SQL Server Migration Assistant for Access (SSMA) (page 758) - Migrating an Access Database to SQL Server
- Microsoft Corporation Log into or create a Microsoft account
- SSMA Documentation (page 762) - Articles on Migrating Access Databases to SQL Server
Chapter 22: Linking Access to SharePoint
- fpweb.net (page 764) - Get a SharePoint hosting plan
Chapter 23: Importing and Exporting Data
- Learning XML (page 811) - Learning XML by Erik Ray
- Learning XML at W3 Schools - XML tutorial
- W3 Schools (page 815) - XML and XML Schema tutorial