Practical Access 2007
on 7 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 CONTACT US
 REFERENCE
 LINKS

Testimonials


 

SQLUSA.com
Search

GoogleCheckout
SAVE $10!

Invest in Your Career
Learn Access 2007 from a top database industry expert. Practical Access 2007 is now available on full-motion CD-ROMs with narration. Learn the fun way! Multimedia training is far more effective than classroom training. It simulates the real-world environment providing excellent retention. You can replay the video and audio instructional units as many times as you needed.

Learn Database Queries, Form Design, Reporting and Administration with this easy-to-follow CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning Access 2007 for the first time or adding to your professional skills set, you will find that SMIís Practical Access 2007 Training via CD-ROMô contains thorough, outstanding, well-prepared content that is second to none.

7 CD-ROMs with Over 18 Hours of Instruction
The instructor is Kalman Toth,  video MCDBA, MCITP, Senior SQL Server Database, Data Warehouse and Business Intelligence Architect. By mastering one CD-ROM a day, you can become an Access 2007 professional in just 7 days. You can also proceed at your own pace. The thorough CD-ROM course is focused on practical solutions to real-world Database Design, Form & Report Architecture and Query Building issues. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material.

Audience
Complete Access 2007 video course for Access developers, Access administrator, network administrator, software engineers, systems analysts, and IT managers who design, develop, implement and manage Access 2007 based applications. Database Administrator, C#, VB, Java, C++, .NET and database developers who need to know more personal/shared database techniques in business environment.

Prerequisites
Practical Access 2007 students must have a solid working knowledge of the Windows environment. Access administration and programming experience in SQL, and the knowledge of at least one computer language are helpful. This is best Access 2007 programming/administration multimedia training currently available in North America, or anywhere in the World.

Objectives
Learn the operations of the Access 2007 Database program to perform day-to-day SQL programming, form design & reporting responsibilities; understand the advantages that using relational database software can bring to personal productivity or department level business processes. The course starts with designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing forms & reports based on the information in the database. Experience the in-depth coverage of maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. Build performance indexes and design crosstab queries for powerful summary reports. Learn combo box design as well as adding title, logo, datestamp and images to report. Explore importing data and linking to SQL Server. The course also provides the fundamental knowledge and techniques needed to advance to more complex Access 2007 responsibilities such as maintaining databases and using programming techniques that enhance Access 2007 applications. (See full list below).

About the Trainer
Kalman Toth, MCDBA, is an IT professional with over 16 years of database design, administration and development experience with SQL server 4.2, 6.5, 7.0, 2000 and 2005. Kalman Toth was a developer on IBM's marketing Data Warehouse project operated by Dun & Bradstreet. He has designed OLTP databases, OLAP data warehouses and Performance Tuning solutions for major finance, online dating, health, diet and fitness websites. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Reuters, Lehman Brothers, Salomon Brothers, Merrill Lynch, and IBM. He holds M.Phil degree in Physics and M.Phil. degree in Computing Science from Columbia University, where he had taught computer science Performed Access design & programming at Phibro and Citibank.

CD-ROM Features
SMI's CD-based training is like training one-on-one with an expert -- full motion video allows you to see the steps, hear the explanations, and perform the critical tasks. You can pause the video at any time and practice along. This is the complete training solution for passing a certification exam, excelling on an interview and performing well in the workplace. It is convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. CD-ROM is easy to use, with streamlined interface featuring one-click navigation. 100% guaranteed.

Bonus Book : Microsoft® Office Access 2007 Step by Step
Experience learning made easy —and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

•Build databases from scratch or from templates
•Exchange data with other databases and Office documents
•Create forms to simplify data entry
•Use filters and queries to find and analyze information
•Design rich reports that help make your data meaningful
•Help prevent data corruption and unauthorized access

Your all-in-one learning experience includes:
•Files for building skills and practicing the book’s lessons
•Fully searchable eBook
•Bonus quick reference to the Ribbon, the new Microsoft Office interface
•Windows Vista Product Guide eReference—plus other resources on CD



 
 
Multimedia Practical Access 2007 on 7 full-motion screen image video and rich audio CD-ROMs $395.

Enlarge

Practical Access 2007 on 7 CD-ROMs

CD-ROM 1 - PERSONAL DB TOOL (2 hours 46 minutes)
1. Relational & Access Database Terminology
2. Objects: Tables, Queries, Forms & Reports
3. Designing Reports, Queries, Tables & Forms
4. Menus, Navigation Pane, Toolbar & Ribbon
5. Exploring Access 2007: Northwind Sample Database
6. Local Templates: Contacts, Projects, Tasks & more
7. Business, Education, Personal & Non-profit Templates
8. Creating DB & Tables Manually or from Template
9. Primary & Foreign Keys, Table Relationships
10. Copying, Moving, Migrating & Populating Tables
11. 3NF DB Design, Indexing Columns for Speed
12. Enforcing DB Integrity and Business Rules
13. SQL Query: Data Retrieval from Related Tables
14. Visual SQL Query Designer & Query Wizard
15. INNER JOIN, LEFT JOIN & RIGHT JOIN Operations
16. Logical, Math, Range & String Operators

CD-ROM 2 -ACCESS BASICS (2 hours 49 minutes)
1. Navigating & Managing Datasheet Views
2. Configuring Record Display in a Datasheet
3. Filtering, Sorting & Printing Records
4. Data Entry: Creating Forms with the Form Wizard
5. Configuring Controls for Forms
6. Working with Property Sheets & Getting HELP
7. Form Data Update: Pictures & OLE Objects
8. Combo Boxes and List Boxes
9. Preparing Form Headers & Footers
10. Architecting New Reports with Report Wizard
11. Creating a New Report in the Report Designer
12. Building Expressions for Dynamic Reports
13. Saving, Distributing and Printing Reports
14. Extending Access: Visual Basic for Applications
15. Designing Tables with Performance Indexes
16. The Simple & Crosstab Query Wizards

CD-ROM 3 - COMPLEX QUERIES (2 hours 47 minutes)
1. Performing Calculations : Percentages
2. The COUNT, AVG, SUM and TOP n Functions
3. Hiding Fields & Columns, Restricting Data
4. Renaming Fields in Queries, the Lookup Wizard
5. The PivotTable and PivotChart Views
6. Subtotal, Total & Grand Total Calculations
7. Aggregate Queries in Design View
8. Building Multi-Dimensional Crosstab Queries
9. Inserting (Appending) Information into a Table
10. Updating Information in a Table
11. Deleting Information from a Table
12. Find Duplicate & Unmatched Query Wizards
13. UNION, Pass-Through & DDL Queries
14. SQL Subqueries in an Access Query
15. Creating & Troubleshooting Action Queries
16. TOP 10 Query Design Tips

CD-ROM 4 - COMPLEX FORMS (2 hours 54 minutes)
1. Setting & Managing Control Properties
2. Architecting & Integrating Subforms
3. Tab Stops, Option Groups & Check Boxes
4. Split Form and Multiple Items Form
5. Creating PivotChart Form, Sorting & Filtering
6. Arrange Tab - Anchoring & Autoformat Wizard
7. Combo Box Advanced Settings
8. Title, Logo and Datestamp Control
9. Image Control, Background Pictures & Animation
10. Form Tabbing, Input Masks & Fill/Back Color
11. Dialog Box for Options Collection & Gridlines
12. Composing SQL Statement & View Code
13. Adding Command, Cancel & Default Buttons
14. Designing Forms for Multi-Table Operations
15. Architecting Powerful Forms with Tab Control
16. Hyperlink, Rectangle, Line and Font Controls

CD-ROM 5 - COMPLEX REPORTS (2 hours 56 minutes)
1. The Report Wizard & the Label Wizard
2. Creating Blank Report in Layout View
3. Grouping Alphabetically & by Date Intervals
4. Line Numbering & Hiding Repeating Information
5. Apply AutoFormat Style and Date Formatting
6. Adding Totals and % Totals of Grand Total
7. Configuring Multi-Level Totals & Averages
8. Arrange Tab - Control Layout & Alignment
9. Applying Text, Number and Date Filters
10. Page Layout - Page Setup Dialog Box
11. Conditional Formatting of a Text Box
12. Show/Hide Options, Centering and Print Preview
13. Designing Reports with Multi-Table Sources
14. Data Visualization with Charts
15. Adding Subreport & Object Frame to Report
16. Logo, Image, Hyperlink & Attachment

CD-ROM 6 - DATA EXCHANGE (2 hours 40 minutes)
1. Opening Older Databases with Access 2007
2. Linking to SQL Server Databases
3. Linking to ODBC Data Sources & Excel
4. Integrate with Windows SharePoint Services
5. Importing Data from another Access DB
6. Importing Excel /CSV/Text Data
7. Importing from XML /HTML Files
8. Exporting to Other Access Databases
9. Exporting to Excel/CSV/Text Files
10. Exporting to SQL Server Databases
11. Merge Access Data with Word Document
12. Exporting to XML /HTML Files, Sharepoint List
13. Copying Charts to Other Office Programs
14. Introducing Parameters into Queries
15. Creating Reports with Parameters
16. Architecting Drill-Through Reports

CD-ROM 7 - ADVANCED ACCESS (3 hours 3 minutes)
1. Troubleshooting, Handling Errors & Exceptions
2. Distributing accdb, accde Files & Applications
3. Combo Box Based on Linked SQL Server Tables
4. Updating Linked SQL Server Tables
5. Queries on Linked SQL Server Tables
6. Reports on Linked SQL Server Tables
7. DB Documenter, Performance & Table Analyzer
8. Delivering Business Intelligence through Charts
9. Access Security and Privacy, Trust Center
10. Backup Database & Encrypting/Decrypting
11. Designing Custom Switchboards
12. Configuring Access Options, Macros & Modules
13. Database Relationships & Object Dependencies
14. Upsizing to SQL Server, Database Splitting
15. Business Intelligence Delivery via PivotTables
16. TOP 10 Access 2007 Success Secrets


Availability: the product usually ships on the next business day.

 
 
 
     
  Copyright 2008, Silico-Magnetic Intelligence Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
Access 2007 is a program product of Microsoft Corporation.
SQL Server Integration Services is a program product of Microsoft Corporation.
Business Intelligence Development Studio is a program product of Microsoft Corporation