|
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
|
$99.95
|
|
|
CD-ROM Microsoft Access 2007 Course
|
n76051dc
|
$99.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.
|
