Learn Microsoft Access 2010 Step by Step, Level 3 (50534A)

This one-day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Access 2010.

Audience Profile
This course is intended for experienced information workers who want to learn advanced-level Access 2010 skills.

Before attending this course, students must have:
  • Basic computer knowledge
  • Basic file-management skills
  • Basic knowledge of the Access 2010 interface and database, table, and form creation and manipulation
After completing this course, students will be able to:
  • Import information.
  • Export information.
  • Copy to and from other Office programs.
  • Create navigation forms.
  • Create custom categories.
  • Control which features are available.
  • Assign passwords to databases
  • Split databases.
  • Secure databases for distribution.
  • Prevent database problems.
  • Change default program options.
  • Customize the ribbon.
  • Customize the Quick Access Toolbar.
Show details
Course Outline

Module 1: Import and Export Data

This module explains how to populate the tables of a database by importing existing information from other sources and how to use information that exists in an Access database in other programs.
  • Importing Information
  • Exporting Information
  • Copying to and from Other Office Programs
Module 2: Make Databases User Friendly
This module explains how to make databases easier to access and manipulate, and more difficult to unintentionally change or delete.
  • Creating Navigation Forms
  • Creating Custom Categories
  • Controlling Which Features Are Available
Module 3: Protect Databases
This module explains how to ensure that a database’s data is secure and that its data is available and useable.
  • Assigning Passwords to Databases
  • Splitting Databases
  • Securing Databases for Distribution
  • Preventing Database Problems
Module 4: Customize Access
This module explains how to customize the program options to suit your work needs.
  • Changing Default Program Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar