|
Microsoft Office Access 2007 Training Course
 Our Microsoft Office Training for Access 2007 prepares you for some of the most significant changes to Access in years. Most notable is
the intuitive new user interface that replaces the traditional menus and toolbars with features like the Ribbon, the Quick Access Toolbar, and the Microsoft Office button. This course provides an
introduction to advance training lessons to Access 2007 and demonstrates how to navigate within the new user interface.Learn the steps in planning a database, the components and views of an
Access database, and database creation methods
Audience
End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the
use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.
Our Microsoft Access 2007 Training Course on CD-ROM or Online will feature
- Training done in full multi-media flash format with Audio
- Over 11 hours of training
- Covers Access Basics and Beyond Basics
- Interactive Exercises- allows you to practice what you have learned
- Review Questions
- MS Office 2007 Software not required
- Available as single user CD-ROMs and Network Version
- Used by Thousands of Companies
We also offer the following Access Training courses
You will learn to:
- How to get started.
- Basic Tables.
- Basic Forms.
- Queries and Reports in Access 2007.
- Importing and Exporting Data.
- Advanced Data Management.
Please Note***Demo requires a popup window.
Please turn off your Browser's popup blocker as well
as the popup blocker in your Google toolbar if you have one running.
|
Online Microsoft Access 2007 Course
One Year Access
|
n76051do
|
$129.95
|
|
|
CD-ROM Microsoft Access 2007 Course
|
n76051dc
|
$129.95
|
|
|
Library License Microsoft Access 2007 Course
|
n76051l
|
$399.95
|
|
|
CD-ROMs Microsoft Office 2007 Courses - Access, Excel, PowerPoint, Outlook and Word
|
noff07c
|
$369.95
|
|
Library License- This licensing allows you to train an unlimited amount of users on a single computer or for the training
to be kept at a single location and individuals would take the training CDs to their individual computer or workstation to
do their training. The Training CDs can not be loaded to a server, installed on the internet or intranet.
The course contains the following Content
Tables
- This course explains the use of table templates, Design and Datasheet views, field creation, data types, and
modifiable properties, and demonstrates the use of masked input fields and indexing. The course also explores
viewing, editing, navigating, sorting, finding, and filtering records, in addition to printing data and implementing and maintaining table relationships.
Forms
- You will learn to explores controls – the available types, how they are added to a form, how their properties are
set, and how they are resized, moved, grouped, and positioned on a form. Our training will demonstrate how forms can be customized using autoformat, or by adding the date and time, page numbers, logos, and other
decorative controls. The creation and management of records in forms using different navigational methods, sorting and filtering options, and printing forms is also covered.
Queries and Reports in Access 2007
- Learn how to use the Query Wizard, demonstrate how to create or modify a query in Design view in order to
achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for
displaying query results, and crosstab, unmatched, and duplicate queries. The use of the Report, Report Wizard,
Blank Report, Report Design, and Label options are covered, as well as how to add and bind controls, group and sort data, and modify sections of a report.
Importing and Exporting Data and Data Presentation
- This course explains and demonstrates the various methods of importing, exporting, and linking to external data
sources. It also describes how to create and modify PivotTables and PivotCharts as an alternate way to organize
and present database data. The options used to apply aggregate functions to a PivotTable, add a calculated field to a PivotTable, and export a PivotTable to an Excel spreadsheet are also discussed in the course.
Advanced Data Management
- You will receive demonstrations in retrieving and validating data, using subforms and subreports, as well as
applying conditional formatting in Access 2007 tables, forms, and reports. Advanced query methods make it
easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a
way that the data is easy to interpret and analyze. This course describes the various types of join and parameter
queries that can be used and provides demonstrations on the use of action queries, including update, append,
delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.
|
|
Cisco®, Cisco Systems®, CCDA™, CCNA ™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo Networking Academy and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc and/ or its affiliates in the U.S and certain other countries. All other trademarks mentioned in this document or Web site are the property of their respective owners .
|
|
