Learn Microsoft Access 2010 Step by Step, Level 3 (50534)

Module 1: Import and Export DataThis 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 FriendlyThis 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 DatabasesThis 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 AccessThis 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

Have Questions? For advice about training and certification, connect with peers:

• Visit the training and certification forum

For questions about a specific certification, chat with a Microsoft Certified Professional (MCP):

• Visit our MCP newsgroups

To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:

• Visit the Microsoft Learning community

div.Tabs-wrapper .tabs-hide { display: block; }