Core Training for Microsoft Office Access 2007 (Exam 77-605): Online Course

Developed by Microsoft, this interactive course will help teach you the core skills and knowledge you will need to get the most out of Microsoft Office Access 2007. It is also recommended training for the exam 77-605: MCAS: Using Microsoft Office Access 2007. The course is split into six one-hour lessons covering various aspects of Access."Official Microsoft Online Learning" is ideal for the individual looking to improve their Microsoft skills. Written by Microsoft product experts, these interactive, modular courses allow you to work at your own pace and to practise using labs. With full assessments and completion tracking you will always know how you are progressing.

Table of Contents:
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; Customise the Rows and Columns of a Table; Types of Relationships in Access 2007 Database Tables; Self Test; Module Summary; 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; 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; 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; 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; 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; Glossary.