Access 2003  | Access 2007

Course 4100: Core Training for Microsoft® Office Access 2003 by Microsoft
Course Description

This course introduces the basic features and tools of Microsoft® Office Access 2003, including the following: getting to know Access, creating a new database, importing and exporting information, simplifying data entry with forms, locating specific information, keeping information accurate, working with reports, making it easy for others to use the database, and keeping information secured.
This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.

This course is 6.5 hours long.
System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.
Subscription: 1 year

Modules & Lessons
Core Training for Microsoft® Office Access 2003

Pre-Assessment
Pre-Assessment

Getting to Know Access
Lesson Introduction
Exploring Access and Database Objects
Exploring Queries
Exploring Forms and Reports

Creating a New Database
Lesson Introduction
Creating New Databases
Exploring a Database
Editing Data
Creating Tables the Simple Way
Exploring Tables in Design View
Exploring Tables in Datasheet View

Importing and Exporting Information
Lesson Introduction
Importing Information from a Spreadsheet
Importing Information from a Text File
Importing Information from a Database
Importing Information from HTML and XML Documents
Exporting Information to Other Programs
Sharing Information

Simplifying Data Entry with Forms
Lesson Introduction
Creating and Exploring Forms
Creating a Form Using AutoForm
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Adding a Subform to a Form

Locating Specific Information
Lesson Introduction
Sorting Information
Filtering Information in Tables and Forms
Using Complex Expressions
Creating Queries in Design View
Creating and Exploring Queries
Performing Calculations in a Query

Keeping Information Accurate
Lesson Introduction
Using Data Type Settings to Restrict Data
Using Input Masks to Restrict Data
Using Validation Rules to Restrict Data
Using Lookup Lists to Restrict Data
Updating Information in a Table
Deleting Information from a Table

Working with Reports
Lesson Introduction
Creating and Exploring Reports
Modifying a Report
Creating and Modifying a Report in Design View
Adding Calculated Controls to Reports

Making It Easy for Others to Use the Database
Lesson Introduction
Creating a Switchboard

Collection 5263: Core Training for Microsoft Office Access 2007 by Microsoft

Course Description

This collection of online courses covers the core skills and knowledge you will need to get the most out of Microsoft® Office Access 2007. It is also ideal training for the exam 77-605: MOS: Using Microsoft Office Access 2007.

This collection of courses is 6 hours long.

This collection contains the following:
Course 5451: Getting Started with Microsoft Office Access 2007
Course 5452: Importing and Exporting Information in Microsoft Office Access 2007
Course 5453: Working with Forms in Microsoft Office Access 2007
Course 5454: Locating Specific Information in Microsoft Office Access 2007
Course 5455: Keeping Information Accurate and Secure in Microsoft Office Access 2007
Course 5456: Working with Reports in Microsoft Office Access 2007

System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

Subscription: 1 year

You will need Access 2007 installed on your machine to use some of the local labs in this course.

Course 5451: Getting Started with Microsoft Office Access 2007

Exploring the Access 2007 Environment
Lesson Introduction
Elements of the Access 2007 User Interface
Explore the Tabs and Groups on the Ribbon
Lab: Making Frequently Used Access 2007 Commands Easily Available
Concepts of a Database
Open a Database
Self Test

Exploring the Access 2007 Object Types
Lesson Introduction
Explore Tables
Lab: Exploring Queries
Explore Forms
Overview of Reports
What Are Macros and Modules?
Lab: Previewing and Printing Access 2007 Objects
Self Test

Creating Databases and Tables
Lesson Introduction
Create a Database from a Template
Lab: Creating a Table Manually
Lab: Creating a Table by Using a Template
Customize the Rows and Columns of a Table
Types of Relationships in Access 2007 Database Tables
Self Test
Module Summary

Glossary

Course 5452: Importing and Exporting Information in Microsoft Office Access 2007

Importing Information from Office Applications
Lesson Introduction
Import Information from Another Access 2007 Database
Lab: Importing Information from an Excel Worksheet
Collect Data by Using E-Mail
Import Information from an Outlook Folder
Advantages of Linking to Information
Import from or Link to a SharePoint List
Self Test

Importing Information from Other Sources
Lesson Introduction
Import Information from a Text File
Import Information from an XML File
Lab: Importing Information from an HTML File
Import Information from a dBASE File
Self Test

Exporting Information
Lesson Introduction
Valid Export Formats for the Access 2007 Database Objects
Lab: Exporting Information to Another Access 2007 Database
Export Information to Other Office Applications
Export Information to a SharePoint List
Export Information to Other Files
Lab: Copying Information to Other Office Programs
Self Test
Module Summary

Glossary

Course 5453: Working with Forms in Microsoft Office Access 2007

Creating Forms
Lesson Introduction
Create a Form by Using the Form Tool
Lab: Creating a Form by Using the Form Wizard
Create a Form and its Subform Simultaneously
Lab: Adding a Subform to a Form
Self Test

Modifying Forms
Lesson Introduction
Lab: Editing the Properties of a Form
Modify the Arrangement of a Form
Lab: Modifying Controls Added to a Form
Lab: Specifying Data in a Form by Using VBA
Self Test

Controlling Features of Access 2007 Databases
Lesson Introduction
Concepts of Switchboard and Switchboard Manager
Lab: Creating a Switchboard by Using Switchboard Manager
Create a Custom Category
Lab: Setting Startup Options for Access 2007 Database Users
Self Test
Module Summary

Glossary

Course 5454: Locating Specific Information in Microsoft Office Access 2007

Sorting and Filtering Information
Lesson Introduction
How Access 2007 Sorts Information
Lab: Sorting Information in a Table
Types of Filters for Search Criteria
Lab: Filtering Information in a Table
Filter Information by Using the Filter By Form Command
Locate Information That Matches Multiple Criteria
Self Test

Creating and Using Queries
Lesson Introduction
Types of Queries
Create a Query Manually
Lab: Creating a Query by Using the Query Wizard
Aggregate Functions Supported by Access 2007 Queries
Lab: Performing Calculations by Using a Query
Self Test
Module Summary

Glossary

Course 5455: Keeping Information Accurate and Secure in Microsoft Office Access 2007

Restricting Data in a Field
Lesson Introduction
Lab: Restricting the Type of Data
Restrict the Amount of Data
What Are Input Mask Characters?
Lab: Specifying the Format of Data
Lab: Restricting Data by Using Validation Rules
Self Test

Updating Information in a Database
Lesson Introduction
Create a Simple Lookup List
Lab: Creating a Multicolumn Lookup List
Lab: Updating Information in a Table by Using an Update Query
Delete Information from a Table by Using a Delete Query
Utilities Available in Access 2007 to Run a Database Smoothly
Self Test

Keeping Information Secure
Lesson Introduction
Assign a Password to a Database
Lab: Securing the VBA Code in a Database
Secure a Database for Distribution
Data Collection and Distribution Through a SharePoint Site
Self Test
Module Summary

Glossary

Course 5456: Working with Reports in Microsoft Office Access 2007

Creating and Printing Reports
Lesson Introduction
Forms vs. Reports
Lab: Creating a Report by Using the Report Wizard
Lab: Creating a Report Manually
Add a Subreport to a Report
Preview and Print a Report
Self Test

Modifying Reports
Lesson Introduction
Lab: Modifying the Design of a Report
Lab: Modifying the Content of a Report
Self Test
Module Summary

Course Length: 6 hours