Part 3 Database Management and Security
Learn Microsoft Access 2010 Step by Step, Level 3
Import and Export Data
Importing Information
Importing from Other Access Databases
Importing from Excel Worksheets
Importing from Text Files
Importing from Other Database Programs
Importing from Outlook Folders
Importing from SharePoint Lists
Importing from HTML Files
Importing from XML Files
Sidebar: Linking to Information
Exporting Information
Exporting to Other Access Databases
Exporting to Excel Worksheets
Exporting to Word Documents
Exporting to Text Files
Exporting to PDF and XPS Files
Exporting to SharePoint Lists
Exporting to HTML Files
Exporting to XML Files
Copying to and from Other Office Programs
Key Points
Make Databases User Friendly
Creating Navigation Forms
Creating Custom Categories
Controlling Which Features Are Available
Key Points
Protect Databases
Assigning Passwords to Databases
Splitting Databases
Securing Databases for Distribution
Sidebar: Packaging and Signing Databases
Preventing Database Problems
Key Points
Customize Access
Changing Default Program Options
Sidebar: Using Add-Ins
Customizing the Ribbon
Customizing the Quick Access Toolbar
Key Points
Programme scope, delivery arrangements and suitability are confirmed during enquiry.