Skip Ribbon Commands
Skip to main content

MS-50534 - Learn Microsoft Access 2010 Step by Step, Level 3

Price:

Duration: 1 Day

Audience:

Level:

Technology:

Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

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

Course Objectives

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.

Course Audience

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

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. 

Lessons 

  • Importing Information
  • Exporting Information
  • Copying to and from Other Office Programs

Lab : Importing Information

  • Import data from a database, a text file, and an Excel worksheet

Lab : Exporting Information

  • Export a table in various formats

Lab : Copying to and from Other Office Programs

  • Copy data between Access, Excel, and Word

After completing this module, students will be able to: 

  • Avoid having to rekey data that exists in other file formats by importing the data into Access.
  • Avoid having to rekey data that exists in an Access database by exporting the data for use in other 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. 

Lessons 

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

Lab : Creating Navigation Forms

  • Create a two-level navigation form

Lab : Creating Custom Categories

  • Create a custom category

Lab : Controlling Which Features Are Available

  • Set and bypass startup options

After completing this module, students will be able to: 

  • Create a navigation form that users can click to display and work with forms and reports.
  • Provide users with easy access to the objects they need to work with.
  • Use startup options to display or hide features.

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. 

Lessons 

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

Lab : Assigning Passwords to Databases

  • Protect a data-base with a password

Lab : Splitting Databases

  • Split a database

Lab : Securing Databases for Distribution

  • Save a database as an ACCDE file

Lab : Preventing Database Problems

  • Back up a database, and run utilities to detect problems

After completing this module, students will be able to: 

  • Password-protect a database.
  • Organize a database into back-end and front-end components to speed up its performance over a network.
  • Create a secure database file so that users can view and update data but not change base objects.
  • Back up the database.
  • Run Access utilities to optimize the database’s performance.

Module 4: Customize Access 
This module explains how to customize the program options to suit your work needs. 

Lessons 

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

Lab : Changing Default Program Options

  • Explore the Access Options dialog box

Lab : Customizing the Ribbon

  • Experiment with ribbon customizations, including custom groups and tabs

Lab : Customizing the Quick Access Toolbar

  • Add buttons to the Quick Access Toolbar, and then test them

After completing this module, students will be able to: 

  • Customize the program options to suit their working style.
  • Turn off a tab and customize groups on the tab.
  • Make new commands available on the Quick Access Toolbar.

Course Prerequisites

Course Schedule
Course IDCourse DateTimeAvailabilityRequest