OFFICE 2003

Access 2003 Introduction
Access 2003 Intermediate
Access 2003 Advanced
Excel 2003 Introduction
Excel 2003 Intermediate
Excel 2003 Advanced
Outlook 2003 Introduction
Outlook 2003 Advanced
PowerPoint 2003 Introduction
PowerPoint 2003 Advanced
Project 2003 Introduction
Project 2003 Advanced
Project 2003 Essentials
Publisher 2003 Introduction
Publisher 2003 Advanced
Visio 2003 Introduction
Visio 2003 Advanced
Word 2003 Introduction
Word 2003 Intermediate
Word 2003 Advanced

OFFICE 2007

Office 2007 New Features
Access 2007 Introduction
Access 2007 Intermediate
Access 2007 Advanced
Excel 2007 Introduction
Excel 2007 Intermediate
Excel 2007 Advanced
Outlook 2007 Introduction
Outlook 2007 Intermediate
Outlook 2007 Advanced
PowerPoint 2007 Introduction
PowerPoint 2007 Advanced
Project 2007 Introduction
Project 2007 Advanced
Project 2007 Essentials
Publisher 2007 Introduction
Publisher 2007 Advanced
Visio 2007 Introduction
Visio 2007 Advanced
Word 2007 Introduction
Word 2007 Intermediate
Word 2007 Advanced

VBA

Access VBA
Excel VBA
Word VBA

Windows Vista

Vista New features
Vista Introduction
Vista Advanced
Melton IT Training & Services.

Microsoft Access 2007 Advanced Training

Download Course Outline

 

Request Course Quote

Overview and objectives
Microsoft Access 2007 TrainingThis one-day Microsoft Access 2007 Training course builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.

Target audience
You should be comfortable using a personal computer and Microsoft Windows XP or later. You should also have some experience using Access 2007. You will get the most out of this course if your goal is to become proficient using more advanced Access features and functions, such as querying with SQL, using crosstab, parameter, and action queries, creating and running macros, importing, exporting, and linking database objects, optimizing a database, and basic database security.
 

Course prerequisites
Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the following courses or have equivalent experience: Windows XP: Basic, or Windows Vista: Basic and Access 2007: Basic and Access 2007: Intermediate.


Course objectives

Course contents
Querying with SQL • SQL and Access • Writing SQL statements • Attaching SQL queries to controls

Advanced queries • Creating crosstab queries • Creating parameter queries • Using action queries

Macros • Creating, running, and modifying macros • Attaching macros to the events of database objects

Advanced macros • Creating macros to provide user interaction • Creating macros that require user input • Creating the AutoKeys and AutoExec macros • Creating macros for data transfer

Importing, exporting, and linking • Importing objects • Exporting objects • Interacting with XML documents • Linking Access objects • Working with Windows SharePoint Services

Database management • Optimizing resources • Protecting databases • Setting options and properties

Internet integration • Hyperlink fields • Working with Outlook 2007

Download Course Outline

 

Request Course Quote