Microsoft Office 2007: Access Advanced

List Price: $99.00

Sale Price: $79.00

Item Number: PN-Access2k7l3

* denotes required field

Media Content*

Quantity:

Untitled Document

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.

With its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access 2007 helps you track and report information with ease. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.

Package Includes:

3 DVD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Focused on practical solutions to real-world development problems
Free 1 Year Upgrade Policy

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)

This slideshow requires Adobe Flash Player 9.0 (or higher). JavaScript must be enabled.

Unit 01 - Querying with SQL

Topic A: SQL and Access
Sample SQL Statements
A Query in SQL View
Demo A-1: Examining an SQL Statement in Access
Topic B: Writing SQL Statements
Writing an SQL Statement
Demo B-1: Writing an SQL SELECT Statement
Syntax for WHERE Clause
Demo B-2: Using the WHERE Clause
Aliases
Demo B-3: Creating Aliases
Syntax to Display Matched Records
Demo B-4: Displaying Matching Records from Related Tabs
Syntax to Display Unmatched Records
Demo B-5: Finding Unmatched Records
Context-Sensitive Help
Demo B-6: Getting Context-Sensitive Help in SQL
Topic C: Attaching SQL Queries to Controls
SQL Specific Queries
Create a Union Query
Attach a SQL Query to a Button
Command Button Wizard
Demo C-1: Assigning a SQL-Specific Query to a Command Button
Unit 01 Review

Unit 02 - Advanced Queries

Topic A: Creating Crosstab Queries
A Crosstab Query Result
Demo A-1: Viewing a Crosstab Query
Create a Crosstab Query
Demo A-2: Using the Crosstab Query Wizard
Topic B: Creating Parameter Queries
Create a Single-Criterion Query
Demo B-1: Creating a Single-Criterion Parameter Query
Create a Multiple-Criteria Query
Demo B-2: Creating a Query with Multiple Parameters
Create a Wildcard Query
Demo B-3: Using a Wildcard in a Parameter Query
Topic C: Using Action Queries
Types of Action Queries
Use an Append Query
Demo C-1: Adding Records to a Table with an Append Query
Use a Delete Query
Demo C-2: Deleting Records with a Delete Query
Use an Update Query
Demo C-3: Modifying Records with an Update Query
Use a Make Table Query
Demo C-4: Creating a Make Table Query
Unit 02 Review

Unit 03 – Macros

Topic A: Creating, Running, and Modifying Macros
Sample Macro
Create and Run a Macro
Demo A-1: Creating and Running a Macro
Modify a Macro
Demo A-2: Modifying a Macro
Topic B: Attaching Macros to the Events of Database Objects
The Event Tab
Demo B-1: Attaching a Macro to the Open Event of a Form
Attach a Macro to a Command Button
Demo B-2: Attaching a Macro to a Command Button
Unit 03 Review

Unit 04 - Advanced Macros

Topic A: Creating Macros to Provide User Interaction
A Sample Macro with a Condition
Create a Data Verification Macro
Demo A-1: Creating a Data Validation Macro
Create a Data-Entry Macro
Demo A-2: Creating a Data-Entry Macro
Topic B: Creating Macros that Require User Input
A Macro that Runs a Parameter Query
Demo B-1: Creating a Macro that Runs a Parameter Query
Topic C: Creating the AutoKeys and AutoExec Macros
Create an AutoKeys Macro
Demo C-1: Creating an AutoKeys Macro
Create an AutoExec Macro
Demo C-2: Creating an AutoExec Macro
Topic D: Creating Macros for Data Transfer
The TransferDatabase Action of Macros
Demo D-1: Importing a Database Object by Using a Macro
Export Data to Spreadsheet
Unit 04 Review

Unit 05 - Importing, Exporting, and Linking

Topic A: Importing Objects
Import Objects from a Database
Import Objects Dialog Box
Demo A-1: Importing Multiple Objects
Import Objects from Excel
Demo A-2: Importing an Object from Excel
Manage Data Tasks
Demo A-3: Using a Saved Import Specification
Fixed Width vs. Delimited Format
Demo A-4: Importing a CSV File
Topic B: Exporting Objects
Export Objects from a Database
Export Table Dialog Box
Demo B-1: Exporting an Object
Demo B-2: Using a Saved Export Specification
Topic C: Interacting with the XML Documents
Export as XML
Export XML Dialog Box
Import XML Dialog Box
Demo C-1: Exporting and Importing XML Documents
Export with an XSL File
Demo C-2: Exporting to an XML Document with an XSL File
XML Paper Specification Viewer
Topic D: Linking Access Objects
Link a Table
Demo D-1: Linking to an Access Table
Update a Link
Linked Table Manager Dialog Box
Demo D-2: Updating the Links
Link to an Excel Workbook
Demo D-3: Linking to an Excel Workbook
Topic E: Working with Windows SharePoint Services
Export Table to SharePoint Services Site
Export - SharePoint Site Dialog Box
Import from SharePoint Services
Unit 05 Review

Unit 06 - Database Management

Topic A: Optimizing Resources
Convert to a Prior Version
Demo A-1: Converting a Database to a Prior Version
Performance Analyzer Dialog Box
A Sample Performance Analyzer Result
Demo A-2: Analyzing Performance
Split a Database
Demo A-3: Splitting a Database
Compact and Repair a Database
Demo A-4: Using the Compact and Repair Database Utility
Back Up a Database
Demo A-5: Backing Up a Database
Topic B: Protecting Databases
Encrypt and Password Protect
Demo B-1: Encrypting a Database with a Password
Remove Password and Encryption
Demo B-2: Removing a Password and Encryption
Topic C: Setting Options and Properties
Access Options Dialog Box
Demo C-1: Setting Access Options
Properties Dialog Box
Unit 06 Review

Unit 07 - Internet Integration

Topic A: Hyperlink Fields
Create a Hyperlink Field
Demo A-1: Creating a Hyperlink Field
Insert Hyperlink Dialog Box
Demo A-2: Inserting Data in a Hyperlink Field
Modify Hyperlink Data
Demo A-3: Modifying Data in a Hyperlink Field
Topic B: Working with Outlook 2007
Collect Data by Email
Unit 07 Review