ITExpertsBlog.com

Microsoft Access 2007 Tutorials  – CBT Training Video

Importing Data

• Leveraging Data Import
• Importing from Text – Lesson 1
• Importing from Text – Lesson 2
• Importing from Excel
• Importing from XML
• Importing from Outlook
• Importing from Access

Exporting Data

• Exporting to Text
• Exporting to Excel
• Exporting to XML
• Exporting to Word
• Exporting to Access

Modifying Table Design

• Renaming Tables
• Dropping Tables
• Managing Fields – Lesson 1
• Managing Fields – Lesson 2
• Managing Fields – Lesson 3
• Using Undo and Redo
• Changing the Primary Key – Lesson 1
• Changing the Primary Key – Lesson 2
• Setting Table Relationships – Lesson 1
• Setting Table Relationships – Lesson 2
• Setting Table Relationships – Lesson 3
• Using the Table Analyzer Wizard

Maintaining Data Integrity

• Introduction to Data Types
• Managing Data Types – Lesson 1
• Managing Field Data Types – Lesson 2
• Setting Field Length
• Using Input Masks – Lesson 1
• Using Input Masks – Lesson 2
• Using Default Values – Lesson 1
• Using Default Values – Lesson 2
• Setting a Validation Rule
• Creating a Lookup List – Lesson 1
• Creating a Lookup List – Lesson 2
• Creating a Lookup List – Lesson 3
• Compacting the Database
• Backing Up the Database

Using Forms

• Understanding Forms
• Navigating in Forms
• Creating a Form Quickly
• Using the Form Wizard
• Understanding Form Views
• Creating a Blank Form – Lesson 1
• Creating a Blank form – Lesson 2
• Aligning Controls
• Sizing Controls
• Controlling Data Input
• Creating an Option Group – Lesson 1
• Creating an Option Group – Lesson 2
• Formatting a Form
• Using AutoFormat
• Setting Tab Order
• Creating Subforms – Lesson 1
• Creating Subforms – Lesson 2

Querying Data

• Sorting Table Records
• Using Basic Filters
• Using Filter By Form
• Using Advanced Filters
• Understanding Queries
• Using the Query Wizard
• Designing Select Queries
• Adding Query Criteria
• Designing Parameter Queries
• Using Calculated Fields
• Designing Action Queries – Lesson 1
• Designing Action Queries – Lesson 2
• Designing Action Queries – Lesson 3
• Generating Totals and Averages
• Using Expression Builder

Working with Reports

• Understanding Reports
• Creating a Report Quickly
• Using the Report Wizard
• Formatting a Report
• Creating a Blank Report – Lesson 1
• Creating a Blank Report – Lesson 2
• Creating a Blank Report – Lesson 3
• Using Queries in Reports
• Using Calculated Values
• Previewing and Printing a Report
• Saving a Report as PDF

Securing and Sharing Data

• Password-Protecting Your Database – Lesson 1
• Password-Protecting Your Database – Lesson 2
• Securing Database Code
• Distributing Your Database – Lesson 1
• Distributing Your Database – Lesson 2

Customizing Your Database

• Creating a Switchboard – Lesson 1
• Creating a Switchboard – Lesson 2
• Creating a Switchboard – Lesson 3
• Understanding the Navigation Pane
• Defining Custom Categories – Lesson 1
• Defining Custom Categories – Lesson 2
• Setting Global Options
• Customizing Quick Access – Lesson 1
• Customizing Quick Access – Lesson 2
• Creating a Custom Ribbon
• Using Performance Analyzer
• Using Database Documenter

Five Cool Access Tips and Tricks

• Getting Certified in Access 2007
• Great Access 2007 Resources
• Microsoft Virtual Labs
• Access Ribbon Mapping Workbook
• Keyboard Shortcuts 

Download

http://rapidshare.com/files/144510400/VTC.Microsoft.Access.2007-CFE.part1.rar

http://rapidshare.com/files/144519731/VTC.Microsoft.Access.2007-CFE.part2.rar

http://rapidshare.com/files/144525111/VTC.Microsoft.Access.2007-CFE.part3.rar

http://rapidshare.com/files/144530195/VTC.Microsoft.Access.2007-CFE.part4.rar

http://rapidshare.com/files/144533650/VTC.Microsoft.Access.2007-CFE.part5.rar

http://rapidshare.com/files/144533943/VTC.Microsoft.Access.2007-CFE.part6.rar