Duration: 1 Day
Delivery Method: Instructor-led (in-class & virtual)
Software Assurance Value:
This one-day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Access 2010.
After completing this course, students will be able to:
This course is intended for experienced information workers who want to learn advanced-level Access 2010 skills.
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.
Lab : Importing Information
Lab : Exporting Information
Lab : Copying to and from Other Office Programs
After completing this module, students will be able to:
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.
Lab : Creating Navigation Forms
Lab : Creating Custom Categories
Lab : 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.
Lab : Assigning Passwords to Databases
Lab : Splitting Databases
Lab : Securing Databases for Distribution
Lab : Preventing Database Problems
Module 4: Customize Access This module explains how to customize the program options to suit your work needs.
Lab : Changing Default Program Options
Lab : Customizing the Ribbon
Lab : Customizing the Quick Access Toolbar