Course Outline

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

Make Databases User Friendly

• Creating Navigation Forms
• Creating Custom Categories
• Controlling which Features Are Available

Protect Databases

• Assigning Passwords to Databases
• Splitting Databases
• Securing Databases for Distribution
• Preventing Database Problems

Customize Access

• Changing Default Program Options
• Customizing the Ribbon
• Customizing the Quick Access Toolbar