Optimizing, Securing, and Sharing Access 2010 Databases

Overview/Description
Access 2010 provides a variety of tools to assist you in optimizing, securing, and sharing a database application. This course demonstrates how to assess a database's performance and improve its efficiency. Also covered are the ways that you can secure a database for users and the common methods employed to share a completed database application.

Target Audience
A broad range of business users

Expected Duration (hours)
1.0

Lesson Objectives

Optimizing, Securing, and Sharing Access 2010 Databases

use the Performance Analyzer to assess and improve database performance

use the Object Dependencies pane

use the Database Documenter to create a report on database objects

use the Table Analyzer Wizard to analyze and organize new data

describe how the Access 2010 security architecture works

manage signed packages

split a database

create a package solution for installing a database application on a client computer

specify an appropriate method of sharing an Access database

optimize the performance of an Access database

secure an Access database