00. Intro (5:01)
01. Why Split Your Database (5:07)
02. Customer Tables (10:53)
CustomerT
CustomerSecureT
One-To-One Relationship
Referential Integrity
Cascade Deletes
Cascade Updates
03. Customer Forms (11:36)
CustomerF
CustomerSecureF
Button to Open Secure Form
Without Security
VBA DoCmd.OpenForm
Add a Password
InputBox
Hide Navigation Pane
04. Splitting the Database (5:57)
Database Tools
Move Data > Access Database
Database Splitter
Copy and Rename Backend Files
05. Set up Shared Folders (14:21)
Windows Server
Sharing
Share This Folder
Share Permissions
Full Control
Users & Groups
File Sharing in Windows 7
Linked Table Manager
Refresh Links
06. Encrypted Front End (8:43)
ACCDE File
Distribution Copy
Save your ACCDB file!
07. Review (6:01)