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

Type: Course
Audience(s):information workers
Technology:Access
Level:100
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:1 day
Language(s):English

First published:

03 June 2011
Overview
About this course
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.
At course completion
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 details
Course OutlineModule 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 InformationLab : Exporting InformationLab : Copying to and from Other Office Programs
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 FormsLab : Creating Custom CategoriesLab : Controlling Which Features Are Available
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 DatabasesLab : Splitting DatabasesLab : Securing Databases for DistributionLab : Preventing Database 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 OptionsLab : Customizing the RibbonLab : Customizing the Quick Access Toolbar
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.
Prerequisites
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
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks: