Name: Integrity Training – Microsoft Office Access 2010 Advanced
SKU: ITMOA2A
Price: 40.00 USD
Availability: InStock

-73%

$40.00

Integrity Training – Microsoft Office Access 2010 Advanced

Product Delivery : You will receive a receipt with download link through email

SKU: ITMOA2A Category: Forex & Trading Tags: Integrity Training, Integrity Training – Microsoft Office Access 2010 Advanced, Microsoft Office Access 2010 Advanced

Integrity Training – Microsoft Office Access 2010 Advanced

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

Start

Course Introduction (0:41)
Start

Instructor Introduction (0:37)

Unit 01 Querying with SQL

Start

Querying with SQL (0:17)
Start

Topic A: SQL and Access (0:06)
Start

Sample SQL Statements (1:31)
Start

A Query in SQL View (0:43)
Start

Demo A2: Examining a SQL Statement in Access (2:28)
Start

Topic B: Writing SQL Statements (0:26)
Start

Writing a SQL Statement (0:21)
Start

Demo B1: Writing a SQL SELECT Statement (2:24)
Start

Syntax for WHERE Clause (0:37)
Start

Demo B2: Using the WHERE Clause (0:59)
Start

Aliases (0:59)
Start

Demo B3: Creating Aliases (3:10)
Start

Syntax to Display Matched Records (1:04)
Start

Demo B4: Displaying Matching Records from Related Tables (2:39)
Start

Syntax to Display Unmatched Records (1:22)
Start

Demo B5: Finding Unmatched Records (2:21)
Start

Context – Sensitive Help (0:28)
Start

Demo B6: Getting Context - Sensitive Help on SQL (1:09)
Start

Topic C: Attaching SQL Queries to Controls (0:07)
Start

SQL – Specific Queries (0:30)
Start

Create a Union Query (0:58)
Start

Attach a SQL Query to a Button (0:54)
Start

Command Button Wizard (0:17)
Start

Demo - C1: Assigning a SQL Query to a Command Button (3:24)
Start

Unit 01 Review (0:17)
Start

Unit 01 Quiz

Unit 02 Advanced Queries

Start

Advanced Queries (0:18)
Start

Topic A: Creating Crosstab Queries (0:05)
Start

A Crosstab Query Result (0:46)
Start

Demo - A1: Viewing a Crosstab Query (0:57)
Start

Create a Crosstab Query (0:38)
Start

The Crosstab Query Wizard (0:29)
Start

Demo - A2: Using the Crosstab Query Wizard (1:51)
Start

Topic B: Creating Parameter Querie (0:07)
Start

Create a Single – Criterion Query (1:21)
Start

Demo - B1: Creating a Single – Criterion Parameter Query (2:31)
Start

Create a Multiple-Criteria Query (1:08)
Start

Demo – B2: Creating a Query with Multiple Parameters (2:32)
Start

Create a Wildcard Query (1:19)
Start

Demo B3: Using a Wildcard in a Parameter Query (2:25)
Start

Topic C: Using Action Queries (0:10)
Start

Types of Action Queries (0:18)
Start

Use an Append Query (0:43)
Start

Demo C1: Adding Records to a Table with an Append Query (2:42)
Start

Use a Delete Query (1:12)
Start

Demo C2: Deleting Records with a Delete Query (3:59)
Start

Use an Update Query (1:16)
Start

Demo C3: Modifying Records with an Update Query (3:31)
Start

Use a Make Table Query (0:47)
Start

Demo C4: Creating a Make Table Query (1:59)
Start

Unit 02 Review (0:20)
Start

Unit 02 Quiz

Unit 03 Macros

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

Unit 04 Advanced Macros

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

Unit 05 Importing, Exporting, and Linking

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

Unit 06 Database Management

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)

Get Integrity Training – Microsoft Office Access 2010 Advanced at tenco.pro

Reviews

There are no reviews yet.

Be the first to review “Integrity Training – Microsoft Office Access 2010 Advanced” Cancel reply

You must be logged in to post a review.

After receive your order, It will take 0-12 hours to be download available.

The Course is digital products included PDFs,Videos (MP4,TS,AVI files), Audio (MP3,M4A), Document (Word, Exel,Power Point..)

We will provide the download link accordingly with the Email address on your “Order Reciep”.

Contact Email : [email protected]
Skype : [email protected]