Integrity Training – Microsoft Office Access 2016 Intermediate

•  
  Start

  Using Data Validation (1:58)

•  
  Start

  Topic A: Use Field Validation (0:10)

•  
  Start

  Field Validation (1:50)

•  
  Start

  Field Properties (0:54)

•  
  Start

  Input Masks (0:37)

•  
  Start

  Input Mask Wizard (0:30)

•  
  Start

  Demo – Validating Data by Using a Field Property (6:10)

•  
  Start

  Demo – Validating Data by Using an Input Mask (4:03)

•  
  Start

  Topic B: Use Form and Record Validation (0:08)

•  
  Start

  The Combo Box Wizard (0:55)

•  
  Start

  List Box Control (0:41)

•  
  Start

  Option Group Control (1:09)

•  
  Start

  Demo – Using a Combo Box Control to Limit Option Values (5:59)

•  
  Start

  Demo – Using a Record Validation Rule (4:48)

•  
  Start

  Chapter 03 Review (0:31)

•  
  Start

  Chapter 03 Quiz

•  
  Start

  Creating Advanced Queries (1:25)

•  
  Start

  Topic A: Create Parameter Queries (0:09)

•  
  Start

  A Parameter Query Displays a Prompt (1:59)

•  
  Start

  Demo – Creating a Parameter Query (3:05)

•  
  Start

  Demo – Using Wildcards in a Parameter Query (3:18)

•  
  Start

  Demo – Creating a Query with Multiple Parameters (2:05)

•  
  Start

  Topic B: Summarize Data (0:06)

•  
  Start

  Crosstab Query Wizard (1:50)

•  
  Start

  Analyzing Customer Payments (0:56)

•  
  Start

  Demo – Creating a Crosstab Query (3:07)

•  
  Start

  Topic C: Create Subqueries (0:09)

•  
  Start

  Subquery Example (1:22)

•  
  Start

  Subquery Expression Example (0:56)

•  
  Start

  Demo – Creating Subqueries (4:45)

•  
  Start

  Topic D: Create Action Queries (0:08)

•  
  Start

  Action Query Update Expression (1:07)

•  
  Start

  Demo – Creating Action Queries (4:09)

•  
  Start

  Topic E: Create Unmatched and Duplicate Queries (0:05)

•  
  Start

  Find Unmatched Query Wizard (1:08)

•  
  Start

  Find Duplicates Query Wizard (0:17)

•  
  Start

  Demo – Creating Queries to Search for Unmatched and Duplicate Records (3:56)

•  
  Start

  Chapter 04 Review (0:48)

•  
  Start

  Chapter 04 Quiz

•  
  Start

  Organizing a Database for Efficiency (0:36)

•  
  Start

  Topic A: Data Normalization (0:09)

•  
  Start

  First Normal Form (2:01)

•  
  Start

  Second Normal Form (1:07)

•  
  Start

  Third Normal Form (0:56)

•  
  Start

  Denormalization (0:59)

•  
  Start

  Table Analyzer Wizard (0:25)

•  
  Start

  Demo – Running the Table Analyzer Wizard (3:18)

•  
  Start

  Topic B: Create a Junction Table (0:08)

•  
  Start

  Junction Table (1:15)

•  
  Start

  Demo – Using a Junction Table to Resolve a Many-to-Many Relationship (2:56)

•  
  Start

  Topic C: Improve Table Structure (0:07)

•  
  Start

  Demo – Improving Table Structure (4:52)

•  
  Start

  Chapter 05 Review (0:35)

•  
  Start

  Chapter 05 Quiz

•  
  Start

  Using Advanced Reporting Techniques (0:32)

•  
  Start

  Topic A: Include Control Formatting in a Report (0:06)

•  
  Start

  Data Bars (0:57)

•  
  Start

  Demo – Adding Data Bars to a Report (2:34)

•  
  Start

  Topic B: Add a Calculated Field to a Report (0:08)

•  
  Start

  Demo – Adding a Calculated Field to a Report (4:25)

•  
  Start

  Topic C: Add a Subreport to an Existing Report (0:09)

•  
  Start

  Demo – Adding a Subreport to an Existing Report (6:48)

•  
  Start

  Chapter 06 Review (0:29)

•  
  Start

  Chapter 06 Quiz

•  
  Start

  Course Closure (1:19)

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.