Learn Microsoft Access 2010 Step by Step, Level 3

Code: 50534
Course duration: 1 days
Price:

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

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.

Course Outline

Module 1: Import and Export Data

  • 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.

    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.
    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

E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.

Course Reviews

No reviews found for this course.

Be the first to write a review