Integrity Training – Microsoft Office Access 2010 Advanced

•  
  Start

  Macros (0:14)

•  
  Start

  Topic A: Creating, Running, and Modifying Macros (0:08)

•  
  Start

  Sample Macro (2:05)

•  
  Start

  The Macro Tools | Design Tab (1:30)

•  
  Start

  Demo ­ A1: Creating and Running a Macro (2:33)

•  
  Start

  Demo ­ A2: Modifying a Macro (1:41)

•  
  Start

  Topic B: Attaching Macros to the Events of Database Objects (0:07)

•  
  Start

  The Event Tab (0:52)

•  
  Start

  Demo ­ B1: Attaching a Macro to the Open Event of a Form (1:37)

•  
  Start

  Attach Macro to Command Button (0:48)

•  
  Start

  Demo ­ B2: Attaching a Macro to a Command Button (1:50)

•  
  Start

  Unit 03 Review (0:18)

•  
  Start

  Unit 03 Quiz

•  
  Start

  Advanced Macros (0:30)

•  
  Start

  Topic A: Creating Macros to Provide User Interaction (0:12)

•  
  Start

  Sample Macro with a Condition (3:21)

•  
  Start

  Create a Data Validation Macro (0:51)

•  
  Start

  Demo ­ A1: Creating a Data Validation Macro (6:16)

•  
  Start

  Create a Data Entry Macro (1:03)

•  
  Start

  Demo ­ A2: Creating a Data Entry Macro (7:16)

•  
  Start

  Topic B: Creating Macros that Require User Input (0:07)

•  
  Start

  Macro to Run a Parameter Query (0:47)

•  
  Start

  Demo ­ B1: Creating a Macro that Runs a Parameter Query (3:03)

•  
  Start

  Topic C: Creating AutoKeys and AutoExec Macros (0:09)

•  
  Start

  The AutoKeys Macro (2:05)

•  
  Start

  Demo ­ C1: Creating an AutoKeys Macro (3:09)

•  
  Start

  Create an AutoExec Macro (0:46)

•  
  Start

  Demo ­ C2: Creating an AutoExec Macro (1:07)

•  
  Start

  Topic D: Creating Macros for Data Transfer (0:07)

•  
  Start

  The Import Export Data Action (1:47)

•  
  Start

  Demo ­ D1: Importing a Database Object by Using a Macro (2:40)

•  
  Start

  Export Data to a Spreadsheet (0:38)

•  
  Start

  Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro (2:07)

•  
  Start

  Unit 04 Review (0:32)

•  
  Start

  Unit 04 Quiz

•  
  Start

  Importing, Exporting, and Linking (0:27)

•  
  Start

  Topic A: Importing Objects (0:08)

•  
  Start

  Import Objects from a Database (1:01)

•  
  Start

  The Import Objects Dialog Box (0:33)

•  
  Start

  Demo ­ A1: Importing Multiple Objects (1:46)

•  
  Start

  Import Objects from Excel (1:15)

•  
  Start

  Demo ­ A2: Importing an Object from Excel (3:15)

•  
  Start

  Manage Data Tasks (0:50)

•  
  Start

  Demo ­ A3: Using a Saved Import Specification (1:21)

•  
  Start

  Fixed Width vs. Delimited Format (1:43)

•  
  Start

  Demo ­ A4: Importing a CSV File (2:03)

•  
  Start

  Topic B: Exporting Objects (0:06)

•  
  Start

  Export Objects from a Database (0:57)

•  
  Start

  The Export Table Dialog Box (0:45)

•  
  Start

  Demo ­ B1: Exporting an Object (2:12)

•  
  Start

  Demo ­ B2: Using a Saved Export Specification (1:16)

•  
  Start

  Topic C: Working with XML Documents (0:05)

•  
  Start

  Export as XML (1:01)

•  
  Start

  The Export XML Dialog Box (0:40)

•  
  Start

  The Import XML Dialog Box (0:44)

•  
  Start

  Demo ­ C1: Exporting and Importing XML Documents (3:56)

•  
  Start

  Export with an XSL File (0:37)

•  
  Start

  Demo ­ C2: Exporting to an XML Document with an XSL File (2:36)

•  
  Start

  Publish as PDF or XPS (1:39)

•  
  Start

  Demo ­ C3: Saving a Table as an XPS File (1:50)

•  
  Start

  Topic D: Linking Access Objects (0:06)

•  
  Start

  Link a Table (1:30)

•  
  Start

  Demo ­ D1: Linking to an Access Table (3:40)

•  
  Start

  Update a Link (1:14)

•  
  Start

  Linked Table Manager (1:22)

•  
  Start

  Demo ­ D2: Updating Links (2:24)

•  
  Start

  Link to an Excel Workbook (1:02)

•  
  Start

  Demo ­ D3: Linking to an Excel Workbook (1:52)

•  
  Start

  Topic E: Using Hyperlink Fields (0:05)

•  
  Start

  Create a Hyperlink Field (1:21)

•  
  Start

  Demo ­ E1: Creating a Hyperlink Field (1:11)

•  
  Start

  The Insert Hyperlink Dialog Box (0:56)

•  
  Start

  Demo ­ E2: Inserting Data in a Hyperlink Field (0:40)

•  
  Start

  Modify Hyperlink Data (0:25)

•  
  Start

  Demo ­ E3: Modifying Data in a Hyperlink Field (1:36)

•  
  Start

  Unit 05 Review (0:40)

•  
  Start

  Unit 05 Quiz

•  
  Start

  Database Management (0:20)

•  
  Start

  Topic A: Optimizing Resources (0:07)

•  
  Start

  Convert to a Prior Version (1:58)

•  
  Start

  Demo ­ A1: Converting a Database to a Prior Version (1:15)

•  
  Start

  The Performance Analyzer (1:09)

•  
  Start

  Performance Analyzer Results (1:15)

•  
  Start

  Demo ­ A2: Analyzing Performance (1:48)

•  
  Start

  Split a Database (1:15)

•  
  Start

  Demo ­ A3: Splitting a Database (2:23)

•  
  Start

  Compact and Repair a Database (1:28)

•  
  Start

  Demo ­ A4: Using the Compact and Repair Database Utility (1:43)

•  
  Start

  Back Up the Active Database (0:44)

•  
  Start

  Demo ­ A5: Backing up a Database (0:52)

•  
  Start

  Topic B: Protecting Databases (0:07)

•  
  Start

  Encrypt and Password-­Protect (1:12)

•  
  Start

  Demo ­ B1: Encrypting a Database with a Password (2:04)

•  
  Start

  Remove Password and Encryption (0:30)

•  
  Start

  Demo ­ B2: Removing a Password and Encryption (0:48)

•  
  Start

  Topic C: Setting Options and Properties (0:07)

•  
  Start

  The Access Options Dialog Box (1:16)

•  
  Start

  Demo ­ C1: Setting Access Options (2:18)

•  
  Start

  Database Properties Dialog Box (1:03)

•  
  Start

  Demo ­ C2: Creating and Populating Database Properties (1:24)

•  
  Start

  Unit 06 Review (0:21)

•  
  Start

  Unit 06 Quiz

•  
  Start

  Course 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.