Create Tool:Tixati v2.12
Create Time:2015-07-12 01:47:47
File Size:546.31 MB
File Count:57
File Hash:41f38ccf2cf35312a458843dddb6f79a6d5ffe14
| 01. Introduction/01_01-Welcome.mp4 |
| 01. Introduction/01_02-Using the exercise files.mp4 |
| 01. Introduction/01_03-Introducing the database.mp4 |
| 02. Creating Queries in Access/02_01-Understanding queries.mp4 |
| 02. Creating Queries in Access/02_02-Using the Query Wizard.mp4 |
| 02. Creating Queries in Access/02_03-Exploring the design interface.mp4 |
| 03. Creating Simple Select Queries/03_01-Defining criteria.mp4 |
| 03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp4 |
| 03. Creating Simple Select Queries/03_03-Renaming the column headers.mp4 |
| 03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp4 |
| 03. Creating Simple Select Queries/03_05-Working with joins.mp4 |
| 03. Creating Simple Select Queries/03_06-Challenge Find the top ten employees.mp4 |
| 03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp4 |
| 04. Creating Parameter Queries/04_01-Understanding parameter queries.mp4 |
| 04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp4 |
| 04. Creating Parameter Queries/04_03-Creating a combo box.mp4 |
| 04. Creating Parameter Queries/04_04-Challenge Build a query that produces an employee phone list.mp4 |
| 04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp4 |
| 05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp4 |
| 05. Getting Started with Functions/05_02-Using mathematical operators.mp4 |
| 05. Getting Started with Functions/05_03-Applying functions to text.mp4 |
| 05. Getting Started with Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp4 |
| 05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp4 |
| 06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp4 |
| 06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp4 |
| 06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp4 |
| 07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp4 |
| 07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp4 |
| 07. Working with Dates in Queries/07_03-Using date and time functions.mp4 |
| 07. Working with Dates in Queries/07_04-Formatting dates.mp4 |
| 07. Working with Dates in Queries/07_05-Sorting formatted dates.mp4 |
| 07. Working with Dates in Queries/07_06-Defining today`s date.mp4 |
| 07. Working with Dates in Queries/07_07-Calculating time intervals.mp4 |
| 07. Working with Dates in Queries/07_08-Challenge Collect information on all orders from 2014.mp4 |
| 07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp4 |
| 08. Understanding Program Flow Functions/08_01-Introducing IIf.mp4 |
| 08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp4 |
| 08. Understanding Program Flow Functions/08_03-Using the Switch function.mp4 |
| 08. Understanding Program Flow Functions/08_04-Challenge Calculate sales prices for a product line.mp4 |
| 08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp4 |
| 09. Alternative Query Types/09_01-Finding duplicate records.mp4 |
| 09. Alternative Query Types/09_02-Identifying unmatched records.mp4 |
| 09. Alternative Query Types/09_03-Creating crosstab results.mp4 |
| 09. Alternative Query Types/09_04-Creating backups.mp4 |
| 09. Alternative Query Types/09_05-Creating update queries.mp4 |
| 09. Alternative Query Types/09_06-Making, deleting, and appending records.mp4 |
| 10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp4 |
| 10. Exploring SQL Syntax/10_02-Writing SQL queries.mp4 |
| 10. Exploring SQL Syntax/10_03-Writing a union query.mp4 |
| 10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp4 |
| 11. Useful Query Tricks/11_01-Using domain functions.mp4 |
| 11. Useful Query Tricks/11_02-Returning values above or below average.mp4 |
| 11. Useful Query Tricks/11_03-Returning random records from the database.mp4 |
| 11. Useful Query Tricks/11_04-Challenge Find out which products have the highest and lowest markup percentage.mp4 |
| 11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp4 |
| 12. Conclusion/12_01-Next steps.mp4 |
| Exercice Files/Ex_Files_Access2013_QiD.zip |
| http://bt.rutracker.org/ann?uk=XoGCyU1PVl |
| http://bt.rutracker.org/ann?uk=XoGCyU1PVl |
TorrentBank
Copyright © 2024