Courses Infomation

Integrity Training – Microsoft Office Access 2010 Advanced

**More information:

Description

This very basic training course on Microsoft Windows 7 is part of the two course series on Microsoft Windows 7 operating system. The course gives an overview of the new features in Microsoft Windows 7 operating system and enables the students to navigate through Windows 7 interface by learning the basic concepts. This basic course is designed for inexperienced professionals who are beginning to use personal computers at their home, office or educational institute.

Microsoft Windows is the most widely used personal computer operating system in the world. Anyone who wants to use computers should have a little know-how of this operating system. This course develops the essential skills of navigation and usage of Windows 7 so that the beginners get the feel of the interface and the features it has to offer.

Course Curriculum

Introduction

StartCourse Introduction (0:41)
StartInstructor Introduction (0:37)

Unit 01 Querying with SQL

StartQuerying with SQL (0:17)
StartTopic A: SQL and Access (0:06)
StartSample SQL Statements (1:31)
StartA Query in SQL View (0:43)
StartDemo A2: Examining a SQL Statement in Access (2:28)
Start

Topic B: Writing SQL Statements (0:26)
StartWriting a SQL Statement (0:21)
StartDemo B1: Writing a SQL SELECT Statement (2:24)
StartSyntax for WHERE Clause (0:37)
StartDemo B2: Using the WHERE Clause (0:59)
StartAliases (0:59)
StartDemo B3: Creating Aliases (3:10)
StartSyntax to Display Matched Records (1:04)
StartDemo B4: Displaying Matching Records from Related Tables (2:39)
StartSyntax to Display Unmatched Records (1:22)
StartDemo B5: Finding Unmatched Records (2:21)
StartContext – Sensitive Help (0:28)
StartDemo B6: Getting Context - Sensitive Help on SQL (1:09)
StartTopic C: Attaching SQL Queries to Controls (0:07)
StartSQL – Specific Queries (0:30)
StartCreate a Union Query (0:58)
StartAttach a SQL Query to a Button (0:54)
StartCommand Button Wizard (0:17)
StartDemo - C1: Assigning a SQL Query to a Command Button (3:24)
StartUnit 01 Review (0:17)
StartUnit 01 Quiz

Unit 02 Advanced Queries

StartAdvanced Queries (0:18)
StartTopic A: Creating Crosstab Queries (0:05)
StartA Crosstab Query Result (0:46)
StartDemo - A1: Viewing a Crosstab Query (0:57)
StartCreate a Crosstab Query (0:38)
StartThe Crosstab Query Wizard (0:29)
StartDemo - A2: Using the Crosstab Query Wizard (1:51)
StartTopic B: Creating Parameter Querie (0:07)
StartCreate a Single – Criterion Query (1:21)
StartDemo - B1: Creating a Single – Criterion Parameter Query (2:31)
StartCreate a Multiple-Criteria Query (1:08)
StartDemo – B2: Creating a Query with Multiple Parameters (2:32)
StartCreate a Wildcard Query (1:19)
StartDemo B3: Using a Wildcard in a Parameter Query (2:25)
StartTopic C: Using Action Queries (0:10)
StartTypes of Action Queries (0:18)
StartUse an Append Query (0:43)
StartDemo C1: Adding Records to a Table with an Append Query (2:42)
StartUse a Delete Query (1:12)
StartDemo C2: Deleting Records with a Delete Query (3:59)
StartUse an Update Query (1:16)
StartDemo C3: Modifying Records with an Update Query (3:31)
StartUse a Make Table Query (0:47)
StartDemo C4: Creating a Make Table Query (1:59)
StartUnit 02 Review (0:20)
StartUnit 02 Quiz

Unit 03 Macros

StartMacros (0:14)
StartTopic A: Creating, Running, and Modifying Macros (0:08)
StartSample Macro (2:05)
StartThe Macro Tools | Design Tab (1:30)
Start

Demo A1: Creating and Running a Macro (2:33)
StartDemo A2: Modifying a Macro (1:41)
StartTopic B: Attaching Macros to the Events of Database Objects (0:07)
StartThe Event Tab (0:52)
StartDemo B1: Attaching a Macro to the Open Event of a Form (1:37)
StartAttach Macro to Command Button (0:48)
StartDemo B2: Attaching a Macro to a Command Button (1:50)
StartUnit 03 Review (0:18)
StartUnit 03 Quiz

Unit 04 Advanced Macros

StartAdvanced Macros (0:30)
StartTopic A: Creating Macros to Provide User Interaction (0:12)
Start

Sample Macro with a Condition (3:21)
StartCreate a Data Validation Macro (0:51)
StartDemo A1: Creating a Data Validation Macro (6:16)
StartCreate a Data Entry Macro (1:03)
StartDemo A2: Creating a Data Entry Macro (7:16)
StartTopic B: Creating Macros that Require User Input (0:07)
StartMacro to Run a Parameter Query (0:47)
StartDemo B1: Creating a Macro that Runs a Parameter Query (3:03)
Start

Topic C: Creating AutoKeys and AutoExec Macros (0:09)
StartThe AutoKeys Macro (2:05)
StartDemo C1: Creating an AutoKeys Macro (3:09)
StartCreate an AutoExec Macro (0:46)
StartDemo C2: Creating an AutoExec Macro (1:07)
StartTopic D: Creating Macros for Data Transfer (0:07)
StartThe Import Export Data Action (1:47)
StartDemo D1: Importing a Database Object by Using a Macro (2:40)
StartExport Data to a Spreadsheet (0:38)
StartDemo D2: Exporting Data to a Spreadsheet by Using a Macro (2:07)
StartUnit 04 Review (0:32)
StartUnit 04 Quiz

Unit 05 Importing, Exporting, and Linking

StartImporting, Exporting, and Linking (0:27)
StartTopic A: Importing Objects (0:08)
Start

Import Objects from a Database (1:01)
StartThe Import Objects Dialog Box (0:33)
StartDemo A1: Importing Multiple Objects (1:46)
StartImport Objects from Excel (1:15)
StartDemo A2: Importing an Object from Excel (3:15)
StartManage Data Tasks (0:50)
StartDemo A3: Using a Saved Import Specification (1:21)
StartFixed Width vs. Delimited Format (1:43)
StartDemo A4: Importing a CSV File (2:03)
StartTopic B: Exporting Objects (0:06)
StartExport Objects from a Database (0:57)
StartThe Export Table Dialog Box (0:45)
StartDemo B1: Exporting an Object (2:12)
StartDemo B2: Using a Saved Export Specification (1:16)
StartTopic C: Working with XML Documents (0:05)
StartExport as XML (1:01)
StartThe Export XML Dialog Box (0:40)
StartThe Import XML Dialog Box (0:44)
StartDemo C1: Exporting and Importing XML Documents (3:56)
StartExport with an XSL File (0:37)
StartDemo C2: Exporting to an XML Document with an XSL File (2:36)
StartPublish as PDF or XPS (1:39)
StartDemo C3: Saving a Table as an XPS File (1:50)
StartTopic D: Linking Access Objects (0:06)
Start

Link a Table (1:30)
StartDemo D1: Linking to an Access Table (3:40)
StartUpdate a Link (1:14)
StartLinked Table Manager (1:22)
StartDemo D2: Updating Links (2:24)
Start

Link to an Excel Workbook (1:02)
StartDemo D3: Linking to an Excel Workbook (1:52)
StartTopic E: Using Hyperlink Fields (0:05)
StartCreate a Hyperlink Field (1:21)
StartDemo E1: Creating a Hyperlink Field (1:11)
StartThe Insert Hyperlink Dialog Box (0:56)
StartDemo E2: Inserting Data in a Hyperlink Field (0:40)
StartModify Hyperlink Data (0:25)
StartDemo E3: Modifying Data in a Hyperlink Field (1:36)
StartUnit 05 Review (0:40)
StartUnit 05 Quiz

Unit 06 Database Management

StartDatabase Management (0:20)
StartTopic A: Optimizing Resources (0:07)
StartConvert to a Prior Version (1:58)
StartDemo A1: Converting a Database to a Prior Version (1:15)
StartThe Performance Analyzer (1:09)
StartPerformance Analyzer Results (1:15)
StartDemo A2: Analyzing Performance (1:48)
StartSplit a Database (1:15)
StartDemo A3: Splitting a Database (2:23)
StartCompact and Repair a Database (1:28)
StartDemo A4: Using the Compact and Repair Database Utility (1:43)
StartBack Up the Active Database (0:44)
StartDemo A5: Backing up a Database (0:52)
StartTopic B: Protecting Databases (0:07)
StartEncrypt and Password-Protect (1:12)
StartDemo B1: Encrypting a Database with a Password (2:04)
StartRemove Password and Encryption (0:30)
StartDemo B2: Removing a Password and Encryption (0:48)
StartTopic C: Setting Options and Properties (0:07)
StartThe Access Options Dialog Box (1:16)
StartDemo C1: Setting Access Options (2:18)
StartDatabase Properties Dialog Box (1:03)
StartDemo C2: Creating and Populating Database Properties (1:24)
StartUnit 06 Review (0:21)
StartUnit 06 Quiz
StartCourse Closure (1:11)

Forex Trading – Foreign Exchange Course

Want to learn about Forex?

Foreign exchange, or forex, is the conversion of one country’s currency into another.
In a free economy, a country’s currency is valued according to the laws of supply and demand.
In other words, a currency’s value can be pegged to another country’s currency, such as the U.S. dollar, or even to a basket of currencies.
A country’s currency value may also be set by the country’s government.
However, most countries float their currencies freely against those of other countries, which keeps them in constant fluctuation.

Salepage : Integrity Training – Microsoft Office Access 2010 Advanced