Module Title : Course 50534A: Learn Microsoft Office Access 2010 Step by Step, Level 3

Duration : 1 day

Part 3 Database Management and Security

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