|
|
|
|
|
|
|
|
Microsoft Access 2007 CD Training Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "MS Office 2007 Courses"]
|
|
|
| Product: |
Microsoft Access 2007 CD Training Course
8.5hrs / 132 lessons. For Win Vista, XP, 2000, Mac OS X, OS 9, Linux
|
| Price: |
|
|
|
| Details: |
Introducing Access 2007
Course Introduction (03:29)
What is Microsoft Access? (03:59)
About Relational Databases (04:03)
Access and SQL Server (03:21)
Getting He|p pt. 1 (04:02)
Getting He|p pt. 2 (04:41)
Staying Up-to-Date (04:03)
Exploring Access 2007
Using the Getting Started Window (04:12)
Introducing the Ribbon (04:48)
Using the Navigation Pane (04:33)
Opening and Closing Databases (04:31)
Managing Macro Security (04:31)
Exploring Tables (04:40)
Exploring Queries (04:37)
Exploring Forms (04:11)
Exploring Reports (03:26)
Exploring Macros (03:47)
Exploring Modules (02:29)
Creating a Database
Creating a Database from a Template (05:21)
Creating a Database from Scratch (04:53)
Creating a Table from a Template (04:43)
Creating a Table from Scratch (04:57)
Using Fields and Data Types pt. 1 (04:17)
Using Fields and Data Types pt. 2 (04:30)
Setting Table Properties (04:40)
Working in Datasheet View pt. 1 (04:52)
Working in Datasheet View pt. 2 (04:54)
Importing Data
Leveraging Data Import (03:27)
Importing from Text pt. 1 (04:41)
Importing from Text pt. 2 (04:38)
Importing from Excel (03:51)
Importing from XML (04:29)
Importing from Outlook (02:57)
Importing from Access (03:49)
Exporting Data
Exporting to Text (04:04)
Exporting to Excel (02:47)
Exporting to XML (03:15)
Exporting to Word (03:15)
Exporting to Access (03:19)
Modifying Table Design
Renaming Tables (03:45)
Dropping Tables (02:36)
Managing Fields pt. 1 (04:03)
Managing Fields pt. 2 (04:55)
Managing Fields pt. 3 (03:40)
Using Undo and Redo (04:52)
Changing the Primary Key pt. 1 (03:51)
Changing the Primary Key pt. 2 (04:10)
Setting Table Relationships pt. 1 (03:56)
Setting Table Relationships pt. 2 (04:45)
Setting Table Relationships pt. 3 (02:47)
Using the Table Analyzer Wizard (03:16)
Maintaining Data Integrity
Introduction to Data Types (04:15)
Managing Data Types pt. 1 (04:02)
Managing Field Data Types pt. 2 (03:12)
Setting Field Length (03:17)
Using Input Masks pt. 1 (04:25)
Using Input Masks pt. 2 (04:08)
Using Default Values pt. 1 (03:08)
Using Default Values pt. 2 (03:00)
Setting a Validation Rule (04:52)
Creating a Lookup List pt. 1 (03:47)
Creating a Lookup List pt. 2 (03:30)
Creating a Lookup List pt. 3 (04:52)
Compacting the Database (01:39)
Backing Up the Database (01:19)
Using Forms
Understanding Forms (04:16)
Navigating in Forms (03:54)
Creating a Form Quickly (04:41)
Using the Form Wizard (04:03)
Understanding Form Views (03:39)
Creating a Blank Form pt. 1 (03:22)
Creating a Blank form pt. 2 (03:32)
Aligning Controls (04:24)
Sizing Controls (04:50)
Controlling Data Input (03:44)
Creating an Option Group pt. 1 (03:32)
Creating an Option Group pt. 2 (03:34)
Formatting a Form (03:10)
Using AutoFormat (02:04)
Setting Tab Order (01:33)
Creating Subforms pt. 1 (03:18)
Creating Subforms pt. 2 (03:09)
Querying Data
Sorting Table Records (04:15)
Using Basic Filters (04:03)
Using Filter By Form (03:07)
Using Advanced Filters (03:31)
Understanding Queries (04:19)
Using the Query Wizard (04:08)
Designing Select Queries (04:30)
Adding Query Criteria (04:54)
Designing Parameter Queries (03:54)
Using Calculated Fields (03:15)
Designing Action Queries pt. 1 (03:58)
Designing Action Queries pt. 2 (03:54)
Designing Action Queries pt. 3 (05:10)
Generating Totals and Averages (03:24)
Using Expression Builder (03:32)
Working with Reports
Understanding Reports (02:19)
Creating a Report Quickly (03:58)
Using the Report Wizard (04:52)
Formatting a Report (04:49)
Creating a Blank Report pt. 1 (04:27)
Creating a Blank Report pt. 2 (02:49)
Creating a Blank Report pt. 3 (04:40)
Using Queries in Reports (05:26)
Using Calculated Values (04:25)
Previewing and Printing a Report (03:40)
Saving a Report as PDF (03:03)
Securing and Sharing Data
Password-Protecting Your Database pt. 1 (04:08)
Password-Protecting Your Database pt. 2 (04:17)
Securing Database Code (04:24)
Distributing Your Database pt. 1 (04:08)
Distributing Your Database pt. 2 (03:36)
Customizing Your Database
Creating a Switchboard pt. 1 (04:19)
Creating a Switchboard pt. 2 (03:56)
Creating a Switchboard pt. 3 (03:42)
Understanding the Navigation Pane (04:28)
Defining Custom Categories pt. 1 (03:55)
Defining Custom Categories pt. 2 (03:31)
Setting Global Options (04:54)
Customizing Quick Access pt. 1 (03:35)
Customizing Quick Access pt. 2 (04:09)
Creating a Custom Ribbon (04:38)
Using Performance Analyzer (03:41)
Using Database Documenter (02:31)
Five Cool Access Tips and Tricks
Getting Certified in Access 2007 (04:25)
Great Access 2007 Resources (04:10)
Microsoft Virtual Labs (02:40)
Access Ribbon Mapping Workbook (02:44)
Keyboard Shortcuts (04:37)
Wrap-Up
Wrap-Up (03:11)
About the Author
About the Author (03:24) |
|
|
 |
|
From the Best Seller List : Sage Line 50 Training - The Sage software training course contains Basic and Advanced tasks for operation of the Sage accounting software.
CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2011 RCS Limited. All rights reserved. More
... |
