Session I - Navigating the Updated Interface

Time - 2 hours

Description

This course provides information about the new user interface designed for the Microsoft Office 2007 applications.

Objectives

  • This course provides information about the new user interface designed for the Microsoft Office 2007 applications.
  • List and describe the features of the new Office 2007 user interface
  • Change application settings in Office 2007 products
  • Use the Live Preview feature

Topics

  • Why the Big Change?
  • The Ribbon: Command Tabs and Contextual Tabs
  • The Ribbon: The Office Menu
  • Galleries and Live Preview
  • Other New Interface Features

Session II - Common Features in Office 2010

Time - 3 hours

Description

This course explores the new features that the major Office 2010 applications have in common.

Objectives

  • This course explores the new features that the major Office 2010 applications have in common.
  • Modify and minimize the Ribbon
  • Use Backstage view
  • Capture windows and clippings
  • Add artistic and color effects to images
  • Save documents to the Web
  • Work with Office Web Apps

Topics

  • Modifying the Ribbon
  • Working with Backstage View
  • Capturing Windows and Clippings
  • Removing Image Backgrounds
  • Adding Artistic and Color Effects
  • Checking Document Accessibility
  • Saving Documents to the Web
  • Working with SkyDrive
  • Using Office Web Apps

Session III - What's New in Access 2007

Time - 2 hours

Description

This course provides an overview of the new features in Microsoft Office Access 2007.

Objectives

  • This course provides an overview of the new features in Microsoft Office Access 2007.
  • Navigate Access using the Ribbon, the Office Menu, and the Navigation Pane
  • Create a database
  • Create new forms
  • Filter the data in a table
  • Generate reports from a table
  • Migrate database objects to SQL Server and Windows SharePoint Services

Topics

  • The New Look
  • Creating a Database
  • Importing Data
  • Filtering Data
  • Creating Reports
  • Upsizing and Moving Data

Session IV - What's New in Access 2010

Time - 3 hour

Description

This course explores the new features in Microsoft Access 2010.

Objectives

  • This course explores the new features in Microsoft Access 2010.
  • Describe the new Ribbon features
  • Visualize trends with data bars
  • Create application parts and data type parts
  • Use calculated fields
  • Build data macros
  • Insert Web content and create Web databases

Topics

  • Reviewing the Ribbon Tabs in Access
  • Visualizing Trends with Data Bars
  • Building Application Parts
  • Creating Data Type Parts
  • Using Calculated Fields
  • Building Data Macros
  • Inserting Dynamic Web Content
  • Creating Web Databases

Access 2007 Training Series: Course Details

Total time - 9 hours

Session I - Introduction to Access

Time - 1 hour

Description

This course provides information on the Access 2007 interface, creating a database using templates, and the available database views.

Objectives

  • Use the Ribbon to access command buttons and groups
  • Use the Office menu to access commands dealing with the whole application or database
  • Use the Navigation Pane to view and open database objects
  • Start a new database by using templates provided by Microsoft Office Online

Topics

  • The interface
  • Creating a database
  • Views

Session II - Creating Tables

Time - 2 hours

Description

This course provides details about creating tables in Access 2007, as well as how to add and delete records and tables from a database. It also covers basic database terminology, data types, primary keys, flat files, and relational databases.

Objectives

  • Recognize data types and basic database terminology
  • Add and delete fields from a table
  • Set the primary key for a table
  • Identify flat files and relational databases
  • Create simple tables
  • Add, modify, and delete records from a table

Topics

  • Database terminology
  • Data types
  • Adding and deleting fields
  • Primary keys
  • Flat files and relational databases
  • Creating tables
  • Adding, modifying, and deleting records

Session III - Working with Tables

Time - 2 hours

Description

This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships.

Objectives

  • Apply basic formatting to a database table
  • Create input masks for table fields
  • Create validation rules for table fields
  • View and modify the relationships between tables

Topics

  • Formatting
  • Input masks
  • Validating data
  • Table relationships

Session IV - Creating Forms

Time - 2 hour

Description

This course provides information on creating forms in Access 2007, including simple forms, more complex multiple items forms, and split forms. It also shows how to create customized forms using the Form Wizard.

Objectives

  • Create simple forms using the Form button
  • Create split and multiple items forms
  • Use the Form Wizard to create customized forms
  • Edit and customize a form using Form Design view

Topics

  • Creating and Modifying Simple Forms
  • Creating Complex Forms
  • Using the Form Wizard
  • Form Design

Session V - Creating Reports

Time - 1 hour

Description

This course provides information on creating reports using Access 2007.

Objectives

  • Create a basic report
  • Create a report using the Report Wizard
  • Create a customized report

Topics

  • Creating Basic Reports
  • Using the Report Wizard
  • Report Design

Session VI - Creating Queries and Filters

Time - 1 hour

Description

This course provides information on how to use queries and filters to search and sort your database tables. It shows how to filter using the Sort and Filter feature and how to build queries using the Query Wizard.

Objectives

  • Explain the difference between a query and a filter
  • Apply sorts and filters to your tables
  • Build a query using the Query Wizard
  • Add query criteria to narrow the focus of your queries

Topics

  • Defining queries and filters
  • Sorting and filtering
  • Simple queries
  • Using query criteria

Access 2003 Training Series: Course Details

Total time - 22 hours

Session I - Introduction to Access

Time - 2 hour

Description

This course provides an overview of the Access 2003 Interface, toolbars and menus. It also covers how to open, close, save, backup, and request help.

Objectives

  • Start Access
  • Open an existing database
  • Modify reporting results
  • Save, close and back up a database
  • Use the toolbar and menus
  • Use Access help

Topics

  • Opening an existing database
  • Using the database window
  • Modifying and reporting results
  • Saving, closing and backing up the database
  • Understanding the interface
  • Using the toolbar and menus
  • Accessing help

Session II - Designing and Building Tables

Time - 3 hours

Description

This course shows learners how to use Access 2003 to design and build tables and an index. It also covers working with fields, primary keys, and records.

Objectives

  • Build a simple database
  • Create and open a table
  • Set up a primary key
  • Build relationships between tables
  • Create an index
  • Add, modify and delete records

Topics

  • Understanding database terminology
  • Working with fields
  • Differentiating flat files and relational databases
  • Building a database
  • Creating tables
  • Organizing with a primary key
  • Building table relationships
  • Creating an index
  • Opening databases and tables
  • Adding, modifying, and deleting records

Session III - Enhanced Tables and Datasheets

Time - 3 hours

Description

This course shows learners how to use Access 2003 to format tables and use masks and validations. It also covers working with columns and rows, changing fonts, using table fields and field names.

Objectives

  • Format a table
  • Use masks and validations
  • Work with columns and rows
  • Change fonts on the datasheet
  • Add and remove table fields
  • Change field names

Topics

  • Formatting tables
  • Using input masks
  • Creating validations
  • Navigating the datasheet
  • Modifying columns and rows
  • Organizing columns and rows
  • Changing fonts and the look of the datasheet
  • Adding and removing table fields
  • Changing field names

Session IV - Searches and Queries

Time - 3 hours

Description

This course shows learners how to use Access 2003 to build simple, select and multiple-table queries using wizards or by hand. It also covers filtering records.

Objectives

  • Sort and filter records in a database
  • Build a simple query
  • Use the select query and select query wizard
  • Set up multiple-table queriesa
  • Build a multiple-table query by hand

Topics

  • Using the find command
  • Sorting the database
  • Filtering records
  • Defining queries
  • Building a simple query
  • Using the select query
  • Using the simple query wizard
  • Setting up multiple-table queries
  • Using the wizard for multiple-table queries
  • Building a multiple-table query by hand

Session V - Advanced Queries and Calculations

Time - 3 hours

Description

This course shows learners how to use Access 2003 to construct calculations and use Boolean operators (AND/OR) to build advanced queries. It also covers how to use the Total Row and Expression Builder, and to modify data.

Objectives

  • Use Boolean operators in queries
  • Create advanced queries and calculations
  • Replace, delete, and update data

Topics

  • Using the AND operator
  • Using the OR operator
  • Defining the total row
  • Using total row options
  • Developing simple calculations
  • Performing complex calculations
  • Using the expression builder
  • Replacing data
  • Deleting data
  • Updating data

Session VI - Access Report System

Time - 5 hours

Description

This course shows learners how to use Access 2003 to view, organize, and customize reports. It also covers the use of AutoReport, and the Label, Chart, and Report wizards.

Objectives

  • Use AutoReport
  • Print reports and labels
  • Use the report wizard
  • Modify the report printing features

Topics

  • Using AutoReport
  • Viewing the report in print preview mode
  • Customizing the report with page layout
  • Printing labels with the label wizard
  • Adding charts with the chart wizard
  • Using the report wizard
  • Moving to design view
  • Working with the formatting toolbar
  • Viewing and modifying the report
  • Organizing reports with headers and footers
  • Grouping records
  • Fine-tuning the report layout
  • Controlling headers and footers

Session VII - The Internet, Forms, and the Analyzer

Time - 3 hours

Description

This course shows learners how to use Access 2003 to build hyperlinks and publish data to the Web. It also covers building forms, importing and exporting data, and using database analysis tools.

Objectives

  • Build and use hyperlinks
  • Publish Access data to the Web
  • Build a form with the Form Wizard
  • Build a form with the AutoForm Wizard
  • Import and export Access data
  • Use the Table Analyzer

Topics

  • Building hyperlinks
  • Publishing data on the internet
  • Defining forms
  • Building forms using the form wizard
  • Building forms using the AutoForm wizard
  • Enhancing forms
  • Importing and exporting data
  • Using the table analyzer
  • Ten tips for maximizing a database

Top of Course Outline