|
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.
|
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
|
|
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 .
|
|
